[B! *SQL] yamadarã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yamadar id:yamadar

*SQLã«é–¢ã™ã‚‹yamadarã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (26)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã€AWS re:Invent 2024ã€‘Generative AIã«ã‚ˆã‚‹æœªæ¥ã®UXã®åºƒãŒã‚Šã‚’æ„Ÿã˜ãŸ - ã‚«ãƒŸãƒŠã‚· ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã¯ã˜ã‚ã« ã‚«ãƒŸãƒŠã‚·ã§IDç®¡ç†ãƒ»èªè¨¼åŸºç›¤ã‚’é–‹ç™ºã—ã¦ã„ã‚‹manatyï¼ˆ@manaty0226ï¼‰ã§ã™ã€‚12/6ã¾ã§ãƒ©ã‚¹ãƒ™ã‚¬ã‚¹ã§é–‹å‚¬ã•ã‚Œã¦ã„ãŸAWS re:Invent 2024ã«åˆã‚ã¦å‚åŠ ã—ã¾ã—ãŸã€‚ä»Šå›žã¯æœ€çµ‚æ—¥ã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ§ãƒƒãƒ—ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¨ã—ã¦é–‹å‚¬ã•ã‚ŒãŸã€ŒBuild generative AI-powered search with Amazon Aurora and Amazon RDSã€ã‚’è´è¬›ã—ãŸãƒ¬ãƒãƒ¼ãƒˆã‚’ãŠå±Šã‘ã—ã¾ã™ã€‚ ç”ŸæˆAIã«ã‚ˆã‚‹æ¤œç´¢æ©Ÿèƒ½ã®æ‹¡å¼µ ã“ã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ§ãƒƒãƒ—ã§ã¯æž¶ç©ºã®ECä¼æ¥Baize Bazaarã®ECã‚µã‚¤ãƒˆã«ãŠã‘ã‚‹æ¤œç´¢æ©Ÿèƒ½ã‚’ä½œã‚Šã¾ã™ã€‚å˜ãªã‚‹å…¨æ–‡ä¸€è‡´ã‚„éƒ¨åˆ†ä¸€è‡´æ¤œç´¢ã§ã¯ãªãã€è‡ªç„¶è¨€èªžã«ã‚ˆã‚‹å•ã„åˆã‚ã›ã«å¯¾å¿œã—ãŸã‚Šã€ã‚ã‚‰ã‹ã˜ã‚ç™»éŒ²ã•ã‚ŒãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®å—œå¥½ã«åˆã‚ã›ãŸå•†å“ã‚’æ¤œç´¢çµæžœã¨ã—ã¦è¿”ã™ãŸã‚ã«ç”ŸæˆAIã‚’åˆ©ç”¨ã—ã¾ã™ã€‚ä»Šå›žã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ§ãƒƒãƒ—ã§åˆ©ç”¨ã—ãŸã‚³ãƒ¼ãƒ‰ã¯GitHubã«å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ht
yamadar 2024/12/09
èª¬æ˜Žæ–‡ã®é¡žä¼¼åº¦æ¤œç´¢ï¼‹SQLã‚¯ã‚¨ãƒªçµæžœã‚’ç”ŸæˆAIã«å…¥åŠ›ã—ã¦é¡§å®¢ã¸ã®ãƒªã‚³ãƒ¡ãƒ³ãƒ‰æ„å›³ã‚’å‡ºåŠ›ã€‚ãªã‚‹ã»ã©

@AWS

*PostgreSQL

*SQL

*DB

ç”ŸæˆAI
ãƒªãƒ³ã‚¯
NewSQLã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é©å‘½ã‚’èµ·ã“ã™ã‹ - Netflixã«ãŠã‘ã‚‹CockroachDBã®ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ï½œãƒŸãƒƒã‚¯
è¿‘å¹´ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ–°æ½®æµã«NewSQLã¨å‘¼ã°ã‚Œã‚‹ä¸€ç¾¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ç¾¤ã®ç™»å ´ãŒã‚ã‚‹ã€‚ãã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã‚’ä¸€è¨€ã§ã„ã†ã¨ã€RDBã¨NoSQLã®ã„ã„ã¨ã“ã©ã‚Šã§ã‚ã‚‹ã€‚SQLã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã¨å¼·ã„ãƒ‡ãƒ¼ã‚¿ä¸€è²«æ€§ï¼ˆACIDï¼‰ã¨ã„ã†RDBã®åˆ©ç‚¹ã¨æ°´å¹³æ–¹å‘ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨ã„ã†NoSQLã®é•·æ‰€ã‚’å…¼ãå‚™ãˆãŸå¤¢ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ã€‚ä¸‹å›³ã«è¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã€RDBã¨NoSQLãŒé‹ã„ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ã‚’ç™ºç”Ÿã•ã›ã¦ã„ãŸã®ã«å¯¾ã—ã¦ã€NewSQLã§ã¯ãã‚ŒãŒè§£æ¶ˆã•ã‚Œã¦ã„ã‚‹ã®ãŒåˆ†ã‹ã‚‹ã€‚ RDB vs NoSQL vs NewSQL æœ¬å½“ã«ãã®ã‚ˆã†ãªå¤¢ã®å®Ÿç¾ã«æˆåŠŸã—ã¦ã„ã‚‹ã‹ã€ã¨ã„ã†ã®ã¯ã¾ã è°è«–ãŒç¶šã„ã¦ã„ã‚‹ãŒï¼ˆã‚¯ã‚¨ãƒªã®ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚’å‡ºã™ãŸã‚ã«ãƒ¬ã‚¤ãƒ†ãƒ³ã‚·ã‚’çŠ ç‰²ã«ã—ã¦ã„ã‚‹ã®ã§æœ¬å½“ã«ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ã‚’è§£æ¶ˆã¯ã—ã¦ã„ãªã„ã€ãªã©ã®å•é¡ŒãŒæŒ‡æ‘˜ã•ã‚Œã¦ã„ã‚‹ï¼‰ã€å•†ç”¨ã§ã‚‚åˆ©ç”¨å¯èƒ½ãªè£½å“ã¨ã—ã¦Google Spannerã€TiDBã€YugabyteDBã€Coc
yamadar 2024/04/14
*DB

