
ãTechãŠã©ãã 7/23ãPowerPointãHTML1æã«ïŒPostgresãå®ãç¥æµã
ã¹ã©ã€ãã®äœæã»é²èЧã»å ±åç·šéãŸã§ããã¹ãŠãã1ã€ã®HTMLãã¡ã€ã«ãã§å®çµãããšèšããããä¿¡ããããŸããïŒã仿¥ã¯ããããªçºæ³ã®è»¢æã§è©±é¡ã®ããŒã«ã«å ããŠãã¹ã¿ãŒãã¢ããã®å®çªDBã§ããPostgresã®å®è·µã¬ã€ãããããŠã1000åéããšããæ°åãäžäººæ©ãããããªããŒã¯ãã€ã¶ãŸã§ãå®åã«çŽçµãã話é¡ãæããŸããã
ããã«ã¡ã¯ããããã§ãã仿¥ã5åã§æµ·å€Techã®è©±é¡ããã£ããã¢ããããŠãããŸãããã
1. Bento â ãHTML1æãã«åãŸã£ãPowerPoint
äžèšã§ãããšïŒã¹ã©ã€ãã®ç·šéã»é²èЧã»ããŒã¿ã»ãªã¢ã«ã¿ã€ã å ±åç·šéãŸã§ããåäžã®HTMLãã¡ã€ã«ã«è©°ã蟌ãã ãã¬ãŒã³ããŒã·ã§ã³ããŒã«ã§ãã
ãªã話é¡ãïŒBentoã®ãã¡ã€ã«ã¯ãåé ã«JSONã®ããŒã¿ãããã¯ããã®åŸãã«ã¢ããªã±ãŒã·ã§ã³ã³ãŒããäžŠã¶æ§é ã«ãªã£ãŠãããããã¡ã€ã«ãã®ãã®ãã¢ããªããšããŠåäœããŸããè¿å¹Žæ³šç®ããããããŒã«ã«ãã¡ãŒã¹ããããsingle-file appãã®ææ³ããPowerPointãšãã誰ããç¥ã顿ã§äœçŸããç¹ãåºãã£ãããã§ããå ¬éãã¢ãšããŠãE2Eæå·åã€ãã§å šå¡ãåãã¹ã©ã€ããåæç·šéã§ãããã²ã¹ãããã¯ããçšæãããŠããŸãã
ã³ãã¥ããã£ã®åå¿ïŒäœè èªèº«ããã¡ã€ã«æ§é ã®è§£èª¬ãããŠããã»ããããã¬ãŒã³ã§ã¯ãªãå°ããªReactã¢ããªãåäžHTMLã§äœãé¡äŒŒããŒã«ãäœã£ãããšããå ±åãããããã®ã¢ãããŒãèªäœãžã®é¢å¿ã®é«ãããããããŸããäžæ¹ã§ãããã³ã¡ã³ãã§ã¯ãJSå ¥ãã®HTMLãã¡ã€ã«ã¯Outlookãªã©ã®ã¡ãŒã«æ·»ä»ã§ãããã¯ãããªããããšããå®åçãªæžå¿µãæãã£ãŠããŸããã
ãšã³ãžãã¢èŠç¹ïŒé åžã®ããããïŒURLãã€ã³ã¹ããŒã«ãäžèŠããã¡ã€ã«ãæž¡ãã ãïŒã¯ã瀟å ããŒã«ãäžåºŠããã®è³æå ±æã§ã¯åŒ·åãªæŠåšã«ãªããšæããŸãããã ãããã³ããšã³ãã®ç«å ŽããèŠããšãäŒæ¥ç°å¢ã§ã¯ã¡ãŒã«ãã£ã«ã¿ãã»ãã¥ãªãã£ããªã·ãŒã§HTML+JSãã¡ã€ã«ã匟ãããã±ãŒã¹ã¯çŸå®ã«å€ãããé åžã®èªç±ãããæå€§ã®å£²ãã§ãã以äžããããæ®åã®ããã«ããã¯ã«ãªããšäºæ³ããŸããããã§ããã¢ããªïŒãµãŒããŒãèŠããã®ããšããæã蟌ã¿ã厩ã奜äŸã§ãããŒã«ç³»ã®å°ããªãããã¯ãã§ã¯ãã®åœ¢åŒãå¢ããŠããã®ã§ã¯ãªãã§ããããã
åèïŒhttps://bento.page/slides/
2. ã¹ã¿ãŒãã¢ããã®ããã®Postgresãµãã€ãã«ã¬ã€ã
äžèšã§ãããšïŒDBå°ä»»è ã®ããªãã¹ã¿ãŒãã¢ããããPostgresããåããªããããã®å®è·µçãªæ³šæç¹ããŸãšããã¬ã€ãã§ãã
ãªã話é¡ãïŒå€ãã®ã¹ã¿ãŒãã¢ããã¯DBAã眮ããã«PostgresãéçšããŠãããããã¯ç«¶åãã€ã³ããã¯ã¹èšèšãªã©ã®èœãšã穎ãèžãã§ããåŠã¶ããšã«ãªããã¡ã§ãããã®èšäºã¯ã¯ãŒã¯ãããŒãšã³ãžã³ãéçºããHatchet瀟ã«ãããã®ã§ããããããå ã«ç¥ã£ãŠããããã£ããç¥èŠãäœç³»çã«ãŸãšããŠããç¹ãæ¯æãéããŸããã
ã³ãã¥ããã£ã®åå¿ïŒãããããæåã«ããã¹ãã¯ããã¯ã¢ããæŠç¥ã§ã¯ããšããæ ¹æ¬çãªææã®ã»ãããUUIDã¯åºæ¬çã«v7ã䜿ãã¹ãããããã¯ã®ååŸé åºã¯å šã¯ãšãªã§æ±ºå®çã«ãã¹ãããšãã£ãå ·äœçãªè£è¶³ãå¯ããããŠããŸãããŸããããã³ã¡ã³ãã§ã¯ãå®éã®ã¹ã¿ãŒãã¢ããã¯ã¹ã±ãŒãªã³ã°ä»¥åã«ãORMä»»ãã§çSQLã誰ãèªããªããšãã£ãçµç¹çãªåé¡ã§ã€ãŸããããšããè³ã®çã芳å¯ããããŸããã
ãšã³ãžãã¢èŠç¹ïŒç§ã¯ããã³ããšã³ãåŽã§ãããAPIãé ãåå ã远ããšçµå±DBã®ããã¯ãN+1ã«è¡ãçãããšããã®ã¯æ¥åžžçã«çµéšããŸããèšäºæ¬æãããããšãªãããä»åã¯ã³ã¡ã³ãæ¬ã®è£è¶³ïŒuuidv7ãããã¯é åºãã«ã¹ã±ãŒãåé€ã®æ³šæïŒãŸã§å«ããŠä¿åçã ãšæããŸãããç¹ã«ãã«ã¹ã±ãŒãåé€ã¯é«ããªã¥ãŒã ã®ããŒãã«ã§ã¯å±éºããšããææã«ã¯å šé¢çã«åæã§ã䟿å©ãã®è£ã§åé€ãé£éççºããèšèšã¯ãé害ã®ç«çš®ãšããŠæ¬åœã«ããèŠããããã¿ãŒã³ã§ãã
åèïŒhttps://hatchet.run/blog/postgres-survival-guide
3. GigaToken â ããŒã¯ãã€ãºããçŽ1000åãé«éå
äžèšã§ãããšïŒLLMã®ããŒã¯ãã€ãºåŠçãGB/sçŽãåŸæ¥æ¯ã§çŽ1000åã«ãŸã§é«éåããã©ã€ãã©ãªã§ãã
ãªã話é¡ãïŒã1000åããšããæ°åã®ã€ã³ãã¯ãã«å ããäœè ãç¹å®ã®CPUã«æé©åããã®ã§ã¯ãªããããããCPUãšããŒã¯ãã€ã¶ã®çµã¿åããã§äžè²«ããŠéããããã«äœã蟌ãã ç¹ãé©ããåŒã³ãŸããããã³ãããŒã¯ã®ã°ã©ããèŠãŠãæ°åã飲ã¿èŸŒãããŸã§æéãããã£ãããšãã声ãåºãã»ã©ã®çµæã§ãã
ã³ãã¥ããã£ã®åå¿ïŒå·éãªæŽçãšããŠãããŒã¯ãã€ãºã¯æšè«æéå šäœã®0.1%æªæºãªã®ã§ãæšè«ã®é«éåã«ã¯ã»ãŒå¹ããªããç䟡ãåºãã®ã¯ãã©ãã€ãçŽã®ããã¹ããåŠçããäºååŠç¿ããŒã¿ã®ååŠçããšããææãè€æ°ãããŸãããäžæ¹ã§ãå šäœã®0.1%ã1000åéãããåªåãããæé«ã«ãœãããŠã§ã¢ãšã³ãžãã¢ãããããšãããžã§ãŒã¯ã人æ°ãéããŠããŸãã
ãšã³ãžãã¢èŠç¹ïŒæšè«APIã䜿ãåŽã®ç§ãã¡ã«ã¯çŽæ¥ã®æ©æµã¯èãã§ãããããŒã¿ãã€ãã©ã€ã³ãæã€çµç¹ã«ãšã£ãŠã¯ãååŠçã³ã¹ããæ¡ã§å€ãã話ã§ãããããŠå人çã«ã¯ããã®ãããã«ããã¯ã§ãªãå·¥çšã極éãŸã§æé©åãããå§¿å¢ãç¬ã話ã§çµããããããããŸãããå·¥çšåäœãæ¡éãã«éããªããšããããåæã ã£ãåŠçããªã¢ã«ã¿ã€ã ã«ç§»è¡ãããªã©ã䜿ããæ¹èªäœãå€ããããšãããããã§ããååŠçããŒã«ãã§ãŒã³ãžã®åã蟌ã¿ãé²ããšäºæ³ããŠããŸãã
åèïŒhttps://github.com/marcelroed/gigatoken/
仿¥ã®å°ãã¿
RuViewïŒåžè²©ã®WiFiä¿¡å·ã ãã§ãã«ã¡ã©ãäžå䜿ããã«åšå®€æ€ç¥ããã€ã¿ã«ãµã€ã³æšå®ãŸã§è¡ããšãã空éã»ã³ã·ã³ã°ãããžã§ã¯ãããã©ã€ãã·ãŒãšã®äž¡ç«ãšãã芳ç¹ã§ãè峿·±ãã¢ãããŒãã§ãã https://github.com/ruvnet/RuView
voiceboxïŒé³å£°ã¯ããŒã³ã»ãã£ã¯ããŒã·ã§ã³ã»çæããŸãšãããªãŒãã³ãœãŒã¹ã®ãAIãã€ã¹ã¹ã¿ãžãªããGitHub Trendingå ¥ããé³å£°ç³»OSSã®éžæè¢ããŸãäžã€å¢ããŸããã https://github.com/jamiepine/voicebox
John C. Dvorakæ° éå»ïŒPC MagazineãInfoWorldã®ã³ã©ã ã§é·å¹Žæãããããã¯ã³ã©ã ãã¹ãã®John C. Dvorakæ°ã74æ³ã§äº¡ããªããŸãããHNã«ã¯åŸå¹Žã®èªè ããã®è¿œæŒã倿°å¯ããããŠããŸãã https://twitter.com/na_announce/status/2079952538040672302
ãŸãšã
仿¥ã¯ãåäžHTMLãã¡ã€ã«ãšããã¢ããªã®æ°ããé ãæ¹ããPostgreséçšã®å®è·µç¥ããæ¥µç«¯ãªæé©åã®æå³ããšãããããæ¯è²ã®éã話é¡ã§ããããå ±éããã®ã¯"åœããåãçã"èŠç¹ã ã£ãããã«æããŸããã¢ããªã«ãµãŒããŒã¯å¿ é ãªã®ããDBã®å®ç³ã¯æåããå šéšå¿ èŠãªã®ããããã«ããã¯ã§ãªãç®æã®æé©åã¯ç¡é§ãªã®ããçããã®ããŒã ã§ã¯ãPostgresã®éçšã«ãŒã«ãã©ããŸã§ææåã§ããŠããŸããïŒ
#ãšã³ãžã㢠#ããã°ã©ãã³ã° #ãã㯠#æµ·å€æ å ± #Postgres #ããã³ããšã³ã #LLM
ææããŒãã§ã¯ãæ¬æ¥ã®Postgresãµãã€ãã«ã¬ã€ããšHNã³ã¡ã³ãã®ç¥èŠãçµ±åãããã¹ã¿ãŒãã¢ããåãPostgresåæéçšãã§ãã¯ãªã¹ãïŒ12é ç®ã»4ã«ããŽãªïŒããæ²èŒããŠããŸãã