[B! Database] koto2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

koto2 id:koto2

Databaseã«é–¢ã™ã‚‹koto2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (15)

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

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã¯ã„ã¤ã€ä½•ã‚’ãƒã‚¤ãƒ³ãƒˆã«è¡Œã†ã‹
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã¯ã„ã¤ã€ä½•ã‚’ãƒã‚¤ãƒ³ãƒˆã«è¡Œã†ã‹ï¼šã‚¼ãƒã‹ã‚‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°å…¥é–€ï¼ˆ4ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ å‰å›žã¾ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®æ´å²çš„èƒŒæ™¯ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®æœ‰åŠ¹æ€§ã¾ã§ã‚’è§£èª¬ã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ©ã‚¤ãƒ•ã‚µã‚¤ã‚¯ãƒ«ã¨ç…§ã‚‰ã—åˆã‚ã›ã€ãã‚Œãžã‚Œã®ãƒ•ã‚§ã‚¤ã‚ºã§å¿…è¦ã¨ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«ã¤ã„ã¦ã€ãŠè©±ã‚’ã—ã¾ã™ã€‚ ã©ã®æ®µéšŽã§ã©ã†è¨è¨ˆã™ã‚Œã°ã„ã„ã®ã‹ å‰å›žã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã¯è‡ªç¤¾ã®ãƒ“ã‚¸ãƒã‚¹æ´»å‹•ã‚’ç†è§£ã—ã¦ã„ã‚‹è‡ªç¤¾å†…ã®äººé–“ãŒã‚„ã‚‹ã¹ãã§ã‚ã‚Šã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ éƒ¨é–€ã®å˜åœ¨æ„ç¾©ã‚’é«˜ã‚ã‚‹ãŸã‚ã«å¿…è¦ãªæŠ€æ³•ã§ã‚ã‚‹ã¨ãŠä¼ãˆã—ã¾ã—ãŸã€‚ã—ã‹ã—ã€ã‚·ã‚¹ãƒ†ãƒ ã®å¤–éƒ¨å§”è¨—ãŒå¤šã„ã¨ã„ã†ã®ã‚‚ã¾ãŸäº‹å®Ÿã§ã™ã€‚ ç†è€…ã®è·å ´ã§ã¯ã€ãŠå®¢æ§˜ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã«é–¢ã™ã‚‹ã”ç›¸è«‡ã‚’ã„ãŸã ãéš›ã€æœ€åˆã«ã€Œè²´ç¤¾ã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã‚’æ‹è¦‹ã•ã›ã¦ãã ã•ã„ã€ã¨ã„ã†ãŠé¡˜ã„ã‚’ã—ã¾ã™ã€‚ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’å¤–éƒ¨å§”è¨—ã—ã¦ã„ã‚‹ã‚±ãƒ¼ã‚¹ã§ã¯å¤šãã®å ´åˆã€å½¢ã¨ã—ã¦æ®‹ã£ã¦ã„ã‚‹ã®ã¯ã€Œç‰©ç†ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã€ã§
koto2 2009/04/29
Database