*SQL

*NewSQL
ãƒªãƒ³ã‚¯
ã€ŒSQLã€ã®èªã¿æ–¹è«–äº‰ã«æ±ºç€ï¼Ÿ ã€Œã—ãƒ¼ãã‡ã‚‹ã€vsã€Œãˆã™ãã‚…ãƒ¼ãˆã‚‹ã€ã«PostgreSQLãŒã‚±ãƒªï¼å† è©žã«ã¯ãã‚Œãã‚Œã‚‚æ³¨æ„ã€ã‚„ã˜ã†ã¾ã®æœã€‘
yamadar 2024/04/12
ãƒã‚¿

*DB

*SQL
ãƒªãƒ³ã‚¯
æ¥å‹™ã§ã©ã‚Œã ã‘SQLåŠ›ãŒã¤ãã®ã‹ ~SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ç”¨ã„ã¦ç¢ºèª~ å‰ç·¨
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚ GMOã‚¢ãƒ‰ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°ã®KONCEã§ã™ã€‚ æ–°å’ã§å…¥ç¤¾ã—ã€æ•°å¹´çµŒã¡ã¾ã—ãŸã€‚æ—¥ã€…ã®æ¥å‹™ã§å¦ã¶ã“ã¨ã¯å¤šã„ã§ã™ãŒã€ä»Šå¹´åº¦ã¯æŠ€è¡“ã®æ·±å €ã‚Šã‚’ãƒ†ãƒ¼ãƒžã«ã‚„ã£ã¦ã„ããŸã„ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯å…¥ç¤¾ã—ã¦DBã‚„SQLã«é–¢ã—ã¦ã¯æ¥å‹™å†…ã§å¦ã¶ã“ã¨ãŒå¤šãã€ç‰¹åˆ¥è¨“ç·´ã‚’ã—ã¦ã„ãŸã‚ã‘ã§ã¯ãªã‹ã£ãŸã®ã§ã™ãŒã€ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã‚’ç”¨ã„ã¦å¦ã³ãªãŒã‚‰ã€æ”¹ã‚ã¦è‡ªåˆ†ã®ç¾çŠ¶ã‚’è¦‹ã¤ã‚ç›´ã—ã¦ã„ã‘ãŸã‚‰ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯å¦ç¿’ã‚’è¡Œã†å´é¢ã¨è‡ªåˆ†è‡ªèº«ã®ãƒ¬ãƒ™ãƒ«ã«ã¤ã„ã¦è¦‹ç›´ã—ã¦ã„ããŸã„ã®ã§ çŸ¥ã£ã¦ã„ãŸ â†’ â—‹ éƒ¨åˆ†çš„ã«çŸ¥ã£ã¦ã„ãŸ â†’ â–³ çŸ¥ã‚‰ãªã‹ã£ãŸ â†’ Ã— ã‚’ä»˜ã‘ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ç›®æ¬¡ SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«ã¤ã„ã¦ â… éƒ¨ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è«–ç†è¨è¨ˆã®ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ 2-1. [â—‹]1ç« ã‚¸ã‚§ã‚¤ã‚¦ã‚©ãƒ¼ã‚¯ï¼ˆä¿¡å·ç„¡è¦–ï¼‰ 2-2. [Ã—]2ç« ãƒŠã‚¤ãƒ¼ãƒ–ãƒ„ãƒªãƒ¼ï¼ˆç´ æœ´ãªæœ¨ï¼‰ 2-3. [â—‹]3ç« IDãƒªã‚¯ãƒ¯ã‚¤ã‚¢ãƒ‰ï¼ˆã¨ã‚Šã‚ãˆãšIDï¼‰ 2
yamadar 2021/06/23
ãƒ‡ã‚¶ã‚¤ãƒ³ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚‚ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚‚ã€ãƒ”ãƒƒã‚¿ãƒªå½“ã¦åµŒã¾ã‚‹ã‚±ãƒ¼ã‚¹ã¯å°‘ãªãã¦ã€çŸ¥è˜ã¨ã—ã¦æŒã£ã¦ãŠãå®Ÿåœ°ã§è©¦è¡ŒéŒ¯èª¤ã—ã¦é©ç”¨ã™ã‚‹é¡žã ã¨æ€ã†

è¨è¨ˆ

*DB

