[B! db] yoshi-naã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yoshi-na id:yoshi-na

dbã«é–¢ã™ã‚‹yoshi-naã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{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}}

ä¾¿åˆ©ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆé›† MySQL Utilities - rkajiyamaâ€™s diary
å®Ÿã¯1.0.0ãŒ2010å¹´12æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ãŸã®ã«å…¨ãçŸ¥ååº¦ã®ç„¡ã„"MySQL Utilities"ã€‚å®Ÿã¯ä¾¿åˆ©ãªæ©Ÿèƒ½ãŒè¤‡æ•°ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ‰‹ä½œã‚Šã—ãªãã¦ã‚‚æ¸ˆã‚€å¯èƒ½æ€§å¤§ã§ã™ã€‚ã¾ãŸãƒªãƒªãƒ¼ã‚¹ã«å‘ã‘ã¦æ–°ãŸãªãƒžã‚¤ãƒ«ã‚¹ãƒˆãƒ¼ãƒ³ãƒªãƒªãƒ¼ã‚¹ãŒå‡ºã¦ããŸMySQL 5.6ã§ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¿½åŠ æ©Ÿèƒ½ã¨çµ„ã¿åˆã‚ã›ã‚‹ä¾¿åˆ©æ©Ÿèƒ½ã‚‚ã‚ã‚Šã¾ã™ã€‚ MySQL Utilitiesã¯Pythonã§æ›¸ã‹ã‚ŒãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆé›†ã§ã€MySQL Workbenchã«åŒæ¢±ã•ã‚Œã¦é…å¸ƒã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯ã€Œã‚‚ã¡ã‚ã‚“ã€GPLã§ã™ã€‚2012å¹´7æœˆä¸Šæ—¬æ™‚ç‚¹ã§ã®æœ€æ–°ç‰ˆã¯1.0.5ã§ã™ã€‚ã¾ãŸå®Ÿè¡Œå¯èƒ½ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã®ä»–ã«ã€ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦ç´°ã‹ãªæ©Ÿèƒ½ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ãŸã‚ã€ç‹¬è‡ªã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆä½œæˆã«ã‚‚å½¹ç«‹ã¡ã¾ã™ã€‚ èµ·å‹•ã«ã¯MySQL Workbenchã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã®ã€Pluginsã€‘ã‹ã‚‰ã€Start Shell for MySQL Utilit
yoshi-na 2012/07/28
*ã‚ã¨ã§èªã‚€

MySQL

db
ãƒªãƒ³ã‚¯
SQL vs NoSQLã€ã‚°ãƒ¼ã‚°ãƒ«ã«ãŠã‘ã‚‹æˆ¦ã„ï¼ˆå‰ç·¨ï¼‰ã€‚Google I/O 2012
SQLã¨NoSQLã§ã¯ã©ã¡ã‚‰ãŒå„ªã‚Œã¦ã„ã‚‹ã®ã‹ï¼Ÿ ã‚°ãƒ¼ã‚°ãƒ«ã®æ‹…å½“è€…ãŒãƒ‡ã‚£ãƒ™ãƒ¼ãƒˆï¼ˆã¨ã„ã†ã‚ˆã‚Šå°èŠå±…ï¼š-ï¼‰ã‚’è¡Œã£ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯ã€å…ˆã€…é€±é–‹å‚¬ã•ã‚ŒãŸGoogle I/O 2012ã§è¡Œã‚ã‚ŒãŸã‚‚ã®ã€‚SQLã¨NoSQLã«ã¯æ©Ÿèƒ½çš„ã«ã©ã®ã‚ˆã†ãªé•ã„ãŒã‚ã‚Šã€ã©ã†ä½¿ã„åˆ†ã‘ã‚‹ã¹ããªã®ã‹ã€æ˜Žç¢ºãªèª¬æ˜ŽãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ¡ãƒªãƒƒãƒˆ ã‚°ãƒ¼ã‚°ãƒ«ã®Alfred Fulleræ°ï¼ˆNoSQLæ‹…å½“ï¼‰ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã¯ãƒ•ã‚©ãƒ«ãƒˆãƒˆãƒ¬ãƒ©ãƒ³ãƒˆã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ä¸è¦ã€ãƒ‘ãƒƒãƒã‚‚ç§ãŸã¡ãŒé©ç”¨ã—ã¦ãŠã‚Šã€åˆ©ç”¨è€…ã¯é‹ç”¨ã«ã¤ã„ã¦å¿ƒé…ã™ã‚‹å¿…è¦ãŒãªã„ã€ã¨ã„ã£ãŸãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„åœ°åŸŸåˆ†æ•£ã§ãƒ‡ãƒ¼ã‚¿ã‚‚ä¿å…¨ã•ã‚Œã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒ
yoshi-na 2012/07/09
Google