Development
ãƒªãƒ³ã‚¯
Leo's Chronicle: ãœã²æŠ¼ã•ãˆã¦ãŠããŸã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ•™ç§‘æ›¸
å…ˆæ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã§å°‘ã—è©±ã—ãŸã®ã§ã™ãŒã€åƒ•ãŒåœ¨å¦ã—ã¦ã„ãŸã¨ãã®æ±å¤§ã«ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã¶ãŸã‚ã®ã‚³ãƒ¼ã‚¹ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸï¼ˆDBé–¢ä¿‚ã®æŽˆæ¥ã¯å¹´ã«ï¼‘ã¤ã‹ï¼’ã¤ã‚ã‚‹ç¨‹åº¦ã€‚ç¾åœ¨ã¯ã©ã†ãªã‚“ã ã‚ã†ï¼Ÿï¼‰ã€‚ãã‚“ãªã¨ãã«å½¹ã ã£ãŸã®ã¯ã€ã‚„ã¯ã‚Šæ•™ç§‘æ›¸ã€‚èªã¿ã‚„ã™ã„ã‚‚ã®ã‹ã‚‰é †ã«ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ï¼ˆã¨ã¯ã„ã£ã¦ã‚‚ã™ã¹ã¦è‹±èªžã®æœ¬ã§ã™ã€‚ã‚ã—ã‹ã‚‰ãšï¼‰ ä¸€ç•ªã®ãŠè–¦ã‚ã¯ã€Raghu Ramakrishnanå…ˆç”Ÿ (ç¾åœ¨ã¯ã€Yahoo! Research) ã®ã€ŒDatabase Management Systems (3rd Edition)ã€ã€‚åˆå¦è€…ã‹ã‚‰ç ”ç©¶è€…ã¾ã§å¹…åºƒãä½¿ãˆã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã®åŸºæœ¬æ¦‚å¿µã‹ã‚‰ã€å•ã„åˆã‚ã›æœ€é©åŒ–ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç†ãªã©ã€ã“ã‚Œã‚‰ã‚’å®Ÿè£…ãƒ»è©•ä¾¡ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã€ã€ŒDBã®ä¸–ç•Œã§ã®å¸¸è˜ã€ãŒã€ä¸å¯§ãªèªžã‚Šå£ã§ãµã‚“ã ã‚“ã«ç››ã‚Šè¾¼ã¾ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®1å†Šã‚’èªã‚“ã§ãŠã‘ã°ã€DBã®ä¸–ç•Œã§è°è«–ã™ã‚‹ãŸã‚ã®
koto2 2009/01/09
Database
ãƒªãƒ³ã‚¯
MySQL/æœ€é©åŒ–/ã‚µãƒ¼ãƒãƒ‘ãƒ©ãƒ¡ã‚¿ - Linux Tips
ã“ã“ã§ã¯ã€ã‚µãƒ¼ãƒãƒ‘ãƒ©ãƒ¡ã‚¿ã®æœ€é©åŒ–ã«ã‚ˆã‚‹MySQLã®ãƒãƒ¥ãƒ¼ãƒ³ã«ã¤ã„ã¦ç´¹ä»‹ã™ã‚‹ã€‚ _ ãƒ‘ãƒ©ãƒ¡ã‚¿ã®ãƒã‚§ãƒƒã‚¯ ç¾åœ¨ã®è¨å®šå€¤ã‚’ç¢ºèªã™ã‚‹ã«ã¯ã€ # mysqld --help ã¨ã™ã‚‹ã€‚ MySQL-5.xã§ã¯ã€ # mysqld --verbose --help ã¨ã—ãªã„ã¨ã€ç¢ºèªã§ããªã‹ã£ãŸã€‚ ã‚ã‚‹ã„ã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã€ mysql> SHOW VARIABLES; ã§ã‚‚OKã€‚ â†‘ key_buffer_size â€ MyISAM ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä¿å˜ã—ã¦ãŠããƒãƒƒãƒ•ã‚¡ã®å¤§ãã•ã€‚ã‚µãƒ¼ãƒå…¨ä½“ã§å…±æœ‰ã•ã‚Œã‚‹ã€‚ãƒ¡ãƒ¢ãƒªã«ä½™è£•ãŒã‚ã‚Œã°ã€MyISAMã®ã¿ã®MySQLå°‚ç”¨ã‚µãƒ¼ãƒãªã‚‰ã€RAMã®1/2ã€Apache ãªã©ã¨å…±ç”¨ãªã‚‰ã€RAM ã®1/4ç¨‹åº¦ã¨ã™ã‚‹ã€‚ãŸã ã—ã€ã‚µã‚¤ã‚ºã‚’å¤§ããã™ã‚‹ã¨ã€OSã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ã®ãŸã‚ã«ã€é€†ã«é…ããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã®ã§æ³¨æ„ã€‚ set-variable = key_buffer=256M M
koto2 2008/07/30
Database