*SQL
ãƒªãƒ³ã‚¯
SQL Training 2021
Transcript SQL æ ªå¼ä¼šç¤¾ AI Shift ä¸‰å®… æ‚ å¤ª 1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 2. SQL I 3.ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ 4. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ 5. ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ 6. å®Ÿè¡Œè¨ˆç”» 7. SQL II ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ â€œA database is an organized collection of inter-related data that models some aspect of the real-world â€œ (CMU) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ã€å®Ÿä¸–ç•Œã®ã‚ã‚‹å´é¢ã‚’ãƒ¢ãƒ‡ãƒ«åŒ–ã—ãŸã€ç§©åº ã ã£ãŸã€ç›¸äº’ã«é–¢é€£ã—ãŸãƒ‡ãƒ¼ã‚¿ã®é›†ã¾ã‚Š DBMS â€¢ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ â—¦ ä¾‹ï¼šMySQL, Oracle Database, SQLite, Mongo DB â€¢ DBMSã®ç›®çš„ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼
yamadar 2021/06/22
*DB

*SQL

æ•™è‚²

ä¼šç¤¾

è³‡æ–™
ãƒªãƒ³ã‚¯
ã€Œåˆ†æžSQLã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ã€ã‚’ã‹ãªã‚ŠçœŸé¢ç›®ã«è€ƒãˆãŸ - Qiita
ç›®æ¬¡ ãªãœSQLã®ã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ãŒé‡è¦ãªã®ã‹ ã“ã®è¨˜äº‹ã®ç›®çš„ ã“ã®è¨˜äº‹ã®å¯¾è±¡è€… åˆ†æžSQLã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ã®æŒ‡é‡ åŸºæœ¬ãƒ«ãƒ¼ãƒ« å‘½åè¦å‰‡ ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆãƒ«ãƒ¼ãƒ« åˆ¥åãƒ«ãƒ¼ãƒ« joinãƒ«ãƒ¼ãƒ« ã‚¯ã‚¨ãƒªåˆ†å‰²ãƒ«ãƒ¼ãƒ« â ã‚³ãƒ¡ãƒ³ãƒˆæ¬„ã§ã€Œã„ã‚„ç§ã¯ã“ã†æ€ã†ï¼ã€ã¨ã„ã†æ„è¦‹ã‚’ãŸãã•ã‚“ã„ãŸã ãã¾ã—ãŸï¼ãœã²ãã¡ã‚‰ã‚‚å¾¡è¦§ãã ã•ã„ï¼ï¼ˆæ±ºã—ã¦æ¶æ„ã§ã¯ãªã„ã§ã™ï¼‰ ãªãœSQLã®ã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ãŒé‡è¦ãªã®ã‹ SQLã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æœªçµŒé¨“è€…ã§ã‚‚ã¨ã£ã¤ãã‚„ã™ã„è¨€èªžã¨è¨€ã‚ã‚Œã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚„åˆ†æžã‚’æœ¬æ¥ã¨ã—ã¦ã„ãªã„äººã§ã‚‚SQLã‚’ä½¿ã†æ©Ÿä¼šãŒå¢—ãˆã¦ãã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãã‚“ãªSQLã§ã™ãŒã€ã“ã¡ã‚‰ã®ãƒ–ãƒã‚°ã§ã‚‚æŒ‡æ‘˜ã•ã‚Œã¦ã„ã‚‹é€šã‚Šã€ä¸€èˆ¬çš„ãªã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ãŒå®šã¾ã£ã¦ã„ã¾ã›ã‚“ã€‚ã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ã¨ã¯ã‚³ãƒ¼ãƒ‰ã®æ›¸ãæ–¹ãƒžãƒŠãƒ¼ã‚ˆã†ãªã‚‚ã®ã§ã€ã©ã“ã§æ”¹è¡Œã™ã‚‹ã‹ã€ç©ºç™½ã¯ã„ãã¤å…¥ã‚Œã‚‹ã‹ã€å¤§æ–‡å—ã‚’ä½¿ã†ã‹ãªã©ã®è«¸ã€…ã‚’æŒ‡ã—ã¾ã™ã€‚ ã‚‚ã—ã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ãŒç„¡ã„ã¨ã“ã‚“ãªäº‹ãŒèµ·ã“ã‚Šã¾ã™ ã‚³ãƒ¼ãƒ‰ã«
yamadar 2021/01/12
äºˆç´„èªžå¤§æ–‡å—ã€ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆæƒãˆã‚‹æ´¾ã ã‘ã©ã€ãƒãƒ¼ãƒ ã§ä½¿ã†ãªã‚‰çµ±ä¸€ã—ãŸãƒ«ãƒ¼ãƒ«ãŒã‚ã‚Œã°ä½•ã§ã‚‚è‰¯ã„ã€‚ãã®å ´åˆã¯å€‹äººã®å¥½ã¿ã‚ˆã‚Šå„ªå…ˆã™ã‚‹ã€‚