SQL

NoSQL

db

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã‚’çŸ¥ã‚‹
SQLã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¯å¥¥ãŒæ·±ã„ã€‚ç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è¦³ç‚¹ã‹ã‚‰ã€ãã†è¨€ãˆã‚‹ã ã‚ã†ã€‚ ã¿ãªã•ã‚“ã”æ‰¿çŸ¥ã®é€šã‚Šã€åŒã˜çµæžœã‚’å‡ºã™ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚‚ã€SQLã®æ›¸ãæ–¹æ¬¡ç¬¬ã§å‡¦ç†æ™‚é–“ã«ä½•å€ã‚‚ã®å·®ãŒç”Ÿã˜å¾—ã‚‹ã€‚åŠ¹çŽ‡ã®æ‚ªã„SQLã‚’æ›¸ã„ã¦ã—ã¾ã†åŽŸå› ã¯ã€å¤šãã®å ´åˆã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã‚„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹ç†è§£ä¸è¶³ã§ã‚ã‚‹ã€‚ä¸¡è€…ã‚’ã‚ˆãçŸ¥ã£ãŸä¸Šã§æœ€é©ãªSQLã‚’æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã‚‹ã“ã¨ã¯ã€ã‚·ã‚¹ãƒ†ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ã®é‡è¦ãªã‚¹ã‚ãƒ«ã®ä¸€ã¤ã§ã‚ã‚‹ã€‚ ç‰¹é›†ã€ŽåŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ã€ã§ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã«ã¤ã„ã¦ã€åŸºæœ¬çš„ãªéƒ¨åˆ†ã‚’åˆ†ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¦ã„ã‚‹ã€‚SQLãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«å½¹ç«‹ã¤ã“ã¨ã¯ã‚‚ã¡ã‚ã‚“ã€SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®ãŸã‚ã®åŸºç¤ŽçŸ¥è˜ã¨ã—ã¦ã‚‚ä¸å¯æ¬ ã ã€‚ ã‚¤ãƒ³ãƒˆãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®ã¾ã¾ã§ã„ã„ã®ï¼Ÿ Part 1ï¼šSQLæ–‡ã¯ã©ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã®ã‹ SQLå®Ÿè¡Œã¾ã§ã®
yoshi-na 2011/07/02
DB

SQL

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ
2. è‡ªå·±ç´¹ä»‹ ï® MySQL/Linuxå‘¨ã‚Šã®ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆ ï¬ 2006å¹´9æœˆã‹ã‚‰2010å¹´8æœˆã¾ã§MySQL æœ¬å®¶(MySQL/Sun/Oracle)ã§ APAC/USåœã®MySQL ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã«å¾“äº‹ ï¬ ä¸»ãªè‘—æ›¸ã«ã€Œç¾å ´ã§ä½¿ãˆã‚‹MySQLã€ã€ŒLinux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/ é‹ç”¨å…¥é–€ã€ã€ŒJavaãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹å®Ÿè·µè¬›åº§ã€ ï® DeNAã§ã®ä¸»ãªå½¹å‰² ï¬ å®‰å®šåŒ–/ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹/é‹ç”¨å‘¨ã‚Šã®ä¸é•·æœŸçš„ãªæ”¹å–„æ´»å‹• ï¬ L3ã‚µãƒãƒ¼ãƒˆ/é‹ç”¨/ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚° â€“ é›£åº¦ã®é«˜ã„MySQLå‘¨ã‚Šã®å•é¡Œã®æ ¹æœ¬åŽŸå› ã®ç‰¹å®šã¨è§£æ±º ï¬ å¤šãã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆæ”¯æ´ ï¬ ç¤¾å†…å‹‰å¼·ä¼š/ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚° â€“ MySQLã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‘¨ã‚Šã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’ç¤¾å†…ã§å…±æœ‰ã—ã€ æŠ€è¡“ã‚¹ã‚ãƒ«ã‚’åº•ä¸Šã’ã™ã‚‹ ï¬ æŠ€è¡“ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚° â€“ å›½å†…å¤–ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚„ã€æŠ€è¡“é›‘èªŒç‰
yoshi-na 2011/01/17
ã‚¹ãƒ©ã‚¤ãƒ‰

MySQL

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

#atode
ãƒªãƒ³ã‚¯
1