MySQL

Tips
ãƒªãƒ³ã‚¯
kndb.jp
This domain may be for sale!
koto2 2008/07/29
Database

Tips

MySQL
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MyISAM vs InnoDB
ã‚ãã¾ã§æ†¶æ¸¬ã§ä»®èª¬ã§ã—ã‹ãªã„ã‚“ã§ã™ãŒã€‚ MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ã†ã¡ä»£è¡¨çš„ãªäºŒã¤ã€MyISAM ã¨ InnoDB ã¯ã‚ˆã MyISAM: Read ã¯é€Ÿã„ã‘ã©ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ã®ãŸã‚ä¸¦è¡Œæ€§ãŒä½Žã„ã€‚é‹ç”¨ãŒç°¡å˜ã€‚ InnoDB: MyISAM ã‚ˆã‚Š Read ã¯é…ã„ã‘ã©ä¸¦è¡Œæ€§ãŒé«˜ã„ ã€‚è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ã€‚ã‚ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚„å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã€‚é‹ç”¨ãŒ MyISAM ã‚ˆã‚Šã¡ã‚‡ã£ã¨ã‚ã‚“ã©ãã•ã„ã€‚ ã¨ã„ã†åŒºåˆ¥ãŒã•ã‚Œã¾ã™ã€‚ã“ã“ã‹ã‚‰è»¢ã˜ã¦ã€ MyISAM ã¯å‚ç…§ç³»ã‚¯ã‚¨ãƒªãŒå¤§éƒ¨åˆ†ã‚’å ã‚ã‚‹å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ä¾‹ãˆã° blog ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‹ã€‚ InnoDB ã¯æ›´æ–°ç³»ã‚¯ã‚¨ãƒªãŒå¤šã„å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ ã¨è¨€ã‚ãŸã‚Šã—ã¾ã™ã€‚å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQL ã§ã‚‚ç¬¬2ç« ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³(ãƒ†ãƒ¼ãƒ–ãƒ«åž‹) P.30 ã« ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹å¿…è¦ãŒãªãã€ä¸»ã« SELECT ã¾ãŸã¯ I
koto2 2008/03/25
Database

MySQL

InnoDB

MyISAM
ãƒªãƒ³ã‚¯
MyISAM/InnoDBã«é–¢ã—ã¦ - ã¿ã‹ãƒã‚°
æœ€è¿‘ã¯å¸¸ã«InnoDBã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã§ï¼ŒMyISAM vs InnoDB ã«ã¡ã‚‡ã£ã¨ã‚³ãƒ¡ãƒ³ãƒˆã—ã¦ã¿ã‚‹ï¼Ž ã¾ãšã€ŒWebã‚¢ãƒ—ãƒªãªã‚‰ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯ã„ã‚‰ãªã„ã‹ã€ã«ã¤ã„ã¦ï¼Ž Webã‚¢ãƒ—ãƒªã§ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®é‡è¦æ€§ãŒé«˜ããªã„ã¨ã„ã£ã¦ã‚‚ï¼Œç„¡ã„ã‚ˆã‚Šã¯ã‚ã£ãŸæ–¹ãŒè‰¯ã„ã¯ãšï¼Ž ã¡ã‚‡ã£ã¨ã—ãŸã‚·ã‚¹ãƒ†ãƒ ã§ã‚‚ï¼ŒãŸã¨ãˆã°ãƒ¦ãƒ¼ã‚¶ã®ãƒ†ãƒ¼ãƒ–ãƒ«ï¼Œãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ«ã®ãƒ†ãƒ¼ãƒ–ãƒ«ï¼Œæ—¥è¨˜ã®è¨˜äº‹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãªã©ã§ã‚ã‘ã‚‹ã‚ã‘ã§ï¼Œãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«é–“ã®æ•´åˆæ€§ãŒã¨ã‚Œã¦ã„ãªã„ã¨å•é¡ŒãŒç”Ÿã˜ã¦ã—ã¾ã†ã¨æ€ã†ï¼Ž ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢éšœå®³ãªã©ã§ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ãŸã¨ãã«ï¼Œãƒ¦ãƒ¼ã‚¶ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒã‚ã‚‹ã‘ã©ï¼Œãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ«ã«ã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒç„¡ã„ã‚±ãƒ¼ã‚¹ã¨ã‹ï¼Œãã†ã„ã†ã‚±ãƒ¼ã‚¹ãŒç™ºç”Ÿã™ã‚‹ã“ã¨ã‚’è€ƒãˆã‚‹ã¨ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯åˆ©ç”¨ã™ã¹ãã˜ã‚ƒãªã„ã®ã‹ãªã¨ï¼Ž ã¨ã„ã†ã‚ã‘ã§ï¼ŒJOINã‚’ä½¿ã†ã‚ˆã†ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚ã‚Œã°ï¼Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯ä½¿ã†ã‚ˆã†ã«ã™ã¹ãï¼Œã¨ã„ã†ã®ãŒæŒè«–ï¼Ž ãã‚Œä»¥å¤–ã§InnoD
koto2 2008/03/25
Database