*SQL
ãƒªãƒ³ã‚¯
SQLè¨˜è¿°è€…å…¨å“¡ãŒç†è§£ã™ã¹ãSELECTæ–‡ã®è«–ç†çš„ãªå‡¦ç†é †åºã®ãŠè©± - Qiita
2020/9/30è¿½è¨˜ æœ¬è¨˜äº‹ã¯å…ƒã€…ã€ã€ŒSQLè¨˜è¿°è€…å…¨å“¡ãŒç†è§£ã™ã¹ãSELECTæ–‡ã®å®Ÿè¡Œé †åºã®ãŠè©±ã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§æŠ•ç¨¿ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ ã—ã‹ã—ã€çŸ¥è¦‹ã®ã‚ã‚‹æ–¹ã‹ã‚‰ã®ã‚³ãƒ¡ãƒ³ãƒˆã¨è‡ªåˆ†ã§ã‚‚èª¿ã¹ã¦ã¿ãŸçµæžœã€ä»Šå›žç´¹ä»‹ã—ã¦ã„ã‚‹é †åºã¯ã‚ãã¾ã§è«–ç†çš„ãªå‡¦ç†é †åºã§ã‚ã‚Šã€å®Ÿè¡Œé †åºã¨ã¯åˆ¥ç‰©ã¨ã„ã†ã“ã¨ãŒã‚ã‹ã‚Šã¾ã—ãŸã€‚ èª¤ã£ãŸçŸ¥è˜ã‚’å¸ƒæ•™ã—ã¦ã—ã¾ã„ç”³ã—è¨³ã”ã–ã„ã¾ã›ã‚“ã€‚ 2020/9/30ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ã€æœ¬è¨˜äº‹ã®ã‚¿ã‚¤ãƒˆãƒ«ã‚’ã€ŒSQLè¨˜è¿°è€…å…¨å“¡ãŒç†è§£ã™ã¹ãSELECTæ–‡ã®è«–ç†çš„ãªå‡¦ç†é †åºã®ãŠè©±ã€ã«å¤‰æ›´ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ã¯ã˜ã‚ã« ã€ŒSQLã¨ã„ãˆã°ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæ‰±ã†ã‚¹ã‚ãƒ«ã€ã¨æ€ã‚ã‚ŒãŒã¡ã§ã™ãŒã€æœ€è¿‘ã¯ãƒžãƒ¼ã‚±ã‚¿ãƒ¼ã‚„å–¶æ¥ãªã©ã€éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã‚‚SQLã‚’ä½¿ã£ã¦ã€è‡ªã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã—åˆ†æžã™ã‚‹æ–¹ãŒå¢—ãˆã¦ãã¦ã„ã¾ã™ã€‚ ã¾ãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã§ã‚‚ã€ORMä»»ã›ã§ãªã‚“ã¨ãªãç†è§£ã—ã¦ã„ã‚‹çŠ¶æ…‹ã®æ–¹ã‚‚ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ ä»Šå›žã¯ã€ãã‚“ãªæ–¹ã€…ã«ã“ã
yamadar 2020/09/22
*SQL
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã« Â· PostgreSQL Internals
yamadar 2018/10/09
**ã‚ã¨ã§èªã‚€

*SQL

*DB

æœ¬
ãƒªãƒ³ã‚¯
SQLé«˜é€ŸåŒ–ã®ã‚«ã‚®ã¯ã€Œæ™‚é–“=é“ã®ã‚Šï¼é€Ÿã•ã€ã€€ã‚·ãƒ³ãƒ—ãƒ«ãªè€ƒãˆæ–¹ãŒãƒ‡ãƒ¼ã‚¿å‡¦ç†ã‚’å¤‰ãˆã‚‹
ä¸–ç•Œä¸ã®æŠ€è¡“è€…ã‚’å¯¾è±¡ã«ã€æœ€æ–°æŠ€è¡“ã®å‹•å‘ã‚’ã‚·ã‚§ã‚¢ã™ã‚‹ã€ŽOracle Code Tokyoã€ãŒ2017å¹´5æœˆ18æ—¥ã«è¡Œã‚ã‚Œã¾ã—ãŸã€‚æ™®æ®µDBAã‚’æŒ‡å—ã—ã¦ã„ã‚‹ãƒ‡ã‚£ãƒ¬ã‚¯ã‚¿ãƒ¼ãƒ»æŸ´ç”° é•·æ°ãŒã€ŒLive Challenge!! SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®é«˜é€ŸåŒ–ã®é™ç•Œã‚’ç›®æŒ‡ã›ï¼ã€ã¨ã„ã†ãƒ†ãƒ¼ãƒžã§ã€ãƒ‡ãƒ¢ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿæ–½ã€‚Oracle Database 12cã®æœ€æ–°ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚’é§†ä½¿ã—ã¦ã€SQLã®é«˜é€ŸåŒ–ã‚’å®Ÿæ¼”ã—ãªãŒã‚‰èª¬æ˜Žã—ã¾ã—ãŸã€‚ ãƒ‘ãƒ©ãƒ¬ãƒ«åŒ–ã§è¤‡æ•°CPUã‚³ã‚¢ã‚’é§†ä½¿ æŸ´ç”°é•·æ°ï¼šç¶šã„ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ ã€Œãƒ‘ãƒ©ãƒ¬ãƒ«åŒ–ã§è¤‡æ•°CPUã‚³ã‚¢ã‚’ä½¿ã„ã“ãªã›ï¼ã€ã€ãƒŸãƒƒã‚·ãƒ§ãƒ³3ã§ã™ã€‚å…ˆã»ã©ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³åŒ–ã—ãŸCPUãƒã‚¦ãƒ³ãƒ‰ã®SQLã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ“ãƒ†ã‚£ã‚’è¦‹ãã¾ã—ãŸã€‚8ã¤ã®CPUã‚³ã‚¢ãŒã‚ã‚Šã¾ã™ãŒã€ã©ã†ã—ã¦ã‚‚1CPUã‚³ã‚¢ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚ã“ã‚Œã€ã‚‚ã£ãŸã„ãªã„ã§ã™ã‚ˆãã€‚ ãªãœèµ·ãã‚‹ã‹ã¨è¨€ã†ã¨ã€SQLã®å®Ÿè¡Œã§ã¯CPUã‚³ã‚¢ãŒ1ã¤ã—ã‹ä½¿ãˆã¾
yamadar 2018/02/03
*SQL

