[B! DB] youranusã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

youranus id:youranus

DBã«é–¢ã™ã‚‹youranusã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

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

IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
youranus 2010/05/21
MySQL

PHP

DB
ãƒªãƒ³ã‚¯
key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜
é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ Software Design èªŒ 2010å¹´ 2æœˆå·ã«æŽ²è¼‰ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ Software Design èªŒç·¨é›†éƒ¨ã®äº†æ‰¿ã®å…ƒã«ã€æœ¬ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«æŽ²è¼‰ã—ã¦ãŠã‚Šã¾ã™ã€‚ é¦–è—¤ä¸€å¹¸: "key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜", Software Design 2010å¹´ 2æœˆå·, p.14-21, (æ ª)æŠ€è¡“è©•è«–ç¤¾, 2010å¹´ 1æœˆ 18æ—¥ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ç‰¹ã«PaaSå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºãŒç¾å®Ÿã®ã‚‚ã®ã¨ãªã‚Šã€ ãã“ã§ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ å‹¢ã„ã‚’å¢—ã—ã¦ã„ã¾ã™ã€‚ ãã®ä»£è¡¨ã§ã‚ã‚‹key-valueã‚¹ãƒˆã‚¢ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚‚ãã˜ key-valueã‚¹ãƒˆã‚¢ã¨ã¯ ãªãœkey-valueã‚¹ãƒˆã‚¢ã‹ key-valueã‚¹ãƒˆã‚¢ã®ä½¿ã„ã©ã“ã‚ key-valueã‚¹ãƒˆã‚¢ã¨NoSQLã®
youranus 2010/01/20
é–‹ç™º