MySQL

InnoDB

MyISAM
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬2å›žï¼šMyISAMã¨InnoDB (1/3)
ä»Šå›žã¯ã€MySQLã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ä¸ã§ã‚‚ç‰¹ã«æœ‰åãªã€ŒMyISAMã€ã¨ã€ŒInnoDBã€ã®2ã¤ã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚MyISAMã¯MySQLã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æŒ‡å®šã›ãšã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã¨MyISAMãŒé¸æŠžã•ã‚Œã¾ã™ã€‚ã‚‚ã†ä¸€æ–¹ã®InnoDBã‚¨ãƒ³ã‚¸ãƒ³ã¯ã€MySQLã«è±Šå¯Œãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦æœ‰åã§ã™ã€‚ ã¾ãšã¯ãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®æ§‹é€ ã«ã¤ã„ã¦è§£èª¬ã—ã€æœ€å¾Œã«InnoDBã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ å„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒ•ã‚¡ã‚¤ãƒ«æ§‹é€ ã‚’èª¬æ˜Žã™ã‚‹å‰ã«ã€å‰çŸ¥è˜ã¨ã—ã¦MySQLã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã¯ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã¨å‘¼ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ›´æ–°æƒ…å ±ã‚’æ ¼ç´ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã€2ã¤ã®ã‚µãƒ–ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãŒå˜åœ¨ã—ã¾ã™ï¼ˆå›³1ï¼‰ã€‚ ã€Œmysqlã€ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã¯æ¨©é™ãƒ†ãƒ¼ãƒ–ãƒ«ã¨å‘¼ã°ã‚Œã‚‹MySQ
koto2 2008/03/25
Database

MySQL

InnoDB