*DB

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒ8ã¤ã®è¦–ç‚¹ã§å¾¹åº•æ¯”è¼ƒï¼ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
PostgreSQLã¨MySQLã€ä½¿ã†ãªã‚‰ã©ã£ã¡ï¼ŸÂ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å°‚é–€å®¶ãŒ8ã¤ã®è¦–ç‚¹ã§å¾¹åº•æ¯”è¼ƒï¼ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã‚ˆãæ¯”è¼ƒã•ã‚Œã‚‹PostgreSQLã¨MySQLã€‚ã©ã‚“ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ï¼ŸÂ ãã‚Œãžã‚Œã®å°‚é–€å®¶ã«ã‚ˆã‚‹å¯¾è«‡ã§æ˜Žã‚‰ã‹ã«ã—ã¾ã™ã€‚ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦åƒã„ã¦ã„ã‚‹ã¨å¿…ãšç›´é¢ã™ã‚‹æ‚©ã¿ã€‚ãã‚Œã¯ã€ã€Œã©ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆä»¥ä¸‹ã€RDBï¼‰ã‚’é¸ã¶ã®ãŒæœ€å–„ãªã®ã‹ï¼Ÿã€ã§ã™ã€‚ RDBã”ã¨ã«é•·æ‰€ã¨çŸæ‰€ã¯ç•°ãªã£ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚è‡ªç¤¾ã‚µãƒ¼ãƒ“ã‚¹ã«ãƒžãƒƒãƒã—ãªã„RDBã‚’é¸ã‚“ã§ã—ã¾ã†ã¨ã€ãã‚ŒãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚Šé–‹ç™ºãƒ»é‹ç”¨ã«ãƒˆãƒ©ãƒ–ãƒ«ãŒç”Ÿã˜ã‚‹ã‚±ãƒ¼ã‚¹ã¯å°‘ãªãã‚ã‚Šã¾ã›ã‚“ã€‚ ãªã‹ã§ã‚‚ã‚ˆãæ¯”è¼ƒæ¤œè¨Žã•ã‚Œã‚‹ã®ãŒã€PostgreSQLã¨MySQLã€‚ã¨ã‚‚ã«ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹RDBã®ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã§ã‚ã‚Šã€é«˜ã„æ€§èƒ½ã¨æ•°å¤šãã®æ©Ÿèƒ½ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ã§ã¯ã€ä¸¡è€…ã¯å…·ä½“çš„ã«ã©ã®ã‚ˆã†ãªé•·æ‰€ãƒ»çŸæ‰€ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ã
yamadar 2017/12/26
*MySQL

*PostgreSQL

*SQL

*DB

çŸ¥è˜ãƒ»ç†è§£
ãƒªãƒ³ã‚¯
Announcing SQL Server on Linux - The Official Microsoft Blog
All Microsoft Global Microsoft 365 Teams Copilot Windows Surface Xbox Deals Small Business Support Software Windows Apps AI Outlook OneDrive Microsoft Teams OneNote Microsoft Edge Skype PCs & Devices Computers Shop Xbox Accessories VR & mixed reality Certified Refurbished Trade-in for cash Entertainment Xbox Game Pass Ultimate PC Game Pass Xbox games PC and Windows games Movies & TV Business Micro
yamadar 2016/03/08
@Microsoft

*SQL

*DB
ãƒªãƒ³ã‚¯
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã€Linuxç‰ˆã®SQL Serverã‚’2017å¹´ä¸ç›¤ã«ãƒªãƒªãƒ¼ã‚¹ã™ã‚‹ã¨å…¬å¼ç™ºè¡¨ã€‚ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ç‰ˆã®ç”³ã—è¾¼ã¿é–‹å§‹
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã¯ã€åŒç¤¾ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ™‚æœŸãƒ¡ã‚¸ãƒ£ãƒ¼ã‚¢ãƒƒãƒ—ç‰ˆã¨ãªã‚‹SQL Server 2016ãŒLinuxã«å¯¾å¿œã™ã‚‹ã“ã¨ã‚’å…¬å¼ã«ç™ºè¡¨ã—ã¾ã—ãŸã€‚ åŒç¤¾ã®ã‚¨ã‚°ã‚¼ã‚¯ãƒ†ã‚£ãƒ–ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆScott Guthrieæ°ã¯ã€Official Microsoft Blogã®ã‚¨ãƒ³ãƒˆãƒªã€ŒAnnouncing SQL Server on Linux - The Official Microsoft Blogã€ã§æ¬¡ã®ã‚ˆã†ã«æ›¸ã„ã¦ã„ã¾ã™ã€‚ Today Iâ€™m excited to announce our plans to bring SQL Server to Linux as well. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as we
yamadar 2016/03/08
@Microsoft

*SQL

*DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨SQLã®æ¥å‹™ã‚¹ã‚ãƒ«ãƒ¬ãƒ™ãƒ«ã€€åˆ¤åˆ¥è¡¨ã€€ï¼ˆï¼•æ®µéšŽï¼‰ - ä¸»ã«è¨€èªžã¨ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«é–¢ã—ã¦
ã‚¹ã‚ãƒ«ãƒã‚§ãƒƒã‚¯ã®ç›®æ¬¡ã¸ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã—ãŸã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã®ï¼Œç°¡æ˜“ã‚¹ã‚ãƒ«ãƒã‚§ãƒƒã‚¯ã®ãŸã‚ã®èª¿æŸ»è¡¨ã€‚å°åˆ·ç”¨ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒ¬ãƒ™ãƒ«ã‚’æ¸¬å®šã™ã‚‹ã€‚ ãƒ¬ãƒ™ãƒ«ã¯ï¼Œï¼ã‹ã‚‰ï¼”ã¾ã§ã®ï¼•æ®µéšŽã€‚ ï¼ˆï¼ï¼‰ éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ ï¼ˆï¼‘ï¼‰ åˆå¦è€…ï¼ˆå…¥é–€æ›¸ã‚’å¦ç¿’ã—ã¦ã‚†ãæ®µéšŽï¼‰ ï¼ˆï¼’ï¼‰ ãƒŽãƒ¼ãƒžãƒ«ï¼ˆåŸºç¤Žçš„ãªçŸ¥è˜ãŒã‚ã‚Šï¼Œã‚ã‚‹ç¨‹åº¦ã®å‹•ãã‚‚ã®ã‚’ä½œã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸæ®µéšŽï¼‰ ï¼ˆï¼“ï¼‰ ä¸ç´šè€…ï¼ˆé–‹ç™ºãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ï¼‘äººæœˆã¨ã—ã¦ã‚«ã‚¦ãƒ³ãƒˆã§ãã‚‹æ°´æº–ï¼‰ ï¼ˆï¼”ï¼‰ ä¸Šç´šè€…ï¼ˆãƒ¡ã‚¤ãƒ³PG/ãƒ¡ãƒ³ã‚¿ãƒ¼ã¨ã—ã¦ï¼Œä¸»è¨è¨ˆã‚’ä»»ã›ã‚‰ã‚Œã‚‹æ°´æº–ï¼‰ Webã‚¢ãƒ—ãƒªã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆé–‹å§‹æ™‚ã«ä½œæ¥æŒ¯ã‚Šåˆ†ã‘ã‚’ã™ã‚‹ã«ã‚ãŸã£ã¦ï¼Œæ–°è¦ãƒ¡ãƒ³ãƒå…¨å“¡ã«ã“ã‚Œã‚’æ¸¡ã—ã¦å›žç”ã—ã¦ã‚‚ã‚‰ã†ã¨ã„ã†ç”¨é€”ã‚’æƒ³å®šã€‚ ãªãŠï¼Œé–‹ç™ºä¸Šã®ã‚¹ã‚ãƒ«ã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚‹äº‹ãŒä¸»çœ¼ãªã®ã§ï¼ŒDBAã¨ã—ã¦ã®æŠ€é‡ã¯ã‚ã¾ã‚Šè€ƒæ…®ã—ãªã„ã€‚ ä¸‹è¨˜ã§ã€Œè‡ªåˆ†ã«å½“ã¦ã¯ã¾ã‚‹é …ç›®ãŒæœ€ã‚‚å¤šã„ãƒ¬ãƒ™ãƒ«ãŒï¼Œè‡ªåˆ†ã®å±žã™ã‚‹ãƒ¬ãƒ™ãƒ«ã§ã‚ã‚‹ã€ã¨ã™ã‚‹ã€‚ â€»ãŸã ã—ï¼Œ
yamadar 2014/03/19
*SQL

*MySQL

*DB
ãƒªãƒ³ã‚¯
Jepsen: PostgreSQL, Redis, MongDB ãŠã‚ˆã³ Riak ã®åˆ†å‰²è€æ€§ã‚’ãƒ†ã‚¹ãƒˆã™ã‚‹
Spring Bootã«ã‚ˆã‚‹APIãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰æ§‹ç¯‰å®Ÿè·µã‚¬ã‚¤ãƒ‰ ç¬¬2ç‰ˆ ä½•åƒäººã‚‚ã®é–‹ç™ºè€…ãŒã€InfoQã®ãƒŸãƒ‹ãƒ–ãƒƒã‚¯ã€ŒPractical Guide to Building an API Back End with Spring Bootã€ã‹ã‚‰ã€Spring Bootã‚’ä½¿ã£ãŸREST APIæ§‹ç¯‰ã®åŸºç¤Žã‚’å¦ã‚“ã ã€‚ã“ã®æœ¬ã§ã¯ã€å‡ºç‰ˆæ™‚ã«æ–°ã—ããƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹ Spring Boot 2 ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã€‚ã—ã‹ã—ã€Spring Boot3ãŒæœ€è¿‘ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã€é‡è¦ãªå¤‰...
yamadar 2013/07/26
NoSQLã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿æå¤±ã«ã¤ã„ã¦ã€‚ã‹ãªã‚Šå‹‰å¼·ã«ãªã‚‹ã€‚ã€Œã‚³ãƒ¼ãƒ‰ã‚„APIã‚’é–‹ç™ºã™ã‚‹éš›ã«ã¯ã€æˆåŠŸã€å¤±æ•—ã€ãã—ã¦ä¸å®šçŠ¶æ…‹ã®é•ã„ã‚’æ˜Žç¢ºã«ã™ã‚‹ã“ã¨ã€

*DB

*NoSQL

*redis

*MongoDB