DB

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã€ã‚³ãƒ©ãƒ ã€‘ã‚¤ãƒžãƒ‰ã‚ã®IDEäº‹æƒ… (73) é«˜æ©Ÿèƒ½ERãƒ¢ãƒ‡ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã€ŒER Masterã€ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ! | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
ER Masterã¨ã¯? ER Masterã¯ERå›³ã‚’ä½œæˆã™ã‚‹ãŸã‚ã®Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã ã€‚ERå›³ã‚’ä½œæˆã™ã‚‹ãŸã‚ã®Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã«ã¯Clay Mark IIã‚„AmaterasERDãªã©ãŒã‚ã‚‹ãŒã€ä¸ã§ã‚‚ER Masterã¯é«˜æ©Ÿèƒ½ã§ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚‚å……å®Ÿã—ã¦ãŠã‚Šã€ã‚¤ãƒã‚ªã‚·ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã ã€‚ ER Masterã¯æ›´æ–°ã‚µã‚¤ãƒˆã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ER Masterã‚’ä½¿ã£ã¦ã¿ã‚ˆã† ER Masterã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€æ–°è¦ä½œæˆã‚¦ã‚£ã‚¶ãƒ¼ãƒ‰ã®[ERMaster]ã‚«ãƒ†ã‚´ãƒªã‹ã‚‰ERå›³ã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ERå›³ã®ä½œæˆæ™‚ã«ã¯å¯¾å¿œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä»¥ä¸‹ã®ä¸ã‹ã‚‰é¸æŠžã™ã‚‹ã€‚ä¸»è¦ãªDBã«ã¤ã„ã¦ã¯ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ãŒã€ä¸€éƒ¨ã®DBã®ã‚µãƒãƒ¼ãƒˆã«ã¤ã„ã¦ã¯é–‹ç™ºé€”ä¸Šã¨ãªã£ã¦ã„ã‚‹ã®ã§æ³¨æ„ã—ã¦ã»ã—ã„(ç†è€…ã®è©¦ã—ãŸã¨ã“ã‚ã§ã¯ã€ä¸€éƒ¨ã®DBã‚’æŒ‡å®šã—ãŸå ´åˆã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã¨ã„ã£
youranus 2010/01/12
DB

è¨è¨ˆ
ãƒªãƒ³ã‚¯
MyISAMã¨InnoDBã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹
Twitterã§è©±é¡Œã«ãªã£ã¦ãŸã®ã§ç°¡å˜ã«ã¾ã¨ã‚ã¾ã—ãŸã€‚ â—MyISAMã«ã—ã‹ç„¡ã„æ©Ÿèƒ½ã‚’ä½¿ã„ãŸã„å ´åˆã¯MyISAMã‚’ä½¿ã†ã—ã‹ãªã„ ãƒ»å…¨æ–‡æ¤œç´¢ (Tritonnã‚„Sphinx) ãƒ»GIS â—InnoDBã®åˆ©ç‚¹(MyISAMã®æ¬ ç‚¹) â–²éšœå®³å¯¾å¿œç³» ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ã¦ã‚‚å†èµ·å‹•ã™ã‚‹ã ã‘ã§ãƒªã‚«ãƒãƒªãŒã§ãã‚‹ ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒªã«ã‹ã‹ã‚‹æ™‚é–“ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã«æ¯”ä¾‹ã™ã‚‹ã‚ˆã†ãªã“ã¨ã¯ãªãã€ã‚³ãƒŸãƒƒãƒˆæ¸ˆã¿ã®ãƒ‡ãƒ¼ã‚¿ã¯ä¿®å¾©ã§ãã‚‹ (å·¨å¤§ãªMyISAMãƒ†ãƒ¼ãƒ–ãƒ«ã®REPAIRã«ã¯æ•°æ—¥å˜ä½ã§æ™‚é–“ãŒã‹ã‹ã‚‹ã“ã¨ãŒã‚ã‚‹) ãƒ»ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒã§ãã‚‹ ãƒ»INSERTã‚„LOAD DATAãªã©ã‚’å®Ÿè¡Œã—ã¦ã„ã‚‹é€”ä¸ã§Ctrl+Cã§ãã®æ›´æ–°ç³»SQLæ–‡ã‚’æ¢ã‚ã¦ã‚‚ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¯å£Šã‚Œãªã„ã—ã€ä¸é€”åŠç«¯ãªçŠ¶æ…‹ã§æ›´æ–°ã•ã‚Œã‚‹ã“ã¨ã‚‚ç„¡ã„ã—ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒæ¢ã¾ã‚‹ã“ã¨ã‚‚ç„¡ã„ â–²æ€§èƒ½ç³» ãƒ»è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ä¸¦åˆ—æ€§ãŒé«˜ã„(MyISAMã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯)ã€‚ã¾ãŸSEL
youranus 2009/10/29
DB

MySQL
ãƒªãƒ³ã‚¯
SQLã‚’ä½¿ã†ãªã‚‰ç†è§£ã—ã¦ãŠããŸã„ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ï¼Ÿ(ã¨ã„ã†ã‹ã€selectæ–‡ã®æ›¸ãæ–¹) - whereãƒ»order byãƒ»joinãƒ»group by - ä½•ã‹ã—ã‚‰ã®è¨€èªžã«ã‚ˆã‚‹è¨˜è¿°ã‚’è§£æžã™ã‚‹æ—¥è¨˜
SQLã®selectæ–‡ã®æ›¸ãæ–¹ã®è¦šæ›¸ã§ã™ã€‚ ãªãŠã€æœ¬æ–‡ä¸ã®å‹•ä½œç¢ºèªã¯ã€Œmysql Ver 5.0.67ã€ã§è¡Œã„ã¾ã—ãŸã€‚ 2009/10/05 13:30 è¿½è¨˜ äºˆæƒ³å¤–ã«å¤šãã®ã‚¢ã‚¯ã‚»ã‚¹ã¨ãƒ–ã‚¯ãƒžã‚’ã„ãŸã ãã€æ£ç›´é©šã„ã¦ãŠã‚Šã¾ã™ã€‚ æœ¬æ–‡ã¯sqlã®å†…éƒ¨å‡¦ç†ã«ã¯ä¸€åˆ‡è§¦ã‚Œã¦ãŠã‚Šã¾ã›ã‚“ã€‚ã”ãæ™®é€šã®sqlã®æ›¸ãæ–¹ã«ã®ã¿è§¦ã‚Œã¦ã„ã¾ã™ã€‚ é‡£ã‚Šã®ã¤ã‚‚ã‚Šã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€é‡£ã‚‰ã‚ŒãŸã¨æ„Ÿã˜ãŸæ–¹ã«ã¯ã”ã‚ã‚“ãªã•ã„ã€‚ ç›®æ¬¡ èª¬æ˜Žã«ä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ï¼Ÿ(ã¨ã„ã†ã‹ãƒ†ãƒ¼ãƒ–ãƒ«) æŠ½å‡º(whereå¥) ã‚½ãƒ¼ãƒˆ(order byå¥) ã‚½ãƒ¼ãƒˆã®ä¾‹(æ˜‡é †) ã‚½ãƒ¼ãƒˆã®ä¾‹(é™é †) çµåˆ(joinå¥) é›†è¨ˆ(group byå¥) é–¢é€£è¨˜äº‹ èª¬æ˜Žã«ä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ (ã¨ã„ã†ã‹ãƒ†ãƒ¼ãƒ–ãƒ«) selectæ–‡ã®ä½¿ã„æ–¹ã‚’èª¬æ˜Žã™ã‚‹ãŸã‚ã«ã€ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã„ã¾ã™ã€‚ create table countries ( name nvarchar(30), cu
youranus 2009/10/05
DB

MySQL
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹ã€åƒ•ãŒçŸ¥ã‚Šã†ã‚‹é™ã‚Šæœ€é«˜ã®æ•™ç§‘æ›¸ - ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ã‚¿ãƒ¼å±±æœ¬å¤§ã®ãƒ–ãƒã‚°
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é†é†å‘³ã¯ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã‚ã‚Šã¾ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã‚ˆã£ã¦ã¯ã€åŒã˜å‡¦ç†ã§ã‚‚1æ™‚é–“æŽ›ã‹ã‚‹å ´åˆã‚‚ã‚ã‚Œã°ã€ 1ç§’ã§çµ‚ã‚ã‚‹ã¨ã„ã†ã“ã¨ã‚‚ã‚ã‚Šå¾—ã‚‹ä¸–ç•Œã§ã™ã€‚ åƒ•ã¯DBã®é…åŠ›ã«å–ã‚Šä»˜ã‹ã‚ŒãŸè€…ã®ä¸€äººã§ã™ã€‚ DBã¨ã„ã†æŠ€è¡“ã®å¥¥æ·±ã•ãŒæ°—ã«å…¥ã£ã¦ã„ã¾ã™ã€‚ DBã‚’æ¥µã‚ã‚‹ã¨ã€ã©ã“ã®ç¾å ´ã«è¡Œã£ã¦ã‚‚çµ¶å¯¾ã«å¿…è¦ã¨ã•ã‚Œã¾ã™ã€‚ ã¾ãŸã€ã©ã“ã®ç¾å ´ã«è¡Œã£ã¦ã‚‚æ£è§£ã‚’å°Žãæ–¹ç¨‹å¼ã¯ä¸€ç·’ãªã®ã§å¿œç”¨ãŒåˆ©ãã®ã§ã™ã€‚ ã—ã‹ã—ã€ãã®åŸºæœ¬åŽŸç†ã‚’ä½“ç³»çš„ã«å¦ã¹ã‚‹æ‰‹æ®µã¯ã‚ã¾ã‚Šã‚ã‚Šã¾ã›ã‚“ã€‚ OracleMasterã‚„MCDBAã¨ã„ã£ãŸè³‡æ ¼è©¦é¨“ã§ã‚‚å¦ã¹ã‚‹ã“ã¨ã¯é™ã‚‰ã‚Œã¦ã„ã¦ ã‚ã¨ã¯Webã§èª¿ã¹ã‚‹ãªã‚Šãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’èªã‚€ãªã‚Šã™ã‚‹ã—ã‹ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ ã¨ãã«è‚ã§ã‚ã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã¯ã€ çµŒé¨“å‰‡ã§ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ã‚‹éƒ¨åˆ†ã‚‚å¤šã„ã§ã™ã€‚ Oracleã€SQLServerã€MySQLã¨è‰²ã€…ãªDBã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ãã¾ã—ãŸãŒã€
youranus 2009/08/09
DB

æ›¸è©•
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: RDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿ
yukiã§ã™ã€‚ãƒ€ã‚¤ã‚¨ãƒƒãƒˆã‚’å§‹ã‚ã¦3kgæ¸›ã£ãŸã¨æ€ã£ãŸã‚‰ã€é¢¨é‚ªã‚’å¼•ã„ã¦è¦‹äº‹ã«1kgå¢—é‡ã€‚ é‹å‹•ã—ãªã„ã¨é§„ç›®ã§ã™ãã€‚ã‚ã¨æ®‹ã‚Š20kgã€é“ã®ã‚Šã¯é ã„ã§ã™ã€‚ ã•ã¦ä»Šå›žã¯ã€ã€ŒRDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿã€ã§ã™ã€‚ ã‚ã‚‹ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ä¸ã«éšŽå±¤æ§‹é€ ã‚’ã‚‚ã£ãŸã‚«ãƒ†ã‚´ãƒªæ§‹é€ ã«ã™ã‚‹ã“ã¨ã«ãªã‚Šã€ã©ã®ã‚ˆã†ã«DBã§æ‰±ã†ã‹æ‚©ã¿ã¾ã—ãŸã€‚ DBã¯MySQLã‚’æŽ¡ç”¨ã—ã¦ã„ãŸã®ã§ã€ã“ã®æ™‚ç‚¹ã§ã±ã£ã¨é ã«æµ®ã‹ã‚“ã é¸æŠžè‚¢ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã§ã—ãŸã€‚ XML-DBã‚’åˆ©ç”¨ã™ã‚‹ è¦ªã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªIDã‚’åã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã«æŒãŸã›ã‚‹ è¦ªã‚’å«ã‚ãŸã€Žçµ¶å¯¾ãƒ‘ã‚¹ã€ã‚’åç§°ã¨ã—ã¦æ‰±ã„ã€å–ã‚Šå‡ºã—ãŸå¾Œã«ãƒ‘ãƒ¼ã‚¹ ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã«åŒæ§˜ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã‚’ä½œã‚Šã€æ¯Žå›žãƒ‘ãƒ¼ã‚¹ã™ã‚‹ (1)ã®XMLDBã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®eXistã‚„Xindiceã€Yggdrasillãªã©æ§˜ã€…ãªé¸æŠžè‚¢ãŒã‚ã‚Šã¾ã—ãŸãŒã€ã‚«ãƒ†ã‚´ãƒªã®ã¿ã®åˆ©ç”¨ãªå‰²ã«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚³ã‚¹ãƒˆãŒé«˜ã™ãŽã‚‹ã®ã§è¦‹é€ã‚Šã¾
youranus 2009/06/26
ãªã‚‹ã»ã©ãƒ¼

DB

MySQL

ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ
ãƒªãƒ³ã‚¯
United States
12 Android tips you shouldn't miss from 2024Make the most of the upcoming holiday break with these standout tips for your favorite Android phone or tablet.
youranus 2009/06/17
Google

DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨ã„ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã«ã¤ã„ã¦ - LukeSilviaâ€™s diary
Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„ã‚»ãƒƒã‚·ãƒ§ãƒ³æ©Ÿæ§‹ã€‚DB ãƒ™ãƒ¼ã‚¹ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã‚’è¡Œãªã£ã¦å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã¨ã€ãã‚Œã‚’å…ƒã«è€ƒå¯Ÿã—ãŸçµæžœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã®ç‰¹æ€§ DB ã§ç®¡ç†ã•ã‚Œã‚‹ä»–ã®ãƒ‡ãƒ¼ã‚¿ã«æ¯”ã¹ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã¯ã‹ãªã‚Šç‰¹æ®Šã§ã™ã€‚ä¸»ãªç‰¹å¾´ã¯æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã€‚ ãƒ‡ãƒ¼ã‚¿ãŒå¢—åŠ ã™ã‚‹ã®ãŒé€Ÿã„ å®šæœŸçš„ãªå‰Šé™¤ãŒå¿…è¦ é »ç¹ã«æ›´æ–°ã•ã‚Œã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«èªã¿ã«è¡Œãå¿…è¦ãŒã‚ã‚‹ ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã‚ãªã„ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…¨ä½“ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒé«˜ã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ã¨ã€1ã¤ç›®ã®ç‰¹å¾´ã‹ã‚‰ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã¯æ„è˜çš„ã«ç®¡ç†ã—ã¦ã‚„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ç¾åœ¨ã®ç’°å¢ƒ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é ˜åŸŸãŒå°‘ã—ç‰¹æ®Šã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ãŒã‚„ãŸã‚‰ãŸã¾ã‚Šã¾ã™(ãƒ¦ãƒ¼ã‚¶æ•°ä½•ç™¾ä¸‡ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ãã†ã„ã†ã®ã§ã¯ãªã„ã§ã™)ã€‚ RDBMS MySQL 4.0.22 ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ InnoDB ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 6åƒä¸‡ ãƒ†ãƒ¼ã‚¿ã‚µ
youranus 2009/05/27
DB

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

MySQL
ãƒªãƒ³ã‚¯
Bæœ¨ - naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼
æ˜¨å¹´ã‹ã‚‰ç¶šã„ã¦ã„ã‚‹ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚¤ãƒ³ãƒˆãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³è¼ªè¬›ã‚‚ã€æ—©ã„ã‚‚ã®ã§æ¬¡ã¯18ç« ã§ã™ã€‚18ç« ã®ãƒ†ãƒ¼ãƒžã¯Bæœ¨(B Tree, Bãƒ„ãƒªãƒ¼) ã§ã™ã€‚Bæœ¨ã¯ãƒžãƒ«ãƒã‚¦ã‚§ã‚¤å¹³è¡¡æœ¨(å¤šåˆ†æœ¨ã«ã‚ˆã‚‹å¹³è¡¡æœ¨)ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ãªã©ã§ã‚‚è‰¯ãä½¿ã‚ã‚Œã‚‹é‡è¦ãªãƒ‡ãƒ¼ã‚¿æ§‹é€ ã§ã™ã€‚Bæœ¨ã¯ä¸€ã¤ã®æœ¨ã®é ‚ç‚¹ã«ã¶ã‚‰ä¸‹ãŒã‚‹æžã®æœ¬æ•°ã®ä¸‹é™ã¨ä¸Šé™ã‚’è¨ã‘ãŸä¸Šã€å¸¸ã«å¹³è¡¡æœ¨ã§ã‚ã‚‹ã“ã¨ã‚’åˆ¶ç´„ã¨ã—ãŸãƒ‡ãƒ¼ã‚¿æ§‹é€ ã«ãªã‚Šã¾ã™ã€‚ è¼ªè¬›ã®äºˆç¿’ãŒã¦ã‚‰ã€Bæœ¨ã‚’ Python ã§å®Ÿè£…ã—ã¦ã¿ã¾ã—ãŸã€‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’æœ€å¾Œã«æŽ²è¼‰ã—ã¾ã™ã€‚ä»¥ä¸‹ã¯ Bæœ¨ã«é–¢ã™ã‚‹è€ƒå¯Ÿã§ã™ã€‚ Bæœ¨ãŒãªãœé‡è¦ãªã®ã‹ Bæœ¨ãŒé‡è¦ãªã®ã¯ã€Bæœ¨(ã®å¤‰ç¨®ã§ã‚ã‚‹B+æœ¨*1ãªã©)ãŒäºŒæ¬¡è¨˜æ†¶è£…ç½®ä¸Šã§åŠ¹çŽ‡è‰¯ãæ“ä½œã§ãã‚‹ã‚ˆã†ã«è¨è¨ˆã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿æ§‹é€ ã ã‹ã‚‰ã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã©ã€äºŒæ¬¡è¨˜æ†¶(ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯)ä¸Šã®å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’é‹ç”¨ã—ãŸçµŒé¨“ãŒã‚ã‚‹æ–¹ãªã‚‰ã€ã„ã‹ã«ãƒ‡ã‚£
youranus 2009/04/13
ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ

DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŸºç¤Žã‚’ç†è§£ã—ã‚ˆã†ï¼ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æœªçµŒé¨“ã‹ã‚‰å§‹ã‚ã‚‹PHPå…¥é–€
ã¯ã˜ã‚ã« æœ¬é€£è¼‰ã§ã¯ã€PHPã¾ãŸã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°åˆå¿ƒè€…ã®æ–¹ã‚’å¯¾è±¡ã«ã€PHPã‚’ç”¨ã„ãŸWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œæˆæ–¹æ³•ã‚’èª¬æ˜Žã—ã¦ã„ãã¾ã™ã€‚ä»Šå›žã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨SQLã«é–¢ã—ã¦ã€ã€ŒãŠã™ã™ã‚ãƒ¬ã‚¹ãƒˆãƒ©ãƒ³ä¸€è¦§ã‚’é–²è¦§ã§ãã‚‹Webã‚µã‚¤ãƒˆã‚’åˆ¶ä½œã™ã‚‹å ´åˆã€ã‚’ä¾‹ã«ã—ã¦ã€èª¬æ˜Žã‚’ã—ã¦ã„ãã¾ã™ã€‚ å¯¾è±¡èªè€… ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãŒåˆã‚ã¦ã§ã“ã‚Œã‹ã‚‰å¦ç¿’ã™ã‚‹äºˆå®šã®æ–¹ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çµŒé¨“ã¯ã‚ã‚‹ãŒPHPã‚’åˆã‚ã¦å¦ç¿’ã™ã‚‹æ–¹ ã“ã®è¨˜äº‹ã®å†…å®¹ ã¯ã˜ã‚ã« å¯¾è±¡èªè€… å‹•ä½œç¢ºèªç’°å¢ƒ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ä½•ã‹ï½¥ï½¥ï½¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã©ã‚“ãªå½¹å‰²ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã®åŸºç¤Žï½¥ï½¥ï½¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨€èªžã€ŒSQLã€ã¨ã¯ SQLåŸºç¤Žï¼šãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆï½¥ï½¥ï½¥CREATEæ–‡ã‚’ä½¿ã£ã¦ã¿ã¾ã—ã‚‡ã† SQLåŸºç¤Žï¼šãƒ¬ã‚³ãƒ¼ãƒ‰è¿½åŠ ï½¥ï½¥ï½¥INSERTæ–‡ã‚’ä½¿ã£ã¦ã¿ã¾ã—ã‚‡ã† SQLåŸºç¤Žï¼šãƒ¬ã‚³ãƒ¼ãƒ‰æ¤œç´¢ï½¥ï½¥ï½¥SELECTæ–‡ã‚’ä½¿ã£ã¦ã¿ã¾ã—ã‚‡ã† SQLåŸºç¤Žï¼šãƒ¬ã‚³ãƒ¼ãƒ‰æ›´æ–°ï½¥ï½¥ï½¥UPDATEæ–‡ã‚’ä½¿ã£ã¦ã¿ã¾ã—
youranus 2009/03/31
DB

MySQL

PHP
ãƒªãƒ³ã‚¯
MySQLç®¡ç†ãƒ„ãƒ¼ãƒ«ã¨é–‹ç™ºãƒ„ãƒ¼ãƒ«ã®ã¾ã¨ã‚ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
Smashing Magazine - WE SMASH YOU WITH THE INFORMATION THAT WILL MAKE YOUR LIFE EASIER, REALLY. Smashing Magazineã«ãŠã„ã¦MySQL Admin and Development Tools Round Upã®ã‚¿ã‚¤ãƒˆãƒ«ã®ã‚‚ã¨MySQLã®ç®¡ç†ãŠã‚ˆã³é–‹ç™ºã«æ´»ç”¨ã§ãã‚‹ãƒ„ãƒ¼ãƒ«ãŒã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã€‚MySQLã‚’ä½¿ã£ãŸé–‹ç™ºã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚’è¡Œã£ã¦ã„ã‚‹å ´åˆã«ã¯ä¸€åº¦ãƒã‚§ãƒƒã‚¯ã—ã¦ãŠããŸã„å†…å®¹ã ã€‚ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’æŠœç²‹ã™ã‚‹ã¨æ¬¡ã®ã¨ãŠã‚Šã€‚ phpMyAdmin - MySQLç®¡ç†Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ SQL Buddy - MySQLç®¡ç†Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ Aqua Data Studio - MySQLç®¡ç†ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³(é–‹ç™ºå‘ã‘æ©Ÿèƒ½å«ã‚€) (Win, OS X, Linux, Solari
youranus 2009/03/27
DB

MySQL
ãƒªãƒ³ã‚¯
HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹
HowFriendFeedUses MySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ç›®æ¬¡ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ èƒŒæ™¯ æ¦‚è¦³ è©³ç´° ä¸€è²«æ€§ã¨åŽŸåæ€§ æ€§èƒ½ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ "How FriendFeed? uses MySQL to store schema-less data" ã®æ—¥æœ¬èªžè¨³ã§ã™ http://bret.appspot.com/entry/how-friendfeed-uses-mysql CC 2.5 ã§ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ã„ã¾ã™: http://creativecommons.org/
youranus 2009/03/03
DB

è³‡æ–™
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã¯DBä¸Šã®ä»»æ„ãƒ‡ãƒ¼ã‚¿ã‚’ç›—ã¿å‡ºã™ - ockeghem's blog
å‰å›žã«å¼•ãç¶šãã€Think ITä¸Šã®é€£è¼‰ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¤§å…¨ã€ã®ç¬¬4å›žï¼šã‚±ãƒ¼ã‚¹åˆ¥ã€æ”»æ’ƒã®æ‰‹å£ã‚’èªã‚“ã§æ„Ÿã˜ãŸã“ã¨ã‚’æ›¸ããŸã„ã€‚ ã¾ãšã€ã“ã®è¨˜äº‹ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªæ›¸ãå‡ºã—ã‹ã‚‰å§‹ã¾ã£ã¦ã„ã‚‹ã€‚ æœ¬è¨˜äº‹ã¯ã€ã‚·ã‚¹ãƒ†ãƒ ã‚’é˜²å¾¡ã™ã‚‹ã«ã¯ã¾ãšæ•µã‚’çŸ¥ã‚‰ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€ã¨ã„ã†æ„å›³ã®ä¸‹ã«ã€æ”»æ’ƒæ‰‹æ³•ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ dfltweb1.onamae.com â€“ ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ãŠåå‰.comã§å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®è¶£æ—¨ã«ç•°è«–ãŒã‚ã‚‹ã‚ã‘ã§ã¯ãªã„ãŒã€ã—ã‹ã—ã“ã®è¡¨ç¾ã¯èª¤è§£ã‚’ç”Ÿã¿ã‚„ã™ã„ã‚‚ã®ã ã¨æ€ã†ã€‚ ã¨ã„ã†ã®ã¯ã€ã€Œæ•µã€(æ”»æ’ƒæ–¹æ³•)ã‚’çŸ¥ã£ãŸã‹ã‚‰ã¨è¨€ã£ã¦ã€é˜²å¾¡ã®æ–¹æ³•ãŒå°Žãå‡ºã›ã‚‹è¨³ã§ã¯ãªã„ã‹ã‚‰ã ã€‚ä¾‹ãˆã°ã€é–‹ç™ºè€…ãŒã€Œæœ€è¿‘ã®SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è‡ªå‹•åŒ–æ”»æ’ƒã«ã¯T-SQLã®DECLAREæ–‡ãŒç”¨ã„ã‚‰ã‚Œã‚‹ã€ã¨ã„ã†æƒ…å ±ã‚’å¾—ã¦ç‹¬è‡ªã«å¯¾ç–ã‚’è€ƒãˆãŸå ´åˆã€DECLAREã¨ã„ã†å˜èªžã‚’ãƒã‚§ãƒƒã‚¯ã—ã¦ã‚¨ãƒ©ãƒ¼ã«ã—ãŸã‚Šã€å˜èªžã‚’å‰Šé™¤ã™ã‚‹ã“ã¨ã‚’è€ƒãˆãŒã¡ã ã¨æ€ã†ã€‚ç¾ã«
youranus 2009/03/03
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

DB
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
youranus 2009/01/25
DB

é–‹ç™º

MySQL

Webã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
DBMã«ã‚ˆã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - mixi engineer blog
æ£æœˆæ—©ã€…ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ã«ã‹ã‹ã£ã¦å¯è¾¼ã‚“ã mikioã§ã™ã€‚é›»è»Šã«ä¹—ã‚‹æ™‚ã‚„ç¹è¯è¡—ãªã©ã«å‡ºã‚‹æ™‚ã¯ãƒžã‚¹ã‚¯ç€ç”¨ãŒå¿…é ˆã§ã™ãã€‚ã•ã¦ä»Šå›žã¯ã€Tokyo Cabinetã§å®Ÿè£…ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«æ–¹å¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚æ„å¤–ã«ã©ã†ã—ã¦å¼·åŠ›ãªæ©Ÿèƒ½ãªã®ã§ã€ã“ã®ãƒã‚¿ã¯é€£è¼‰ã™ã‚‹ã“ã¨ã‚’äºˆå‘Šã—ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ ç°¡å˜ã«è¨€ãˆã°ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ˆã†ã«ã€è¤‡æ•°ã®åˆ—ã‹ã‚‰ãªã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ ¼ç´ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚SQLã‚„è¡¨çµåˆãªã©ã®è¤‡é›‘ãªæ©Ÿèƒ½ã¯ã‚µãƒãƒ¼ãƒˆã—ã¾ã›ã‚“ãŒã€ãã®ã¶ã‚“é«˜é€Ÿã«å‹•ä½œã—ã¾ã™ã€‚ã¤ã¾ã‚Šã€DBMã®é€Ÿåº¦ã§å‹•ããƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«é¢¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ï¼ˆåŽ³å¯†ã«ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã‚ã‚Šã¾ã›ã‚“ï¼‰ã€‚ TCã®åŸºæœ¬ã¨ãªã‚‹ãƒãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€å˜ç´”ãªkey/valueåž‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚Šã€ã¤ã¾ã‚Šã‚ãƒ¼ã«ã‚‚å€¤ã«ã‚‚ã‚¹ã‚«ãƒ©ï¼ˆæ•°å€¤ã‚„æ–‡å—åˆ—ãªã©ã®ç‰¹ã«æ§‹é€ ã‚’æŒãŸãªã„å˜ä¸€ã®å€¤ï¼‰ã—ã‹æ ¼ç´ã™ã‚‹ã“ã¨ã¯ã§ãã¾ã›ã‚“
youranus 2009/01/19
DB

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

ãƒ¦ãƒ¼ã‚¶ãƒ“ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
ã€Œã¯ã¦ãªæµå¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã€ã‚’è¦‹ã¦ããŸ - ã‚‚ãŽã‚ƒã‚ã
KOF2008ï¼šé–¢è¥¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹2008ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã«æ¥ã¦ã„ã¾ã™ã€‚ ã¯ã¦ãªã®ä¼Šè—¤ã•ã‚“ã®è¬›æ¼”ãŒã‚ã£ãŸã®ã§ã€è¬›æ¼”ãƒ¡ãƒ¢ã‚’å…¬é–‹ã€‚ ï¼ƒãƒœã‚¯ãŒãƒ¡ãƒ¢ã—ãŸå†…å®¹ã§ã‚ã£ã¦ã€100%è¨€ã£ãŸã¨ãŠã‚Šã«æ›¸ã„ã¦ã‚ã‚‹ã‚ã‘ã˜ã‚ƒãªã„ã®ã§ã€å‚è€ƒã¨ã—ã¦ã”è¦§ãã ã•ã„ã€‚ (ç¶šã) ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ OSã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ MySQLã®é‹ç”¨ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™º ãƒ‡ãƒ¼ã‚¿ã®ä¾‹ ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ãƒ‡ãƒ¼ã‚¿é‡ï¼šäº”åƒä¸‡ä»¶ãã‚‰ã„ã®ãƒ‡ãƒ¼ã‚¿é‡ ã“ã®ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ä½•ç™¾ä¸‡äººãŒã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ãã‚‹çŠ¶æ³ã§ã©ã†ã„ã†ä½œã‚Šã«ã™ã‚‹ã‹ ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 1073ä¸‡ã‚¨ãƒ³ãƒˆãƒªãƒ¼ 3134ä¸‡ã‚¨ãƒ³ãƒˆãƒªãƒ¼ 4143ä¸‡ã‚¿ã‚° ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚º ã‚¨ãƒ³ãƒˆãƒªãƒ¼2.5GB ä½•ã®å·¥å¤«ã‚‚ãªãæ™®é€šã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã¨...200ç§’å¾…ã£ã¦ã‚‚çµæžœãŒå¸°ã£ã¦ã“ãªã„ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã®é›£ã—ã„ã¨ã“ã‚ é–‹ç™ºã‚µãƒ¼ãƒã§é–‹ç™ºè€…ãŒä½œã£ã¦ã„ã‚‹æ™‚ã¯å¿«é©ã«å‹•ã„ã¦ã„ã¦ã‚‚ã€å¤šæ•°ã®äººé–“ãŒã‚¢ã‚¯
youranus 2008/11/11
ã‚µãƒ¼ãƒ

ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†

MySQL

DB

ã¯ã¦ãª
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» Introducing the Drizzle Project
ã“ã“ã—ã°ã‚‰ãã€æ°´é¢ä¸‹ã§Brian Akerã‚’ä»£è¡¨ã¨ã™ã‚‹MySQL/SUNã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŸã¡ã‚„ã€æ¥ç•Œã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒãƒƒã‚«ãƒ¼ãŸã¡ã¨MySQLã‚’ã‚¹ãƒªãƒ ãƒ€ã‚¦ãƒ³ã•ã›ãŸãƒžã‚¤ã‚¯ãƒã‚«ãƒ¼ãƒãƒ«RDBMSã‚’é–‹ç™ºã—ã¦ã„ãŸã®ã§ã™ãŒã€æœ¬æ—¥ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ã•ã‚ŒãŸã®ã§ã€æ—¥æœ¬èªžã§ã”ç´¹ä»‹ã•ã›ã¦ã„ãŸã ããŸã„ã¨æ€ã„ã¾ã™ã€‚ Drizzleã¨ã¯ï¼Ÿ Drizzleã¨ã¯å¿…è¦ã®ãªã„ã‚‚ã®ã¯ä¸€åˆ‡å˜åœ¨ã—ãªã„ã€æœ€ä½Žé™ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹é‡è¦–ãªã€ŒMySQLã‚ˆã‚Šã‚·ãƒ³ãƒ—ãƒ«ã§ã€è»½ãã€å®‰å®šã—ã¦ã€é«˜é€Ÿãªã€ MySQLã®forkã§ã™ã€‚ãƒžã‚¤ã‚¯ãƒã‚«ãƒ¼ãƒãƒ«ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŽ¡ç”¨ã—ãŸã®ã§ã€å¿…è¦ã®ãªã„ã‚‚ã®ã¯å¾Œä»˜ã‘ã§ãã‚‹æ§‹æˆã§ã™ã€‚ã“ã†ã„ã£ãŸç›®æ¨™ã‚‚ã‚ã‚Šã€ç¾åœ¨ã€Drizzleã®é–‹ç™ºãƒãƒ¼ãƒ ã¯MySQLã‚’ãƒ‰ãƒ©ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã«ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã—ã¦ã„ã¾ã™ã€‚ ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ Drizzleã§å¤§äº‹ãªäº‹ã¯ã€Drizzleã¯ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã‚ã‚‹ã¨ã„ã†äº‹ã§ã™ã€‚Montyã®ãƒ–
youranus 2008/07/24
DB

MySQL

Drizzle
ãƒªãƒ³ã‚¯
Safari 3.1 ã«å®Ÿè£…ã•ã‚ŒãŸã€ŒClient-side database storage (SQL API)ã€ã¨ã¯ä½•ã‹ï¼Ÿ - ITæˆ¦è¨˜
ã¯ã˜ã‚ã« Safari 3.1 ã«ã¯ Client-side database storage ï¼ˆSQL API ã¨ã‚‚å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚ï¼‰ã¨ã„ã†æ–°ã—ã„ä»•æ§˜ãŒå®Ÿè£…ã•ã‚Œã¾ã—ãŸã€‚ ã¨ã„ã†ã‚ã‘ã§ã€ã“ã®æ–°ã—ã„ API ã«ã¤ã„ã¦è‰²ã€…èª¿ã¹ãŸã“ã¨ã‚’ç°¡å˜ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ Client-side database storage ãŒä½¿ãˆã‚‹ãƒ–ãƒ©ã‚¦ã‚¶ 2008 å¹´ 03 æœˆ 27 æ—¥ç¾åœ¨ã§ã¯ã€ Safari ç³»ã®ãƒ–ãƒ©ã‚¦ã‚¶ã®ã¿ã§ã™ã€‚ Safari 3.1 WebKit Nightly Client-side database storage ã¨ã¯ Selectors API ã¨ã¯ HTML5 ã§å®šç¾©ã•ã‚ŒãŸä»•æ§˜ã§ã™ã€‚è©³ç´°ã«é–¢ã—ã¦ã¯ã“ã¡ã‚‰ã‚’ã©ã†ãžã€‚ ç°¡å˜ã«èª¬æ˜Žã™ã‚‹ã¨ JavaScript å†…ã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ãˆã‚‹ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ã‚‚ã£ã¨ç°¡å˜ã«ã‚¤ãƒ¡ãƒ¼ã‚¸ã™ã‚‹ãŸã‚ã«ã€å®Ÿéš›ã®ã‚³ãƒ¼ãƒ‰ã‚’ç¤ºã™ã¨ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ va
youranus 2008/03/27
DB

ãƒ–ãƒ©ã‚¦ã‚¶

HTML

JavaScript
ãƒªãƒ³ã‚¯
i-revo ãŠå®¢æ§˜ã‚µãƒãƒ¼ãƒˆ é‡è¦ãªãŠçŸ¥ã‚‰ã›
i-revoÂ ãŠå®¢æ§˜ã‚µãƒãƒ¼ãƒˆÂ é‡è¦ãªãŠçŸ¥ã‚‰ã› i-revoãƒžã‚¤ãƒãƒ¼ã‚¿ãƒ«çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›ï¼ˆ2017å¹´3æœˆ31æ—¥ï¼‰ æ—¥é ƒã‚ˆã‚Ši-revoãƒžã‚¤ãƒãƒ¼ã‚¿ãƒ«ã‚’ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ã“ã®ãŸã³ã€å½“ã‚µã‚¤ãƒˆã¯2017å¹´3æœˆ31æ—¥ä»˜ã‘ã«ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä½µã›ã¦ã€Œãƒ—ãƒ‹ãƒžãƒ«ã€ã€ã€Œi-revo å ã„ã€ã«ã¤ã„ã¦ã‚‚ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ 2006å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ä»¥æ¥ã€ ãŠå®¢æ§˜ãŠã‚ˆã³é–¢ä¿‚å„ç¤¾ã®çš†æ§˜ã«ã¯ã•ã¾ã–ã¾ã«ã€ã”å”åŠ›ã‚’ã„ãŸã ãã¾ã—ãŸã€‚ ã“ã“ã«å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ i-revoãƒžã‚¤ãƒãƒ¼ã‚¿ãƒ«ã®ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ã¤ãã¾ã—ã¦ã€ãªã«ã¨ãžã”ç†è§£ã„ãŸã ããŸãå˜ã˜ã¾ã™ã€‚ ä»Šå¾Œã¨ã‚‚ã€Œi-revoã€ã‚’ã‚ˆã‚ã—ããŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚ å…¨ã¦è¦‹ã‚‹
youranus 2008/02/26
æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³

ã¾ã¨ã‚

å½¢æ…‹ç´ è§£æž

é–‹ç™º

DB
ãƒªãƒ³ã‚¯
1