MyISAM
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬6å›žï¼šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è² è·åˆ†æ•£ã¨ã¾ã¨ã‚ (1/3)
Webã‚µãƒ¼ãƒãƒ¼ã‚‚é †èª¿ã«å¢—ãˆãŸã€ã¨ãªã‚‹ã¨æ¬¡ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒæ‚²é³´ã‚’ä¸Šã’ã‚‹é ƒã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¢—è¨ã¨è¡Œãã¾ã—ã‚‡ã†ã€‚ ã¯ã¦ãªã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚MySQLã¯çµ„ã¿è¾¼ã¿ã§ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã§ã€ã“ã‚Œã‚’ä½¿ã‚ãªã„æ‰‹ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¡Œã„ã€ãƒžã‚¹ã‚¿ãƒ¼DBã®ã‚³ãƒ”ãƒ¼ã§ã‚ã‚‹ã‚¹ãƒ¬ãƒ¼ãƒ–DBã‚µãƒ¼ãƒãƒ¼ã‚’ä½œã‚Š2å°æ§‹æˆã«ã—ã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¤‡æ•°å°ã«å¢—ã‚„ã—ã€ä¸”ã¤ãã®è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒä¿æŒã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’åŒæœŸã•ã›ã‚‹ãŸã‚ã®ä»•çµ„ã¿ã§ã™ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã†ã¡ã€å…ƒã€…ã‚ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒè¦ªã€ãã‚Œä»¥å¤–ãŒåã¨ã„ã†è¦ªåé–¢ä¿‚ã«ãªã‚Šã¾ã™ã€‚ è¦ªã¯ãƒžã‚¹ã‚¿ãƒ¼ã€åã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ã¨å‘¼ã°ã‚Œã€ãƒžã‚¹ã‚¿ãƒ¼ã¸ã®æ›´æ–°å‡¦ç†ã¨åŒã˜å‡¦ç†ã‚’ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ä¼æ’ã•ã›ã‚‹ã“ã¨ã§ãƒ‡ãƒ¼ã‚¿ã®åŒæœŸãŒè¡Œã‚ã‚Œã¾ã™ã€‚å®Ÿéš›ã«ã¯ãƒžã‚¹ã‚¿ãƒ¼ã‹ã‚‰ã‚¹ãƒ¬ãƒ¼ãƒ–ã¸å‡¦ç†ãŒä¼æ’ã™ã‚‹ã®ã§ã¯ãªãã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒãƒãƒ¼ãƒªãƒ³ã‚°ã‚’è¡Œã£ã¦ãƒžã‚¹ã‚¿ãƒ¼ã¨
koto2 2008/03/25
Database

Performance