*SQL
ãƒªãƒ³ã‚¯
SQLä¸Šç´šè€…ã“ãçŸ¥ã£ã¦æ¬²ã—ã„ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ï¼Ÿ
(PgDay2012ç™ºè¡¨è³‡æ–™) SQLã«ã¨ã£ã¦ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ã‚’èª¬æ˜Žã—ãŸè³‡æ–™ã§ã™ã€‚Read less
yamadar 2012/12/07
ORMã¯SQLã®é«˜ç´šè¨€èªžã€‚

*SQL
ãƒªãƒ³ã‚¯
FQL - ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ - Facebook for Developers
FQL
yamadar 2012/05/20
@Facebook

*SQL
ãƒªãƒ³ã‚¯
ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã‚’å›žé¿ã™ã‚‹ãŸã‚ã®æ–¹ç–
DBã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã™ã‚‹éš›ã€ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã‚’å›žé¿ã™ã‚‹ãŸã‚ã«è€ƒæ…®ã™ã¹ãç‚¹ã®ã¾ã¨ã‚ã€‚ ã“ã“ã«æ›¸ãã“ã¨ã¯ã€ä»Šã¾ã§ã®çµŒé¨“ (Oracle) ã‚’æ€ã„å‡ºã—ã€ã€Œã“ã†ã™ã‚Œã°ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°æ™‚ç‚¹ã§ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã‚’å›žé¿å‡ºæ¥ã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã€ã¨ã€æ»ã‚Šå‡ºã—ãŸã®ã§ã€å¤šå°‘é–“é•ã„ãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ å¾Œæ—¥ã€PostgreSQLã«ã¦æ¤œè¨¼ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ 1. åŒä¸€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã®è¤‡æ•°ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¢ã‚¯ã‚»ã‚¹ ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã®èª¬æ˜Žã§ã‚‚ã£ã¨ã‚‚ã‚ã‹ã‚Šã‚„ã™ã„åŸºæœ¬çš„ãªä¾‹ã¨ã—ã¦å¼•ç”¨ã•ã‚Œã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ã€‚ ä¾‹ãˆã°A, Bã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚‹ã¨ãã€äºŒã¤ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã§ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³1 : A -> B ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³2 : B -> A ã®é †ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ›´æ–°ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã—ã¦ã„ã‚‹ã¨ã€åŒæ™‚ã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸæ™‚ã«ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã¨ãªã‚‹ã€‚ ï¼ˆå®Ÿéš›ã¯åŒä¸€ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å¯¾ã—ã¦ã‚¢ã‚¯ã‚»ã‚¹ã—ãŸå ´åˆï¼‰ å¯¾ç–ï¼š ãƒ» ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¦ç´„ã¨ã—ã¦ã€åŒä¸€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã®ãƒ†ãƒ¼
yamadar 2010/10/27
ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯

*SQL
ãƒªãƒ³ã‚¯
æ˜Žç¤ºçš„ãƒãƒƒã‚¯
12.3. æ˜Žç¤ºçš„ãƒãƒƒã‚¯PostgreSQLã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«å†…ã®ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã™ã‚‹åŒæ™‚ã‚¢ã‚¯ã‚»ã‚¹ã‚’åˆ¶å¾¡ã™ã‚‹ãŸã‚ã«æ§˜ã€…ãªç¨®é¡žã®ãƒãƒƒã‚¯ãƒ¢ãƒ¼ãƒ‰ã‚’å‚™ãˆã¦ã„ã¾ã™ã€‚ ã“ã‚Œã‚‰ã®ãƒ¢ãƒ¼ãƒ‰ã¯ã€MVCCã§ã¯å¿…è¦ãªå‹•ä½œã‚’å¾—ã‚‰ã‚Œãªã„å ´åˆã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³åˆ¶å¾¡ã®ãƒãƒƒã‚¯ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã¾ãŸã€ã»ã¨ã‚“ã©ã®PostgreSQLã‚³ãƒžãƒ³ãƒ‰ã§ã¯ã€å‚ç…§ã•ã‚Œã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãŒãã®ã‚³ãƒžãƒ³ãƒ‰ã®å®Ÿè¡Œä¸ã«åˆ¥ã®æ–¹æ³•ã§å‰Šé™¤ã‚‚ã—ãã¯å¤‰æ›´ã•ã‚Œã¦ã„ãªã„ã“ã¨ã‚’ç¢ºå®Ÿã«ã™ã‚‹ãŸã‚ã«ã€é©åˆ‡ãªãƒ¢ãƒ¼ãƒ‰ã®ãƒãƒƒã‚¯ã‚’è‡ªå‹•çš„ã«ç²å¾—ã—ã¾ã™ã€‚ (ä¾‹ãˆã°ã€ALTER TABLEã‚³ãƒžãƒ³ãƒ‰ã¯ã€åŒã˜ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹ä»–ã®æ“ä½œã¨ã¯åŒæ™‚ã«å®Ÿè¡Œã§ãã¾ã›ã‚“ã€‚) ç¾åœ¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã§é‡è¦ãªãƒãƒƒã‚¯ã®ä¸€è¦§ã‚’ç¢ºèªã™ã‚‹ã«ã¯ã€pg_locksã‚·ã‚¹ãƒ†ãƒ ãƒ“ãƒ¥ãƒ¼(é …41.33)ã‚’ä½¿ç”¨ã—ã¦ãã ã•ã„ã€‚ ãƒãƒƒã‚¯ç®¡ç†ã‚µãƒ–ã‚·ã‚¹ãƒ†ãƒ ã®çŠ¶æ³ç›£è¦–ã«ã¤ã„ã¦ã®è©³ç´°ã¯ç¬¬23ç« ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ 12.3.1. ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯
yamadar 2010/10/27
æ˜Žç¤ºçš„ãªãƒãƒƒã‚¯ã®ä½¿ç”¨ã¯ã€ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã®åŽŸå› ã¨ãªã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚

