2024.12.11 ã¨ã³ã¸ãã¢çµç¹ã®ãªã¢ã«ãªå¤±æçµé¨ããå¦ã¶ï¼ çç£æ§åä¸ï¼ãã¼ã å¼·åTips
2024.12.11 ã¨ã³ã¸ãã¢çµç¹ã®ãªã¢ã«ãªå¤±æçµé¨ããå¦ã¶ï¼ çç£æ§åä¸ï¼ãã¼ã å¼·åTips
ä¾ãã°æ¬¡ã®ãããªãã¼ãã«ããã£ãã¨ããã -- PostgreSQL CREATE TABLE history ( id SERIAL PRIMARY KEY, user_id INTEGER NOT NULL, data TEXT, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ); -- MySQL CREATE TABLE history ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, data TEXT, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ); INSERT INTO history (user_id, data, created_at) VALUES (1, 'First
ããããåãåãããã©ã¼ã ãæä¾ãã¦ããããç¥ãã¬éã«ã¹ãã ã¡ã¼ã«ã®å 害è ã«ãªã£ã¦ãã話ã§ã ã¨ã³ã¸ãã¢ãç¥ã£ã¦ããã¹ã ã¡ã¼ã«éä¿¡ã»éç¨ãã¦ãã¦ãã¡ã¼ã«ã®èªè¨¼æè¡ãã»ãã¥ãªãã£ã«ã¤ãã¦æ稿ãããï¼ by blastengine Advent Calendar 2024 ã®8æ¥ç®ã§ãã è¦ä»¶ ãåãåããå 容ã®ä»ãååãæå±ãã¡ã¼ã«ã¢ãã¬ã¹ã®å ¥åãå¿ é åãåããå®äºå¾ãå ¥åãããã¡ã¼ã«ã¢ãã¬ã¹å®ã«èªåå¿çã¡ã¼ã«ãéã èªåå¿çã¡ã¼ã«ã«ã¯å ¥åãããåãåããå 容ãè¨è¼ãã åæ§ã«æå®ãããµã¼ãã¹æ å½è å®ã«ãåãåããéç¥ã¡ã¼ã«ãéã 以ä¸ã®è¦ä»¶ã§ä½æãã¾ããã å®ç¾æ¹æ³ ã¡ã¼ã«éä¿¡ã«ã¯AWS SESã使ç¨ãã¾ãããåãåãã確å®ãã¿ã³ãæ¼ä¸å¾ã«AWS Lambdaã«ãªã¯ã¨ã¹ããé£ã°ããSESã¨é£æºãã¦ã¡ã¼ã«ãéä¿¡ããæµãã§ãã å®è£ å¾ã®ã㨠å®è£ å¾ããã°ããæ£å¸¸ã«ç¨¼åãã¦ãã¾ããããããã
æè¡é¨ã®é·ç°ã§ãã ãã®ã¨ã³ããªã¯é¢ç½æ³äººã°ã«ã¼ã Advent Calendar 2024ã®6æ¥ç®ã®è¨äºã§ãã ã¿ãªããããµã ãæè¡ç³»ã®ææ°æ å ±ã£ã¦ã©ãããæã«å ¥ãã¦ããã§ããããï¼ ç§ã¯å®¶äºè²å ã®å¿ããã«ãã¾ãã¦èªåã§ã®æ å ±åéããµããããã£ã±ã社å Slackã®æ å ±ãé ¼ãã«ãã¦ãã¾ãã ã³ã³ããã¹ããè¿ã人éãããããå ±æãã¦ãããæ å ±ã¨ãããã¨ã§ã精度ã¯ééãããã¾ããã ããããããèªåãå ±æããå´ã«åããããã«ãªããªãã¨ãªã¨ãããã¨ã§ã ã¾ãã¯ç¤¾å ã®ã¨ã³ã¸ãã¢ã«ã©ããã£ã¦æ å ±ãå¾ã¦ããã®ããèãã¦ã¿ããã¨ã«ãã¾ããã ã¢ã³ã±ã¼ããåã£ã¦ã¿ã ã¨ããããã¨ã§ç¤¾å ã®ã¨ã³ã¸ãã¢åãã«ä»¥ä¸ã®ãããªã¢ã³ã±ã¼ããåã£ã¦ã¿ã¾ããã æé: 11/25ã12/1ã®1é±é ã¢ã³ã±ã¼ãå 容: è·è½(ããã³ãã¨ã³ãorããã¯ã¨ã³ã) æ å ±æºå æ å ±æºã®URL ãã®æ å ±æºãåç §ããç®ç ã³ã¡ã³ã çµæã
ã¯ããã« ã«ããã·ã§ID管çã»èªè¨¼åºç¤ãéçºãã¦ããmanatyï¼@manaty0226ï¼ã§ããã©ã¹ãã¬ã¹ã§éå¬ããã¦ããAWS re:Invent 2024ã«åãã¦åå ãã¦ãã¾ããä»åã¯ãã§ã¼ã¯ãã¼ã¯ã»ãã·ã§ã³ã§éå¬ããããNext-generation SaaS tenant isolation strategiesãã«åå ããã¬ãã¼ãããå±ããã¾ãã ãã§ã¼ã¯ãã¼ã¯ã»ãã·ã§ã³ã§ã¯ç»å£è ã¨è´è¬è ãäºãã«ãã£ã¹ã«ãã·ã§ã³ããªããé²ãã¦ããã¾ããç»å£è ã®è©±ãã¦ããå 容ã«ã¤ãã¦çåã«æãã°æãæãã¦è³ªåã§ãã¾ãããããã§é¢ç½ãè«ç¹ãåºã¦ãããç»å£è ã¯æ·±æããã¦ãããã®ã§ããããããæºåããã話ãèããããå¦ã³ã®æ·±ãæéãéãããã¨ãã§ãã¾ãã ããã³ãåé¢ã¨ã¯ãªã«ã ã»ãã·ã§ã³ã¯ã¾ãããã³ãåé¢ã¨ã¯ãªã«ãããªãããã³ãåé¢ããå¿ è¦ãããã®ããåãããã¦å§ã¾ãã¾ããããã³ãåé¢ã¨ã¯åã«ããã³ã
åè¨äº AWS ECS Fargate Autoscaling ã®å®æ¦çãªåºç¤ç¥è ã®ç¶ãã¨ãããæ´¾ççãªã¨ããã§ããããªç£è¦é ç®ããããªçç±ã§ãããã¡ããããã¨ããåºç¤ç¥èçãªã話ã§ãã å½ããã°ã§ã¯ãç£è¦ãããã°å ¨ã¦ã¨ã·ï¼ãã¨ããæ ¼è¨ãæ¨ãã¦ãã¾ãã®ã§ãç£è¦ã®ä»è¾¼ã¿ããµãã£ã¦ãã人ã¯ä»ããã§ãé å¼µã£ã¦ããã¾ãããã ã¯ããã« ãã¨ãã¨æ¸ãã¤ããã§ããæ¬ã¿ã¤ãã«ã¯ãå ¬å¼ãããã®ããã¥ã¡ã³ããåºããã¨ã§ãã´ãç®±è¡ããã¨æãã¾ããã æ¨å¥¨ã¢ã©ã¼ã â Amazon CloudWatch > Amazon ECS ãããã¾ãæè©®ã¯ããã¥ã¡ã³ãã¨ãããã¨ã§ãããã§ã¯ããå°ãå®æ¦ã«å¯ãæ·»ãå½¢ã§ã¾ã¨ãã¦ãããã°ã¨æãã¾ãã ãã£ããå¬ããç£è¦é ç®ãã«ãã´ãªãã¨ã«æ´çãã¤ã¤ããã®çç±ããè£è¶³æ å ±ã«ãã£ã¦ã楽ããç£è¦ã§ããããã«ãã¦ããããã¨ããã§ããåããã¦èªã¿ããã¨ããã¨ãã¦ã¯ããã®è¾ºãã©ããã ã
ããã¯ãªã« ã©ãããã¬ãããã¯éçºé¨ã®ãããã§ãã ãã®è¨äºã¯ãã¬ãããã¯éçºé¨ Advent Calendar 2024ãã® 2 æ¥ç®ã®è¨äºã§ãï¼ æ¨æ¥ã®è¨äºã¯ãseoink ããã®ãTS ã¦ã¼ã¶ã¼ãåè¦ã® Haskell ãåçµãã¦åã¸ã®èªèããããæ¹ããè¨é²ãã§ãããå¦ã³ã®ã¯ã¯ã¯ã¯æãè©°ã¾ã£ã¦ã¦ããã£ãã...ï¼ï¼ ã¢ããã³ãã«ã¬ã³ãã¼2æ¥ç®ã®æ¬è¨äºã§ã¯ãå¹´æ«ã«ï¼ããããï¼èªã¿ãããªãã¨æã£ã¦ããè¦ä»¶å®ç¾©é¢é£ã®æ¸ç±ã23åç´¹ä»ãã¾ããè¦ä»¶å®ç¾©ã®æ¸ç±ã£ã¦ã¤ãã¤ãæ½è±¡çã ã£ãããèªåã®ç¥ãããæ å ±ã¨ããã¦ããæ°ããã¦èªãã®ãé£ããã§ãããããããã¯ãããããã£ã¨ããã ã£ããã§ãããæè¿èªã¿æ¹ãåãã£ã¦ãã¾ããããããå¬ããã®ã§ãè¦ä»¶å®ç¾©é¢é£æ¸ç±ã®èªã¿æ¹ã«æ©ãã諸æ°ã«åãã¦ãè¦ä»¶å®ç¾©ã®ä¸»è¦ãªè«ç¹ãæ示ããä¸ã§æ¸ç±ãç´¹ä»ãã¦ããã¾ãã æ±ãé åã¨æ±ããªãé å ã§ã¯å ·ä½çã«ãä»åãç´¹ä»ãã/ç´¹
é·å¹´ã®éç¨ã§ãGemfileã¯ããéç¨ããã¨ä¸æããã£ããã¨ããç¥è¦ãèç©ããã¦ããã®ã§ãããã«æ¸ãåºãã¦ã¿ã¦ããã Bundler/OrderedGemsãæå¹åãã RuboCopã® Bundler/OrderedGems Copãæå¹åããã æªãä¾: gem 'puma' gem 'jbuilder' è¯ãä¾: gem 'jbuilder' gem 'puma' ã»ã¯ã·ã§ã³ãåããªã åºæ¬çã«ãç¬èªã®å¤æã§ç©ºè¡ãå ¥ãã¦ã»ã¯ã·ã§ã³ãåãããããªãã ããã§è¨ãã»ã¯ã·ã§ã³ã¨ã¯ã空è¡ã§åºåãããï¼ã¤ã®ã¾ã¨ã¾ããã®ãã¨ã§ãããBundler/OrderedGems ã¯ããã®ã¾ã¨ã¾ãã®ä¸ã§è¾æ¸é ã§ãããã¨ãè¦æ±ããã æªãä¾: gem 'aws-sdk-rails' gem 'aws-sdk-s3' gem 'graphql' gem 'graphql-batch' è¯ãä¾: gem 'aw
Go ã®ã³ãã¥ããã£ã¼ã§æãã話é¡ã«ãªã£ã¦ãããã¼ãã ã¨æãã¾ãã®ã§ãèªåãªãã®èããå ±æãããã¨æãã¾ããããã¸ã§ã¯ãã®å 容ã«ãã£ã¦æ§æãªã©ã¯ããªãéã£ã¦ããã¨æãã¾ãããããã§ã¯ DDD ã使ã£ãWebãµã¼ãã¼ã«ã¤ãã¦ç´¹ä»ãã¾ããããããã¦ã¼ã¹ã±ã¼ã¹ã§ã¯ãªããã¨æãã¾ãã ãã£ã¼ãããã¯ãã³ã¡ã³ããªã©å¤§æè¿ã§ãï¼æè¦äº¤æããã¦ããããã§ãï¼ ãã¡ã¤ã«ã¨ãã¼ã ã¹ãã¼ã¹ Go ã§ã¯ããã¸ã§ã¯ãæ§æããã®ã¾ã¾ãã¼ã ã¹ãã¼ã¹ã«ãªãã¾ããä¸ä¾¿ã ã¨æãæ¹ãããããç¥ãã¾ããããåã¯é常ã«ä½¿ããããã¨æã£ã¦ãã¾ããä»ã®è¨èªã§ã¯ãã°ãã°ãããã¸ã§ã¯ãã®æ§æããã§ã«å¤§ã¾ãã«æ±ºãã¦ãããããããã¯ã³ã¼ããæ¸ãåã«æ±ºããããã«ãããã¨ãåºæ¬ã ã£ãããã¾ããããããGo ã§ã¯ã³ã¼ããæ¸ããªããããã¸ã§ã¯ãã®æ§æãããã±ã¼ã¸ã®è¿½å ã»åé¤ãè¡ããã¨ãä¸è¬çã§ãã ããã¤ã³ã¿ã¼ããã㧠Go ã®åå¿è ãããããã¸ã§
2004å¹´ã®ãªãªã¼ã¹ãã20å¨å¹´ã®ã¢ããã¼ãµãªã¼ãè¿ããä»å¹´ãã¹ã¯ã¨ã¢ããã·ã£ã¼ã®äººæ°ä½ãUltravisitorãããªã¤ã·ã¥ã¼ããããè¶ çµ¶æå·§ã®æ¼å¥ã¨ç·»å¯ãªã¨ãã£ãããéãã¦ãæã¡è¾¼ã¿ï¼çæ¼å¥ãã¹ã¿ã¸ãªï¼ã©ã¤ãã¨ãã£ãå¢çç·ãããä¹±ãæ欲ä½ã§ãããâIambic 9 PoetryâãâTetra-Syncâã¨ãã£ã人æ°æ²ãåé²ãããã¡ã³ããã®æ¯æãæ ¹å¼·ãã¢ã«ãã ã ã ãããªæ¬ä½ãã¹ã¯ã¨ã¢ããã·ã£ã¼ã®ãã£ãªã¢ã決å®ã¥ããä½åã¨ãã¦ç±çã«æ¨ãã®ããã¯ã©ã ãã³ã®ããã ã以åããBe Up A Helloããªãªã¼ã¹æã«ã¹ã¯ã¨ã¢ããã·ã£ã¼ã®é³æ¥½ã«ã¤ãã¦ã¤ã³ã¿ãã¥ã¼ãåããéã«ã¯ãå°ãªããªãç´å¹ ããUltravisitorãã®è©±ã«å²ãã¦ããã»ã©ãä»åã®ãªã¤ã·ã¥ã¼ã«ããã£ã¦ãæ¬ä½ã¨ã®åºä¼ããããã®é³æ¥½çãªã¦ãã¼ã¯ããããã¦ä»åã®ãªãã¹ã¿ã¼ã®æã¤æ義ã«è³ãã¾ã§ãããæ·±ãæ¬ä½ã«ã¤ãã¦è©±ãèããã¨ã«ããã
以ä¸ã®ã»ã¯ã·ã§ã³ã§ã¯ããã¹ããã©ã¯ãã£ã¹ã¢ã©ã¼ã ãè¨å®ãããã¨ããå§ãããã¡ããªã¯ã¹ãä¸è¦§è¡¨ç¤ºãã¦ãã¾ããåã¡ããªã¯ã¹ã«ã¯ããã£ã¡ã³ã·ã§ã³ãã¢ã©ã¼ã ã®ç®çãæ¨å¥¨ãããå¤ããããå¤ã®æ ¹æ ãæéã®é·ãã¨ãã¼ã¿ãã¤ã³ãã®æ°ã表示ããã¾ãã ä¸é¨ã®ã¡ããªã¯ã¹ã¯ãªã¹ãã« 2 å表示ããããã¨ãããã¾ããããã¯ããã®ã¡ããªã¯ã¹ã®ãã£ã¡ã³ã·ã§ã³ã®çµã¿åããã«ãã£ã¦ç°ãªãã¢ã©ã¼ã ãæ¨å¥¨ãããå ´åã«çºçãã¾ãã ã¢ã©ã¼ã ãçºçããããã¼ã¿ãã¤ã³ãæ°ã¯ãã¢ã©ã¼ã ã ALARM ç¶æ ã«ãªãã®ã«å¿ è¦ãªéåãã¼ã¿ãã¤ã³ãã®æ°ã§ããè©ä¾¡æéæ° ã¯ãã¢ã©ã¼ã ã®è©ä¾¡æã«èæ ®ãããæéã®æ°ã§ãããã® 2 ã¤ã®æ°ãåãå ´åãæéã®å¤ããã®æ°ã ãé£ç¶ãã¦ãããå¤ãè¶ ããå ´åã«ã®ã¿ãã¢ã©ã¼ã 㯠ALARM ç¶æ ã«ãªãã¾ããã¢ã©ã¼ã ãçºçããããã¼ã¿ãã¤ã³ãæ°ãè©ä¾¡æéæ°ããå°ãªãå ´åããã®ã¢ã©ã¼ã ã¯ãN ä»¶ä¸ M 件ãã®ã¢ã©ã¼ã
æ°æ©è½ connpass APIã«æ°ããæ©è½ã追å ãã¾ããããã¤ãã³ãè³æä¸è¦§APIããã°ã«ã¼ãä¸è¦§APIããæ°ãã«è¿½å ãããã¤ãã³ãä¸è¦§APIãã«ã°ã«ã¼ããµããã¡ã¤ã³ã§ã®çµãè¾¼ã¿æ©è½ãæ¡å ãã¾ããã詳細ãªä»æ§ãå©ç¨æ¹æ³ã¯ãAPIãªãã¡ã¬ã³ã¹ãã確èªãã ãããAPIå©ç¨ãå¸æãããæ¹ã¯ãconnpassã®APIå©ç¨ã«ã¤ãã¦ãã覧ãã ããã ãç¥ãã 2024å¹´9æ1æ¥ãããconnpassã§ã¯ã¹ã¯ã¬ã¤ãã³ã°ãç¦æ¢ããå©ç¨è¦ç´ã«æè¨ãã¾ããã以éã®æ å ±åå¾ã«ã¯connpass APIããå©ç¨ãã ãããAPIãå©ç¨ã«ã¤ãã¦ã¯ãã«ããã¼ã¸ãã確èªãã ããã
ããã«ã¡ã¯ãä½ã æ¨ã§ããNRIãããã³ã ã®ç¤¾å¤åãåå¼·ä¼ã§ãããã¼ã¿åæåºç¤ãä½ã£ã¦ã¿ãããï½æ§è½æ¸¬å®ç·¨ï½ãã¨ããã¿ã¤ãã«ã§ç»å£ãã¦ãã¾ããããã®åã«è¨è¨ç·¨ã¨ãããã¼ãã§éå¬ãã¦ãããä»åã¯ãã®ç¶ãã§ããã¢ã¼ããã¯ãã£è¨è¨ãããä¸ã§AWSã®ãµã¼ãã¹ãã©ããã観ç¹ã§è©ä¾¡ããã®ããã¾ããã®è£ä»ããåãããã«ã©ããã¦ããã®ãã¨ããã®ãå®éã®æ¸¬å®ä¾ã¨ã¨ãã«è©±ãã¾ããã çºè¡¨è³æã¨å½æ¥ã®åç» å½æ¥ã®çºè¡¨è³æã¨åç»ã§ãã speakerdeck.com www.youtube.com ã¢ã¼ããã¯ãã£ã®é¸å®ã«ã¤ã㦠ã¢ã¼ããã¯ãã£é¸å®ã®é¨åã§åãä¸ããã®ããBIãã¼ã«ã§ããã·ã¥ãã¼ããä½ã£ã¦ãã¼ã¿ãå¯è¦åããä¾ã§ããã»ãã·ã§ã³ä¸ã話ãã¦ããã®ã§ãããã¢ã¼ããã¯ãã£ã®é¸æè¢ã¯æ²¢å±±ããã¾ãããããªä¸ã§ã©ããã£ã¦é¸ã¶ããªã®ã§ãããããã§åãä¸ããä¾ã¯ã¦ã¼ã¶ã¼ãã©ãããå±æ§ã®äººãªã®ãã¨ãããã¨ã§ãã ä¾ãã°ãã
æããã®å人ã«ãããããããã©ãã¯ã¤ã¼ã³ï¼drama queenï¼ã [1]訳注ï¼èå± ããã£ã大è¢è£ãªè¨åã§éå°ã«é¨ãç«ã¦ã人ãæã表ç¾ããæ²åã®ããã¤ã³ãã®ãã¥ã¢ã³ã¹ã«è¿ãã ããããã¨ãã£ã¦ããæ³£ãå«ãã ã人ãæé³´ãã¤ãããããã¨ãã£ãã¹ãã¬ãªã¿ã¤ããªæå³ã§ã®ãã©ãã¯ã¤ã¼ã³ã ã£ãããã§ã¯ãªãã彼女ã¯æé¤ã¨ç¥æ§ã®ãã女æ§ã§ããã®è¡åã¯é常ã«ç®ç«ã¡ã«ãããã®ã ã£ããå®éããã¾ãã«ãç®ç«ã¡ã«ããã®ã§ã彼女ã®åé¡ã«ä½å¹´ãæ°ã¥ããªãã£ãã»ã©ã ã 彼女ã¯å¸¸ã«ã人éé¢ä¿ã®è¤éãªç¶²ã®ç®ã®ä¸å¿äººç©ã ã£ãããã®äººéé¢ä¿ã¯ãã¤ãä¸å®å®ã§ã常ã«ãä½ãããèµ·ãã£ã¦ããã彼女ã¯ããããåé¡ã«ã¤ãã¦ç±å¿ã«èªãããã£ãã彼女ã®è©±ã«å¼ãããè¾¼ã¾ããªãããã«ããã®ã¯è³é£ã®æ¥ã ã£ããç¥ãåã£ã¦ããæåã®10å¹´ãããã¯ã彼女ãããããåé¡ã«ã¤ãã¦èªã度ã«ãç§ãç±å¿ã«ãããèãã¦ãæ§ã ãªè¦ç¹ããåé¡ãæ¤è¨ããããå¾ã解決çãã
æ¦è¦ ãã¾ããã ãã©ãç解ãã¦ããã¤ããã§ãã¡ãã¨ç解ãã¦ããªãã£ãIAMã«ã¤ãã¦ãæ¹ãã¦åå¼·ããã®ã§å¿ããªãããã«ã¾ã¨ããã åèã«ããè³æï¼ ãAWS Black Belt Online SeminarãAWS Identity and Access Management (AWS IAM) Part1 ãAWS Black Belt Online SeminarãAWS Identity and Access Management (AWS IAM) Part2 â»ãã®è¨äºã§å©ç¨ãã¦ããSSã¯ä¸è¨è³æå ã®ãã®ã§ãã詳ããç¥ãããæ¹ã¯ç´æ¥å ã®åç»ãè¦ã¦ãã ããã IAMã«ç»å ´ãã主ãªè¦ç´ IAMã¦ã¼ã¶ IAMã°ã«ã¼ã IAMãã¼ã« ããªã·ã¼ IAMã¦ã¼ã¶ ããã¸ã¡ã³ãã³ã³ã½ã¼ã«ãCLIã§å©ç¨ããã¦ã¼ã¶ããããã¯SDKã§AWSãªã½ã¼ã¹ã¸ã¢ã¯ã»ã¹ããã¢ããªã±ã¼ã·ã§ã³ã®åä½(EC2çã§å®è¡ã
ã¯ããã« åæã¨ãªããã¤ã³ãã»ãã å ·ä½ç㪠Tips ã³ã¼ããèªã¾ãã«ç解ããæè¡ ã¨ãããã Clone ãã ã¤ã³ã¿ãã§ã¼ã¹ã§ç解ãã ãã¹ãã³ã¼ãã§ç解ãã æ £ç¿åã§ç解ãã ã³ã¼ãã®è©³ç´°ãç解ããæè¡ ãããã¬ã使ã ã¨ãããããµã³ãã«ã³ã¼ããæ¸ãã¦ã¿ã åãããªããªãèã åè¦ã³ã¼ãã«å®å ¨ã«å¤æ´ãå ããæè¡ ã¤ã³ã¿ãã§ã¼ã¹ãæããã«ãã Stub ã¨ãã¦ã®å®è£ ãç¨æãã Design Doc ãæ¸ã ãã¹ããæ¸ã ã¾ã¨ã We are hiring !! ã¨ã³ã¸ãã¢æ¡ç¨ãã¼ã¸ã¯ãã¡ã ã«ã¸ã¥ã¢ã«é¢è«ããæ°è»½ã«ã©ãã ã¤ã³ã¿ã¼ã³ã常æåéãã¦ãã¾ã ã¯ãã㫠京é½ãªãã£ã¹å¨ç±ã§ãAIã»æ©æ¢°å¦ç¿ãã¼ã ã®å±±æ¬(@hiro_o918)ã§ãã ãã®ããã°ã¯ãµãã©ã¤ããªãã£ã¹ã®ã¡ã³ãã¼ã§æ稿ãããããã°ãªã¬ã¼ 3 æ¥ç®ã®è¨äºã«ãªãã¾ãã é¢è¥¿å¨ä½ã ã¨ãªãã©ã¤ã³ã§ã®ã³ãã¥ãã±ã¼ã·ã§ã³ã«æ©ã¿ã
AWSã®ALB(Application Load Balancer)ã®ãã°ã¯S3ã«ç½®ããããããã®ä¸èº«ããµã¯ãã¨èª¿ã¹ããã¨ããAthenaã使ãæ¹æ³ãæ¨æºçã§ãä¸è¨ã§æ¡å ããã¦ããããã«ãã¼ãã£ã·ã§ã³å°å½±(Partition Projection)ã§ãã¼ãã«ãä½ã£ã¦Athenaããã¯ã¨ãªããã ãã¼ãã£ã·ã§ã³å°å½±ã使ç¨ã㦠Athena 㧠ALB ã¢ã¯ã»ã¹ãã°ç¨ãã¼ãã«ãä½æãã - Amazon Athena ç§ãå¾æ¥ã¯ãã®æ¹æ³ã使ã£ã¦ããããAthenaã¯ãã©ã¦ã¶ãã使ãã¨åä½ããã£ãããã¦ãããã決ã¾ã£ãã¯ã¨ãªã1åããå®è¡ãã¦çµæãåå¾ãããã ãã®ã¨ããªãã¾ã ãããæ¢ç´¢çã«ã¯ã¨ãªãä½çºãå®è¡ãããã¨ãã«ã¯ä½¿ãåæãæªãã æè¿ä»ã®ããã¸ã§ã¯ãã§DuckDBã使ãããã«ãªã£ã¦ã使ãåæã®è¯ãã«æåãã¦ããããDuckDBã¯ALBã®ãã°ãæ¢ç´¢çã«èª¿ã¹ããã¨ãã«ããã£ã¡ã使ããã¨æã£ã
ããã«ã¡ã¯ãpixivã®namazuã§ãã å æ¥éå¬ãããPIXIV DEV MEETUP 2024ã«ã¦ããpixivã¨ããã·ã¹ãã ã¯ã©ããªå½¢ããã¦ããã®ããããã¯ãªããããã¨ãããã¼ãã§çºè¡¨ãããã¦ããã ãã¾ãããå½æ¥ãã»ãã·ã§ã³ã«ãåå ããã ããçãã¾ãããã¦ãã£ã¼ãããã¯ãããã ããæ¹ã ã«ãæ¹ãã¦æè¬ç³ãä¸ãã¾ãã Webãµã¼ãã¹éçºã«ããã¦é¢ç½ãç¹ã®ä¸ã¤ã¯ãã©ã®ãµã¼ãã¹ããã®è¦ä»¶ãç¶æ³ã«å¿ãã¦ç°ãªãé¸æããªããããã¨ã§ããçµæã¨ãã¦ãé¡ä¼¼ç¹ãããå ´åãããã¾ãããç´°é¨ã«ããã¦åããã®ã¯ãªãããã¹ã¦ãã¦ãã¼ã¯ã§ããå¼ç¤¾å ã§ããã¾ãã¾ãªéããè¦ããã¾ãããæ¥çå ¨ä½ãè¦æ¸¡ãã¨ããã«å¤æ§æ§ãåºãã£ã¦ãããã¨ã§ãããã ä»åã®çºè¡¨ã§ã¯ãpixivã®ã·ã¹ãã ã«é¢ããéè¦ãªè¦ä»¶ãç¶æ³ãããã¤ãåãä¸ããç¾æç¹ã§ã©ã®ãããªæ§é ã«ãªã£ã¦ãããããã¤ã³ãã©ã¹ãã©ã¯ãã£ãããã¯ã¨ã³ãã¢ããªã±ã¼ã·ã§ã³ãé
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}