MySQL
ãƒªãƒ³ã‚¯
ãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§ä½¿ãˆã‚‹JavaScriptã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒTraffy DBã€:phpspoté–‹ç™ºæ—¥èªŒ
PHPã§ATOMã€RSS1/2ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®ãƒ•ã‚£ãƒ¼ãƒ‰ãŒè¶…ç°¡å˜ã«åãå‡ºã›ã‚‹ã€ŒFeedWriter... æ¬¡ã®è¨˜äº‹ â‰«ï¼šå„ªé›…ãªWebåˆ¶ä½œã®ãŸã‚ã®JavaScriptã€Œyuga.jsã€ Taffy DB : A JavaScript database for your browser Taffy DB is a free and opensource JavaScript library that acts as thin data layer inside Web 2.0 and Ajax applications. ãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§ä½¿ãˆã‚‹JavaScriptã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒTraffy DBã€. Ajaxã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã©ã§ã€ãƒ–ãƒ©ã‚¦ã‚¶å†…ã§å¤šãã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†å ´åˆã«ä½¿ãˆã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã‚ˆã†ã§ã™ã€‚ ä¾‹ãˆã°ã€æ¬¡ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚‹ã‚ˆã†ã§ã™ products.find({price:{
koto2 2008/03/14
Libraries

Ajax&JS

Database
ãƒªãƒ³ã‚¯
MySQL FULLTEXT Ngram : LIKEæ¤œç´¢ã‚ˆã‚Šæ•°åå€é«˜é€Ÿãªã€ãŠæ‰‹è»½ æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ã«ã¤ã„ã¦ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
koto2 2008/03/02
Database

Search

Libraries
ãƒªãƒ³ã‚¯
æ—¥æœ¬IBM
watsonx.governanceã®æä¾›ã‚’é–‹å§‹ è²¬ä»»ã‚ã‚‹ã€é€æ˜Žã§èª¬æ˜Žå¯èƒ½ãªAIã®ãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼ã‚’å®Ÿç¾ã™ã‚‹ç”ŸæˆAIã®ãŸã‚ã®ã‚¬ãƒãƒŠãƒ³ã‚¹ãƒ»ãƒ„ãƒ¼ãƒ« è£½å“ã®è©³ç´° ç„¡æ–™è©•ä¾¡ç‰ˆã‚’è©¦ã™ ã“ã®ãŸã³ã®ä»¤å’Œ6å¹´èƒ½ç™»åŠå³¶åœ°éœ‡ã§è¢«ç½ã•ã‚ŒãŸçš†æ§˜ã«è¬¹ã‚“ã§ãŠè¦‹èˆžã„ç”³ã—ä¸Šã’ã¾ã™ã€‚ ä»¤å’Œ6å¹´1æœˆ1æ—¥ã«ç™ºç”Ÿã—ãŸèƒ½ç™»åŠå³¶åœ°éœ‡ã«ã‚ˆã‚Šè¢«ç½ã•ã‚ŒãŸãŠå®¢æ§˜å‘ã‘ã®ä¿å®ˆã‚µãƒ¼ãƒ“ã‚¹ç‰¹åˆ¥å¯¾å¿œ ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚„é‹ç”¨ã«ç”ŸæˆAIã‚’æ´»ç”¨ã™ã‚‹ã€ŒITå¤‰é©ã®ãŸã‚ã®AIã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã€ã«ã‚ˆã‚Šã€ç”Ÿç”£æ€§ã¨å“è³ªã®å‘ä¸Šã‚’å®Ÿç¾
koto2 2008/02/29
Database

PHP
ãƒªãƒ³ã‚¯
PHPã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹5ã¤ã®å•é¡Œã€ã¨ãã®è§£æ±ºæ³• - GIGAZINE
IBMã®ã‚µã‚¤ãƒˆã«ã€PHPã‹ã‚‰æ“ä½œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã—ã¦ã‚ˆãè¦‹ã‚‰ã‚Œã‚‹5ã¤ã®å•é¡Œç‚¹ã¨ãã®è§£æ±ºæ–¹æ³•ãŒæŽ²è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ã‚¶ã‚¤ãƒ³ã‚’ã™ã‚‹éš›ã€ä¸€èˆ¬çš„ã«ç™ºç”Ÿã™ã‚‹å•é¡Œç‚¹ã«ã¤ã„ã¦ã®è§£èª¬ã§ã™ã€‚ ã§ã€è‚å¿ƒã®5ã¤ã®å•é¡ŒãŒä½•ã‹ã¨ã„ã†ã¨ã€ä»¥ä¸‹ã®é€šã‚Šã€‚ Five common PHP database probl ems 1ã¤ã‚ã¯å¤ã„PHPã®ã‚³ãƒ¼ãƒ‰ã§ã¯ç›´æŽ¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã€‚ã‚³ãƒ¬ã«ä»£ã‚ã‚‹æ‰‹æ®µã¨ã—ã¦ã¯ã€PEARã®DBãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã†ã‹ã€ã‚ã‚‹ã„ã¯PHPãƒ‡ãƒ¼ã‚¿ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã€PDOã®ã‚¯ãƒ©ã‚¹ã‚’ä½¿ãˆã€ã¨ã‚ã‚Šã¾ã™ã€‚ 2ã¤ã‚ã¯ã€ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚’ä½¿ã‚ãªã„ã¨ã„ã†ã“ã¨ã€‚MySQLã¯åŸºæœ¬çš„ã«ãƒ¬ã‚³ãƒ¼ãƒ‰1ã¤ã«ã¤ã„ã¦ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªIDã‚’ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã—ã¦ã„ã‚‹ã‚ã‘ã§ã™ãŒã€ã“ã‚Œã‚’æ´»ç”¨ã—ã¦ã„ãªã„ã¨ã„ã†ãƒ‘ã‚¿ãƒ¼ãƒ³ã€‚ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚’æœ‰åŠ¹ã«ä½¿ã£ã¦ã„ãªã„å ´åˆã€éžåŠ¹çŽ‡çš„ã§ã‚ã‚‹ã ã‘ã§ãªãã€è² è·ã‚‚é«˜ããªã‚‹ãã†ã§ã™ã€‚è§£
koto2 2008/02/29
Database

PHP
ãƒªãƒ³ã‚¯
http://wordpress.xwd.jp/euc_to_utf/pma.php
koto2 2008/02/25
Database

phpMyAdmin
ãƒªãƒ³ã‚¯
WEBã‚¢ãƒ—ãƒªç”¨ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ä½œã‚‹ã‚‚ã®è‰²ã€…:phpspoté–‹ç™ºæ—¥èªŒ
Test (Sample) Data Generators Sample / test data is an effective way to test web projects & applications. WEBã‚¢ãƒ—ãƒªç”¨ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ä½œã‚‹ã‚‚ã®è‰²ã€…ã€‚ ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã®ç”Ÿæˆã¯çµæ§‹é¢å€’ã§ã™ãŒã€ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ãˆã°ç°¡å˜ã€ã¨ã„ã†ã“ã¨ã§ï¼‘ã¤ã¯ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ç”ŸæˆãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã¯æŠ¼ã•ãˆã¦ãŠããŸã„ã§ã™ãã€‚ ä»¥ä¸‹ã«åˆ—æŒ™ generatedata.com ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’HTMLã€Excelã€XMLã€CSVã€SQLã®å½¢å¼ã§å‡ºåŠ›å¯èƒ½ã€‚ å‡ºåŠ›ãƒ‡ãƒ¼ã‚¿ã‚‚ã€å€‹äººæƒ…å ±ãƒ‡ãƒ¼ã‚¿ã‚„ã€ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚’é¸æŠžã—ã¦å‡ºåŠ›ã§ãã¾ã™ã€‚ DatageneratorÂ - GUIã§å‹•ä½œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¸ã‚§ãƒãƒ¬ãƒ¼ã‚¿ãƒ¼ DBMonster ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ©ãƒ³ãƒ€ãƒ ç”Ÿæˆãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã‚‰ã‚Œã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆ CSV data generator Ruby
koto2 2008/02/14
Web Service

Database
ãƒªãƒ³ã‚¯
cl.pocari.org - ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ãªã£ãŸ Fastladder ã® ER å›³ã‚’æã„ã¦ã¿ãŸ
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ãªã£ãŸ Fastladder ã® ER å›³ã‚’æã„ã¦ã¿ãŸ 2008-02-10-1: [SQLite] Livedoor ã® Fastladder ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ãªã£ãŸã¨ã„ã†ã“ã¨ã§ã€å‹‰å¼·ã‚’å…¼ãã¦ ER å›³ã‚’æã„ã¦ã¿ã¾ã—ãŸã€‚ (ã‚¯ãƒªãƒƒã‚¯ã§å¤§ãããªã‚Šã¾ã™) ä½¿ã£ãŸãƒ„ãƒ¼ãƒ«ã¯ DBDesigner 4 (æ—¥æœ¬èªžç‰ˆ) ã§ã™ã€‚ DBDesigner 4 ã§ã¯ã€SQLite 3.x ã®ãƒ‡ãƒ¼ã‚¿ãŒèªã‚ãªã„ã‚ˆã†ãªã®ã§ã€SQLite ODBC Driver ã‚’ä½¿ã£ã¦ã€ODBC ã§èªã¿è¾¼ã¿ã€ãƒªãƒãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã—ã¾ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®šç¾©ã¯ã‚½ãƒ¼ã‚¹ã‚’è¦‹ãªãŒã‚‰ä½œæˆä¸ã§ã™ãŒã€ã‚ã¾ã‚Š Ruby ãŒåˆ†ã‹ã£ã¦ã„ãªã„ã®ã§æ™‚é–“ãŒã‹ã‹ã‚Šãã†ã§ã™ã€‚ã€‚ã€‚ãã®ã†ã¡å…¬é–‹ã—ã¾ã™ã€‚ - Fastladder Open Source http://fastladder.org/
koto2 2008/02/11
Database

Open Source
ãƒªãƒ³ã‚¯
1