*SQL
ãƒªãƒ³ã‚¯
è„†å¼±æ€§è¾žå…¸/SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ - ã‚»ã‚ãƒ¥ã‚¢ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã—ã‚ˆã†ã€‚
åˆ¥ç§°ï¼šSQL Injectionã€ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆSQLã‚³ãƒžãƒ³ãƒ‰ãƒ»ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ï¼ˆDirect SQL Command Injectionï¼‰ æ¦‚è¦ â€ æ”»æ’ƒè€…ã«ã‚ˆã£ã¦æ‚ªæ„ã®ã‚ã‚‹SQLã‚¯ã‚¨ãƒªãƒ¼ã‚’å®Ÿè¡Œã€ä¸æ£ã«ãƒ‡ãƒ¼ã‚¿æ“ä½œã•ã‚Œã‚‹è„†å¼±æ€§ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¸æ£ã«æ›¸ãæ›ãˆã‚‰ã‚ŒãŸã‚Šã€èªã¿å‡ºã•ã‚ŒãŸã‚Šã—ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ç ´å£Šã‚„æƒ…å ±æ¼ãˆã„ã®å±é™ºãŒã‚ã‚Šã¾ã™ã€‚ åŽŸå› â€ ãƒ•ã‚©ãƒ¼ãƒ ã‚„URLã®ã‚¯ã‚¨ãƒªæ–‡å—åˆ—ãªã©ã€å¤–éƒ¨ã‹ã‚‰å…¥åŠ›ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã£ã¦SQLæ–‡ã‚’çµ„ã¿ç«‹ã¦ã‚‹å‡¦ç†ã«å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚æ¬¡ã®ä¾‹ã¯Perlã«ã‚ˆã‚‹ã‚‚ã®ã§ã™ãŒã€å…¥åŠ›ãƒ‡ãƒ¼ã‚¿ã‚’SQLæ–‡ã«åŸ‹ã‚è¾¼ã‚€å‡¦ç†ã®åŸºæœ¬çš„ãªå½¢ã¨ã—ã¦ã¯ã€ã©ã®å‡¦ç†ç³»ã§ã‚‚åŒã˜ã‚ˆã†ãªã‚‚ã®ã«ãªã‚‹ã§ã—ã‚‡ã†ã€‚ $value = CGI::param("profile"); $sql = "UPDATE USERS SET PROFILE = '$value' WHERE ID = 1"; ã“ã®å‡¦ç†ã§
yamadar 2010/07/16
ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ãŒä½¿ãˆã‚‹å ´åˆã¯ã€æ–‡å—åˆ—çµåˆã«ã‚ˆã£ã¦SQLã«ãƒ‡ãƒ¼ã‚¿ã‚’åŸ‹ã‚è¾¼ã‚€äº‹ã‚’ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®ãƒãƒªã‚·ãƒ¼ã¨ã—ã¦ç¦æ¢ã—ã¦ãã ã•ã„ã€‚

*SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
Memcacheã¯ã‚„ã£ã±ã‚Šã™ã”ã‹ã£ãŸ
æ£®å·ã§ã™ã€‚æ¥ãšã‹ã—ãªãŒã‚‰memcacheã‚’ä½¿ã†ãã‚‰ã„ãªã‚‰tmpfsã¨ã‹MySQLã®HEAPãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ãˆã°ã„ã„ã˜ã‚ƒã‚“ã€ãªã©ã¨æ€ã£ã¦ã„ãŸã®ã§ã™ãŒã€ä»Šå›žç°¡å˜ãªãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ã‚„ã£ã¦ã¿ã¦å¿ƒã‚’å…¥ã‚Œæ›¿ãˆã¾ã—ãŸã€‚ ã¯ã„ã€memcacheã¯å‰å¤§ã§ã™ã€‚ã™ã”ãé€Ÿã„ã§ã™ã€‚ ãƒ†ã‚¹ãƒˆã¨ã—ã¦10ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã—ã¦ã€ãã“ã‹ã‚‰è©²å½“ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’10ä¸‡ä»¶å–å¾—ã—ã¾ã™ã€‚ã¾ãšã¯memcacheã‚’ä½¿ç”¨ã—ãŸå ´åˆã§ã™ã€‚ ä»Šå›žã¯dagãƒ¬ãƒã‚¸ãƒˆãƒªã®RPMç‰ˆmemcachedã¨ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸPHP 5.2.3ã‚’ä½¿ç”¨ã—ã¦pecl installã§memcacheã‚¨ã‚¯ã‚¹ãƒ†ãƒ³ã‚·ãƒ§ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã¾ã™ã€‚memcachedã®è¨å®šã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã¾ã¾ã§ã™ã€‚ #Â yumÂ installÂ memcached #Â peclÂ installÂ memcache #Â viÂ /usr/local/lib/php.ini extension=
yamadar 2010/06/15
*SQL

*DB

*memcached
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