[B! RDB] tks_periodã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tks_period id:tks_period

RDBã«é–¢ã™ã‚‹tks_periodã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (35)

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

Facebookã‚„Googleã€ã€ŒWebScaleSQLã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹
ç±³Facebookã¯3æœˆ27æ—¥ï¼ˆç¾åœ°æ™‚é–“ï¼‰ã€ç±³Googleã€ç±³Twitterã€ç±³LinkedInã¨å”åŠ›ã—ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMySQLã€ã®ãƒ–ãƒ©ãƒ³ãƒã€ŒWebScaleSQLã€ã‚’GitHubã§å…¬é–‹ã—ãŸã¨ç™ºè¡¨ã—ãŸã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯GNU General Public License Ver.2ã€‚ WebScaleSQLã¯ã€MySQLã‚’å¤§è¦æ¨¡ãªã‚·ã‚¹ãƒ†ãƒ ã§ä½¿ã†4ç¤¾ãŒç›´é¢ã™ã‚‹å…±é€šã®å•é¡Œã‚’è§£æ±ºã™ã‚‹ç›®çš„ã§å…±åŒé–‹ç™ºã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€MySQLã«å¤§è¦æ¨¡ãªç’°å¢ƒã¸ã®å°Žå…¥ã«ç‰¹åŒ–ã—ãŸæ©Ÿèƒ½ã‚’è¿½åŠ ã—ãŸã‚‚ã®ã¨ã„ã†ã€‚ é–¢é€£è¨˜äº‹ Facebookã€æ–°ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã€ŒHackã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ FacebookãŒç¤¾å†…ã§ä½¿ã£ã¦ã„ã‚‹PHPãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã€ŒHackã€ã‚’BSDãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å…¬é–‹ã—ãŸã€‚ Twitterã€MySQLã®ç‹¬è‡ªãƒ„ãƒ¼ãƒ«ã‚’GitHubã§å…¬é–‹ TwitterãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹My
tks_period 2014/03/28
ãƒ¡ãƒ¢

MySQL

RDB
ãƒªãƒ³ã‚¯
ã€Œã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°éƒ½å¸‚ä¼èª¬ã€ã¯ã»ã‚“ã¨ã«éƒ½å¸‚ä¼èª¬?ï¼ˆãã®1) - æœ€é€Ÿé…ä¿¡ç ”ç©¶ä¼š(@yamaz)
ã€Œã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°éƒ½å¸‚ä¼èª¬ã€ã¨ã„ã†å˜èªžãŒã‚ã‚‹.ã‹ã„ã¤ã¾ã‚“ã§ã„ã†ã¨ ã€Œã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã£ã¦ä¸€èˆ¬çš„ã«é€Ÿã„ã¨è¨€ã‚ã‚Œã¦ã„ã‚‹ã‘ã©,ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒ å¤šããªã‚‹ã¨æŽ¥ç¶šç¶æŒã®ã‚³ã‚¹ãƒˆãŒå¤§ãããªã‚‹ã‹ã‚‰ä»Šã¨ãªã£ã¦ã¯é€Ÿããªã„ã‚“ã˜ã‚ƒã?ã€ ã¨ã„ã†ã‚‚ã®ã . WEB+DB PRESS vol.33ã§nipotanã•ã‚“ã®ä¸ã®äººãŒæ›¸ã„ã¦ãŸè¨˜äº‹ãŒç™ºç«¯ã ã¨æ€ã‚ã‚Œã‚‹. ã‚ã¨ã“ã‚“ãªã‚¨ãƒ³ãƒˆãƒªã‚‚ã‚ã£ãŸ. hori-uchi.com ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°éƒ½å¸‚ä¼èª¬ã¯æ£ã—ãã† ã¾ãŸã¡ã‚‡ã£ã¨å¤ã„ããŸã§ã™ãŒã€WEB+DB PRESS vol.33ã§nipotanã•ã‚“ãŒæ›¸ã„ã¦ãŸã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°éƒ½å¸‚ä¼èª¬ã‚’èªã‚“ã æ™‚ã€ã»ã‚“ã¨ã®ã¨ã“ã‚ã©ã£ã¡ãŒé€Ÿã„ã®ã‹ã£ã¦ã®ã‚’abã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ã¨ã£ã¦ã¿ã¾ã—ãŸã€‚ (snip) ã“ã‚Œä»¥å¤–ã«ã‚‚ã„ãã¤ã‹ãƒ‘ã‚¹ã‚’æ›¿ãˆã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ã¨ã£ãŸã¨ã“ã‚ã€ã„ãšã‚Œã‚‚è‹¥å¹²ã§ã™ãŒãƒ—ãƒ¼ãƒªãƒ³ã‚°ã—ãªã„ã»ã†ãŒæ—©ã‹ã£ãŸã®ã§ã€ç¾åœ¨ã¯ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã—ãª
tks_period 2013/09/05
ãƒ¡ãƒ¢

RDB
ãƒªãƒ³ã‚¯
MySQL ã®NULL ã§ã¯ã¾ã£ãŸã“ã¨ã‚ã‚Œã“ã‚Œ - LukeSilviaâ€™s diary
MySQL ã«é™ã‚‰ãšã€SQL ã®NULL ã®ä»•æ§˜ã«ã¯ä½•å›žã‹ã€Œãˆã£ã€ã¨é©šãã“ã¨ãŒã‚ã£ãŸã®ã§ãƒ¡ãƒ¢ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚5.1 ç‰ˆã®æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãŒãªã‹ã£ãŸã‚‚ã®ã«ã¤ã„ã¦ã¯ã€4.1 ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’å‚ç…§ã—ã¾ã—ãŸã€‚ ãã‚‚ãã‚‚NULL ã¯ä½•ã‚’æ„å‘³ã™ã‚‹ã‹ NULL ã¯æœªå®šç¾©ã¾ãŸã¯ã€ä¸æ˜Žã‚’æ„å‘³ã™ã‚‹ã€‚ã€Œé›»è©±ç•ªå·ã‚’æŒãŸãªã„ã€ã¨ã„ã†ã“ã¨ã‚’è¡¨ç¾ã™ã‚‹å ´åˆã¯ã€NULL ã§ã¯ãªãã€ç©ºã®æ–‡å—åˆ—ã‚’ä½¿ã†ã€‚ NULL å€¤ã¨ã„ã†ã‚‚ã®ã‚’ SQL åˆå¿ƒè€…ã¯ã‚ˆãæ··ä¹±ã—ã¾ã™ã€‚SQL åˆå¿ƒè€…ã¯ã€å¤šãã®å ´åˆã€NULL ãŒç©ºæ–‡å— "" ã¨åŒã˜ã§ã‚ã‚‹ã¨è€ƒãˆã¦ã—ã¾ã„ã¾ã™ã€‚ã“ã‚Œã¯é•ã„ã¾ã™ã€‚ãŸã¨ãˆã°ã€ä»¥ä¸‹ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¯å®Œå…¨ã«åˆ¥ã®ã‚‚ã®ã§ã™ã€‚ mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (""); ã©ã¡ã‚‰ã®ã‚¹
tks_period 2010/03/23
RDB

MySQL

ãƒ—ãƒã‚°ãƒ©ãƒ

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼šæƒ…å ±ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ï¼šè„†å¼±æ€§å¯¾ç– :ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã‚’å…¬é–‹
IPAï¼ˆç‹¬ç«‹è¡Œæ”¿æ³•äººæƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ã€ç†äº‹é•·ï¼šè¥¿åž£ æµ©å¸ï¼‰ã¯ã€ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã‚’ç‹™ã£ãŸSQL(*1)ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒ(*2)ãŒç¶™ç¶šã—ã¦ã„ã‚‹ã“ã¨ã‹ã‚‰ã€ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³(*3)ã®å®‰å…¨ãªå®Ÿè£…æ–¹æ³•ã‚’è§£èª¬ã—ãŸè³‡æ–™ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã‚’2010å¹´3æœˆ18æ—¥ï¼ˆæœ¨ï¼‰ã‹ã‚‰IPAã®ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã§å…¬é–‹ã—ã¾ã—ãŸã€‚ URLï¼šhttp://www.ipa.go.jp/security/vuln/websecurity.html è¿‘å¹´ã€ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã‚’ç‹™ã£ãŸæ”»æ’ƒãŒç¶™ç¶šã—ã¦ã„ã¾ã™ã€‚æ”»æ’ƒã®å®Ÿä¾‹ã¨ã—ã¦ã€IPAãŒç„¡å„Ÿã§å…¬é–‹ã—ã¦ã„ã‚‹ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ¤œå‡ºãƒ„ãƒ¼ãƒ«iLogScanner(*4)ã€ã§ã€ã€Œè„†å¼±æ€§å¯¾ç–æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹JVN iPedia(*5)ã€ã®ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ã‚’è§£æžã—ãŸäº‹ä¾‹ã‚’å›³1ã«ç¤ºã—ã¾ã™ã€‚ å›³1ã‚’è¦‹ã‚‹ã¨ã€2008å¹´é ƒã‹ã‚‰æ€¥å¢—ã—ã¦ã„ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒãŒå…¨ä½“ã®45%ã€ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãƒ•ã‚¡ã‚¤
tks_period 2010/03/19
ãƒ—ãƒã‚°ãƒ©ãƒ

SQL

RDB

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

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹ï¼šãƒ¦ã‚«ã‚¤ã€ãƒ„ãƒ¼ã‚«ã‚¤ã€ã‚«ã‚¤ãƒãƒ„ç’°å¢ƒï¼ï¼ˆ11ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ ç„¡æ–™ã®Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŒERMasterã€ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’è¡Œã†ã¨ãã«çš†ã•ã‚“ã¯ã€ã©ã®ã‚ˆã†ã«ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã„ãã¤ã‹ã®ç„¡æ–™ã§åˆ©ç”¨ã§ãã‚‹ãƒ„ãƒ¼ãƒ«ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç†è€…ã¯ãã‚Œã‚‰ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã—ãŸãŒã€æœ€è¿‘ã€ŒERMasterã€ã¨å‘¼ã°ã‚Œã‚‹Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®å˜åœ¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ ERMasterã¯ã€ã»ã‹ã®ãƒ„ãƒ¼ãƒ«ã«æ¯”ã¹ã€ç›´æ„Ÿçš„ã§åˆ†ã‹ã‚Šã‚„ã™ã„UIï¼ˆãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ï¼‰ã«ã€ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºå¯èƒ½ãªã€Excelã§å‡ºåŠ›ã§ãã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã€è¾žæ›¸æ©Ÿèƒ½ãªã©ç—’ã„ã¨ã“ã‚ã«æ‰‹ãŒå±ŠãERãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚æœ¬ç¨¿ã§ã¯ã€ã“ã®ERMasterã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ERMasterã®ä¸»ãªç‰¹å¾´ã€8ã¤ ERMasterã«ã¯ã€ä¸»ã«æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ ã€1ã€‘ç›´æ„Ÿçš„ã§ä½¿ã„ã‚„
tks_period 2010/01/22
RDB

ãƒ—ãƒã‚°ãƒ©ãƒ

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
Sign in - Google Accounts
Not your computer? Use a private browsing window to sign in. Learn more about using Guest mode
tks_period 2009/02/17
MySQLå´ã§N-Gramæ¤œç´¢ã•ã›ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³

ãƒ—ãƒã‚°ãƒ©ãƒ

RDB

æ¤œç´¢

MySQL

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

æ§‹é€

è¨è¨ˆ

ãƒ—ãƒã‚°ãƒ©ãƒ

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
å‚æœ¬å¤šèžã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢æ¥ç•Œã‚¤ãƒ³ã‚µã‚¤ãƒ‰ã‚¢ã‚¦ãƒˆ GoogleãŒOracleã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é ˜åŸŸã§è¡çªã™ã‚‹æ—¥ï¼šBigtable vs Berkeley DB
CNET Japanèªè€…ãƒ–ãƒã‚¬ãƒ¼ sparklegateã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼RDBMSã¯æœ¬å½“ã«ä¾¿åˆ©ãªã®ã‹ã¯å•é¡Œæèµ·ã¨ã—ã¦ãã—ã¦ã€ã„ã‚ã„ã‚å¯„ã›ã‚‰ã‚ŒãŸã‚³ãƒ¡ãƒ³ãƒˆãŒéžå¸¸ã«èˆˆå‘³æ·±ãé¢ç™½ã‹ã£ãŸã€‚CPUãƒãƒƒã‚¯ã¨ãƒ‡ã‚£ã‚¹ã‚¯ãƒãƒƒã‚¯ã¨ã„ã†ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ã¤ã„ã¦å¯„ã›ã‚‰ã‚ŒãŸä¸¡æ–¹ã®æ„è¦‹ã¯RDBMSã‚’ã©ã†ä½¿ã£ã¦ã„ã‚‹ã‹ã¨ã„ã†ä½¿ã„æ–¹ã®å·®ã§ã‚‚ã‚ã‚Šã€ã€Œä½•ã§ã‚‚å…¥ã‚‹ä¾¿åˆ©ãªå…¥ã‚Œã‚‚ã®ã€ã§ã‚ã‚‹RDBMSã®ç‰¹é•·ãŒã‚ˆãç¾ã‚Œã¦ã„ã‚‹è¨¼å·¦ã ã‚ã†ã€‚ãã—ã¦ã€ã‚ã¾ã‚Šã«ä¾¿åˆ©ã™ãŽã‚‹ãŒã‚†ãˆã«ã€è‹¦æ‰‹ãªé ˜åŸŸã«ã‚‚ä½¿ã‚ã‚Œã¦ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ï¼ˆæ‹¡å¤§æ€§ï¼‰ã®å•é¡Œã«ã¶ã¤ã‹ã‚Šã€ã€Œæœ¬å½“ã«ä¾¿åˆ©ãªã®ã‹ã€ã¨ã„ã†ç´ æœ´ãªå˜†ãã«è‡³ã‚‹ã¨ã„ã†çŠ¶æ³ã¯ã€çš®è‚‰ãªã®ã‹æœ¬æ°—ãªã®ã‹ã€ã„ãšã‚Œã«ã—ã‚ã‚ã‚ŠãŒã¡ãªã“ã¨ã ã‚ã†ã€‚ ã²ã£ãã‚Šã¨è¡¨ã«å‡ºã¦ããŸGoogleã‚’æ”¯ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼šBigtable ãã‚“ãªãŠã‚Šã€steps to phantasienã®2006-9-11ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§Googleã®ã‚¤ãƒ³ãƒ•ãƒ©ã‚’æ”¯ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼
tks_period 2007/05/23
RDB

ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
Railsã¨ABDã¨CRUDã¨ãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼ - moroã®æ—¥è¨˜
ç¾½ç”Ÿã•ã‚“ã®ABD(Activity Based Datamodel)ã§ã™ãŒã€ãã‚Œã‚’çŸ¥ã£ãŸæ„Ÿæƒ³ã‚’è‡ªåˆ†ãªã‚Šã«ã™ã”ãä¹±æš´ã«ã¾ã¨ã‚ã‚‹ã¨ã€DBã‚’ã‚¤ãƒ™ãƒ³ãƒˆç³»ã¨ãƒªã‚½ãƒ¼ã‚¹ç³»ã«ã‚ã‘ãŸä¸Šã§ã€ä»•äº‹ã£ã¦ã„ã†ã®ã¯ãƒªã‚½ãƒ¼ã‚¹é–“ã‚„ã‚¤ãƒ™ãƒ³ãƒˆã¨ãƒªã‚½ãƒ¼ã‚¹ã®é–“ã«ãªã‚“ã‚‰ã‹ã®é–¢ä¿‚ã‚’ç™ºç”Ÿã•ã›ã‚‹æ‰ãˆã‚‹ã€ã¨ã„ã†è€ƒãˆæ–¹ã‹ãªãã€ã¨ã€‚ ã‚¤ãƒ™ãƒ³ãƒˆã¨ãƒªã‚½ãƒ¼ã‚¹ å£²ä¸Šã’ãŒç«‹ã¤ã€ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã¯ã¤ã¾ã‚ŠãŠå®¢ã•ã‚“(ãƒªã‚½ãƒ¼ã‚¹)ã¨å•†å“(ãƒªã‚½ãƒ¼ã‚¹)ã¨ã®é–“ã«è³¼å…¥/å…¥é‡‘ã¨ã„ã†é–¢é€£ãŒç™ºç”Ÿã™ã‚‹ã¨ã„ã†ãµã†ã«æ‰ãˆã‚‰ã‚Œã¾ã™ã€ã¨ã€‚ ã‚ã‚“ã¾ã‚Šä¾‹ãˆãŒè‰¯ãã‚ã‚Šã¾ã›ã‚“ãŒã€ãƒ“ã‚¸ãƒã‚¹ä¸Šã®ã§ãã”ã¨ï¼ã‚¤ãƒ™ãƒ³ãƒˆã«ç€ç›®ã—ã€ã‚¤ãƒ™ãƒ³ãƒˆã‚‚é–¢é€£ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚’ç´ ç›´ã«createã™ã‚‹ã“ã¨ã§è¡¨ç¾ã™ã‚‹ã¨ã„ã†æ–¹æ³•è«–ã ã¨èªã‚“ã§ã„ã¾ã™ã€‚ ã•ã‚‰ã«DBã‚’è¨è¨ˆã™ã‚‹ã¨ã„ã†ã“ã¨ã¯ã€ãã†ã„ã£ãŸã‚¤ãƒ™ãƒ³ãƒˆã€ã™ãªã‚ã¡ãƒ“ã‚¸ãƒã‚¹ä¸Šã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ“ãƒ†ã‚£ã‚’ã©ã†è¨˜éŒ²ã™ã‚‹ã‹ã€ã¨ã„ã†è¦³ç‚¹ã§ãƒ‡ãƒ¼ã‚¿ã®æŒã¡ã‹ãŸã‚’è¨è¨ˆã—ã¦ã„ãã¨ã„ã†ã“ã¨ãªã‚“ã˜ã‚ƒãªã„ã§ã—ã‚‡
tks_period 2007/05/21
Ruby

RDB

ORM

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
EJB3ã¨ABD ãã®1 - ä»Šæ—¥ã¨ã¯é•ã†æ˜Žæ—¥
EJB3ã¨ABD ãã®1 EJB3.0å…¥é–€, æŠ€è¡“, ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘, DB ABD(Activity Based Datamodel)ã§è¨è¨ˆã•ã‚ŒãŸãƒ†ãƒ¼ãƒ–ãƒ«ã‚’EJB3ã§å®Ÿéš›ã«ä½¿ã£ã¦ã¿ã‚‹ã€‚ ABDã®å¾©ç¿’ ã¾ãšã¯ABDã®å¾©ç¿’ã‹ã‚‰ã€‚ ä½¿ç”¨ã™ã‚‹Entityã¯ã€å…ˆæ—¥ã®SeasarConferenceã®ã‚»ãƒƒã‚·ãƒ§ãƒ³è³‡æ–™ã‹ã‚‰æ‹å€Ÿã€‚ Resourceç³»Entity é¡§å®¢ å•†å“ Eventç³»Entity å£²ä¸Š å£²ä¸Šæ˜Žç´° é€šå¸¸ã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« Eventç³»Entityã¨Resourceç³»Entityã‚’é–¢é€£ã•ã›ã‚‹ãŸã‚ã«ã€FKã‚’è¨å®šã™ã‚‹ã€‚ æ¥½ã€…ERDãƒ¬ãƒƒã‚¹ãƒ³ (CodeZine BOOKS)ã‚’èªã‚“ã æ®µéšŽã ã¨ã€ã“ã‚“ãªæ„Ÿã˜ã®ãƒ¢ãƒ‡ãƒ«ã«ãªã‚‹ã®ã ã‚‰ã†ã‹ã€‚ ABDã¸ ABDã¯Entityé–“ã®é–¢é€£ã«ã€ã‚ˆã‚Šç„¦ç‚¹ã‚’ã‚ã¦ã¦ã„ã‚‹ã‚ˆã†ã ã€‚ é€šå¸¸ã€FKã«ã‚ˆã£ã¦é–¢é€£ãŒè¡¨ç¾ã•ã‚Œã¦ã„ã‚‹ãŒã€ãã®ã›ã„ã§1:mã ã¨ã‹m:mã®ã‚ˆã†ãªå°é›£ã—é–¢é€£ãŒå‡ºã¦ãã¦ã—
tks_period 2007/05/21
RDB

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
http://komagata.sakura.ne.jp/wiki/index.php?65536%C7%DC%C2%AE%A4%A4SQL
tks_period 2007/05/16
RDB

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
MOONGIFT: Â» SQLiteã‚’GUIã§ç®¡ç†ã€ŒSQLite Database Browserã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
SQLiteã¯DLLãƒ•ã‚¡ã‚¤ãƒ«ã ã‘ã§ã™ãã«åˆ©ç”¨ã§ãã‚‹ç°¡æ˜“çš„ãªDBã§ã¯ã‚ã‚‹ãŒã€æ€ã£ã¦ã„ã‚‹ã‚ˆã‚Šã‚‚ã—ã£ã‹ã‚Šã¨å‹•ä½œã—ã¦ãã‚Œã‚‹ã€‚ ä»–ã®DBã®ã‚ˆã†ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚æ‰‹é–“ã‚‚ãªãã™ãã«åˆ©ç”¨ã§ãã‚‹ã®ãŒä¾¿åˆ©ã ã€‚æœ€è¿‘ã¯PHP5ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒã‚‚å¢—ãˆãŸã®ã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¢ãƒƒãƒ—ã™ã‚‹ã ã‘ã§ã™ãã«åˆ©ç”¨ã§ãã‚‹ã¨ã„ã†ã®ã‚‚æ‰‹è»½ã§ã„ã„ã€‚ ãã‚“ãªSQLiteã§ã‚ã‚‹ãŒã€ç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã¯æ¨™æº–ã§ã¯ç”¨æ„ã•ã‚Œã¦ã„ãªã„ã€‚æ™®åŠã®ãŸã‚ã«ã¯é«˜æ©Ÿèƒ½ã€ã‹ã¤æ‰‹è»½ãªç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã®å˜åœ¨ã¯æ¬ ã‹ã›ãªã„ã ã‚ã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯SQLite Database Browserã€SQLiteã‚’GUIã§æ“ä½œã§ãã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ SQLite Database Browserã‚’ä½¿ã†ã¨ã€GUIãƒ™ãƒ¼ã‚¹ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆã¯ã‚‚ã¡ã‚ã‚“ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¨è¨ˆã‚„ãƒ‡ãƒ¼ã‚¿ã®ç·¨é›†ãŒã§ãã‚‹ã€‚SQLã‚’å®Ÿè¡Œã—ã¦çµæžœã‚’è¦‹ã‚‹ã“ã¨ã‚‚å¯èƒ½ã ã€‚ã‚‚ã¡ã‚ã‚“ã€æ—¥æœ¬èªžã«å¯¾å¿œ
tks_period 2007/04/27
ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢

ãƒ—ãƒã‚°ãƒ©ãƒ

RDB

SQLite

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
Hironobu's HomePage: MySQLã®å†…éƒ¨æ§‹é€
tks_period 2007/04/26
ã‚·ã‚¹ãƒ†ãƒ

MySQL

RDB

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
ãƒ•ãƒªãƒ¼ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° for windows. - ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ä¸»ã«ãƒ•ãƒªãƒ¼ã§åˆ©ç”¨ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æƒ…å ±ã‚’è¨˜è¼‰ã—ã¦ã„ã¾ã™ã€‚ Firebirdã‚„PostgreSQLã€MySQLç‰ã®æƒ…å ±ã‚’è¨˜è¼‰ã—ã¦ã„ã¾ã™ã€‚ ãƒ•ãƒªãƒ¼ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ Firebird Firebirdã¯ã€å•†ç”¨ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹InterBaseã‚’èµ·æºã«ã‚‚ã¤ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã® ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ Firebirdã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Firebirdã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é †ã‚’è¨˜è¼‰ã—ã¾ã—ãŸã€‚ MinGW(gcc)ã§Firebirdã‚’ä½¿ã£ã¦ã¿ã‚‹(1) (2) (3) MinGW(gcc)ç’°å¢ƒã§ã€InterBase APIã‚’ä½¿ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆã‚’è©¦ã—ã¦ ã¿ã¾ã—ãŸã€‚ã¾ãŸã€ŒFirebird 1.5.2 Embedded Serverã€ã‚‚è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ (2)ä»¥é™ã§ã¯å„ç¨®SQLæ–‡ã®ç™ºè¡Œç‰è¨˜è¿°ã—ã¦ã„ã¾ã™ã€‚ Firebird Firebirdã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã§ã™ã€‚Firebi
tks_period 2007/04/24
RDB

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
FrontPage - Firebird Wiki
Firebird â€ 20å¹´ä»¥ä¸Šã®æ´å²ã‚’æŒã¤å•†ç”¨RDBã‚½ãƒ•ãƒˆã€ŒInterBase(R)ã€ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ç‰ˆã‚’å…ƒã«é–‹ç™ºã•ã‚Œã¦ã„ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã§ã™ã€‚Windows/Linuxã®ãƒã‚¤ãƒŠãƒªç‰ˆã‚„ODBC/JDBC/.Netãªã©ã®ãƒ‰ãƒ©ã‚¤ãƒã‚‚åŒæ§˜ã«æä¾›ã•ã‚Œã¦ãŠã‚Šã€åŸºæœ¬çš„ã«ã¯ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãƒ•ãƒªãƒ¼ã§ä½¿ç”¨ã§ãã¾ã™ã€‚(è©³ç´°ã¯FAQã‚’å‚ç…§) æ´å²ãŒé•·ã„å•†ç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå…ƒã¨ãªã£ã¦ã„ã‚‹ãŸã‚ä¿¡é ¼æ€§ã‚‚é«˜ãã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ãªã©ã®åŸºæœ¬çš„ãªæ©Ÿèƒ½ã‚‚æ¦‚ãæƒã£ã¦ã„ã¾ã™ã—ã€SQL-92æº–æ‹ +SQL-99ã®ä¸€éƒ¨ã‚’å–ã‚Šå…¥ã‚Œã¦ã„ã¦äº’æ›æ€§ã‚‚é«˜ã„ã§ã™ã€‚GUIãƒ™ãƒ¼ã‚¹ã®ç®¡ç†ãƒ„ãƒ¼ãƒ«ã‚‚ã‚ã‚Šã¾ã™ã€‚ ãƒ™ãƒ¼ã‚¹ã«ãªã£ãŸInterBase(R)ã¯Windowsä¸Šã§ã®å‹•ä½œå®Ÿç¸¾ã‚‚é•·ãã€ã¾ãŸã€Borlandç¤¾ã®å¸‚è²©é–‹ç™ºãƒ„ãƒ¼ãƒ«ã«ã¯æ¨™æº–æ·»ä»˜ã•ã‚Œã¦ã‚‹ã“ã¨ãŒå¤šã„ã®ã‚‚ã‚ã‚Šã€ç‰¹ã«Borlandç¤¾ã®é–‹ç™ºãƒ„ãƒ¼ãƒ«ã¨ã¯ç›¸æ€§ãŒè‰¯ã„ã§ã™ã€‚ä»–ã«ã¯PHPã«ã‚‚å°‚ç”¨é–¢æ•°
tks_period 2007/04/24
RDB

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
Microsoftã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã£ã¦â€¦ - ã¿ã‹ãƒã‚°
SQL Server ã‚’åˆ©ç”¨ã—ãŸã„ã¨æ€ã£ã¦ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã‚’è‰²ã€…èª¿ã¹ã¦ã¿ã‚‹ã¨ï¼Œã“ã‚Œã¾ãŸãªã‹ãªã‹ã‚„ã‚„ã“ã—ãï¼Ž åŒ¿åã®Webã‚µã‚¤ãƒˆã‚’ç½®ãã ã‘ã§ã‚ã‚Œã°å•é¡Œã¯ãªã„ãŒï¼Œæ™®é€šã«ä¼šå“¡ã‚µã‚¤ãƒˆã‚’ä½œã‚ã†ã¨ã™ã‚‹ã¨éžå¸¸ã«é›£ã—ã„ï¼Ž ãƒ»SQL Server ã«ã¯ãƒ¦ãƒ¼ã‚¶ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¨CPUãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãŒã‚ã‚‹ãŒï¼ŒWindows Server ã«ã¯CPUãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãŒç„¡ã„ï¼Ž ãƒ»åŒ¿åã®ã‚¢ã‚¯ã‚»ã‚¹ä»¥å¤–ã«ã¯CALãŒå¿…è¦ï¼Ž ãƒ»SQL Server ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã ã‘ã§ã‚‚ï¼ŒWindows Server ã®CALãŒå¿…è¦ï¼Žã‚‚ã¡ã‚ã‚“æœ«ç«¯ã®ãƒ¦ãƒ¼ã‚¶æ•°ã§ã‚«ã‚¦ãƒ³ãƒˆï¼Ž ãƒ»Windowsèªè¨¼ã˜ã‚ƒãªãã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç‹¬è‡ªã®èªè¨¼ã‚’ã‚„ã£ã¦ã„ã¦ã‚‚CALãŒå¿…è¦ï¼Ž SQL Server ã®å®Ÿè¡Œã«ã¯ Windows Server ãŒå¿…é ˆãªã®ã§ï¼Œã“ã‚Œã§ã¯ CPUãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®æ„å‘³ãŒã»ã¨ã‚“ã©ç„¡ã„ï¼Žï¼Žï¼Ž Windows Server ã«ã¯ï¼ŒCPUãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¨ä¼¼ãŸã‚ˆã†ãªã‚¨ã‚¯ã‚¹ã‚¿ãƒ¼ãƒŠãƒ«ã‚³ãƒ
tks_period 2007/04/23
ã ã‚Šãƒâ€¦

ã‚·ã‚¹ãƒ†ãƒ

RDB

MS
ãƒªãƒ³ã‚¯
ã€Œã¡ã‚‡ã£ã¨å¾…ã¦ã€ çœŸãƒ»MySQLã®ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹10ã®Tipsï¼šCodeZine
Jaslabs: High performance phpã§ç´¹ä»‹ã•ã‚ŒãŸã€ŒMySQLã®ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹10ã®Tipsã€ã«å¯¾ã—ã¦ã€åè«–ã—ã¦ã„ã‚‹äººãŒã„ã‚‹ã€‚ãƒ–ãƒã‚°ã€Œ20bitsã€ã®Jesseæ°ã ã€‚å½¼ã¯ã€Œ10 Tips for Optimizing MySQL Queries (That donâ€™t suck)ã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã€Jaslabsæ°ã®è¨˜äº‹ã¯é©åˆ‡ã§ãªã„ã¨ã—ã¦ã„ã‚‹ã€‚ Jesseæ°ã®çµŒé¨“ã«ã‚ˆã‚Œã°ã€SQLæœ€é©åŒ–ã§æœ€ã‚‚é‡è¦ãªã“ã¨ã¯SQLã‚„DBã®åŸºæœ¬ã‚’ã—ã£ã‹ã‚Šã¨ç†è§£ã™ã‚‹ã“ã¨ã§ã‚ã‚Šã€60ï¼…ãŒã“ã‚Œã§è§£æ±ºã™ã‚‹ã¨ã„ã†ã€‚æ®‹ã‚Š35ï¼…ã¯DBã‚„ã‚¯ã‚¨ãƒªã®ç‰¹æ®Šãªæ€§è³ªã«å¯¾ã™ã‚‹å¯¾å‡¦ã§ã‚ã‚Šã€æœ€å¾Œã®5ï¼…ã§ç™ºæƒ³ã®è»¢æ›ãªã©ã‚’æ±‚ã‚ã‚‰ã‚Œã‚‹ã€‚Jaslabsæ°ã¯ã“ã“ã«ã°ã‹ã‚ŠåŠ›ã‚’å…¥ã‚Œã¦ãŠã‚Šã€ãã‚Œã¯ã¾ã£ãŸãã‚‚ã£ã¦æ™‚é–“ã®ç„¡é§„ã ã¨è¿°ã¹ã¦ã„ã‚‹ï¼ˆJesseæ°ã¯ã€ŒSQL_SMALL_RESULTãªã‚“ã¦ã€ç”Ÿã¾ã‚Œã¦ã“ã®æ–¹ä½¿ã£ãŸã“ã¨ã™ã‚‰ãªã„ã€ã¨ã¾ã§è¨€
tks_period 2007/04/12
Tipsã£ã¦ç¨‹æµ…ãã¯ãªã„ã‚ˆãªã€‚RDBã«é–¢ã—ã¦ã¡ã‚ƒã‚“ã¨å‹‰å¼·ã—ãªã„ã¨ãªãã€‚

MySQL

RDB
ãƒªãƒ³ã‚¯
MySQLã§å…¨æ–‡æ¤œç´¢ - FULLTEXTã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
tks_period 2007/03/15
ãƒ—ãƒã‚°ãƒ©ãƒ

RDB

MySQL

ãƒ¡ãƒ¢
ãƒªãƒ³ã‚¯
SQLite Control Center - SQLiteCC
SQLite Control Center (SQLiteCC) SQLite Control Center is a visual tool for working with SQLite database files. Click here for the project website on SourceForge.net. Features Create a new database or open an existing one. View table data, fields, schema, indexes and triggers. Edit table data in a grid display. Construct queries using a syntax-highlighting text editor, and then view the results in
tks_period 2007/01/05
ä»¥å‰ã®ãƒšãƒ¼ã‚¸ãŒç„¡ããªã£ãŸã¨æ€ã£ã¦ãŸã‚‰sourceforgeã«æ¥ã¦ãŸã®ã‹ã€‚

RDB
ãƒªãƒ³ã‚¯
mysql ã‚’é«˜é€ŸåŒ–ã—ãŸã„ã¨ãã«èªã‚€ãƒ¡ãƒ¢ (TechKnowledge)
çµ¦æ–™ã®æŒ¯è¾¼å£åº§ã¨ã—ã¦ä¸‰äº•ä½å‹éŠ€è¡Œã«å£åº§ã‚’æŒã£ã¦ã„ã¾ã™ã€‚è‡ªå‹•æ”¯æ‰•ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ç”¨ã—ã¦å…‰ç†±è²»ç‰ã®å…¬å…±æ–™é‡‘ã®æ”¯æ‰•ã„ã‚’ã—ã¦ã„ã¾ã™ãŒã€å…ˆæ—¥ãã‚Œã‚‰ã®å†…ã®ä¸€ã¤ã‚’å¤±å¿µã—ã¦ãŸã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚å£åº§ã‚’ç¢ºèªã—ãŸæ™‚ã«ã¯ã™ã§ã«å¼•ãè½ã¨ã—ãŒå®Œäº†ã—ã¦ã„ãŸãŸã‚ã€æ‰‹å…ƒã®è³‡é‡‘ãŒå¿ƒç´°ããªã£ãŸçŠ¶æ…‹ã§æ•°æ—¥ã‚’éŽã”ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸‰äº•ä½å‹éŠ€è¡Œã§å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒå¯èƒ½ã§ã‚ã‚Œã°ã€æ˜¯éžåˆ©ç”¨ã—ãŸã„ã®ã§ã™ãŒã€‚ é‹ãŒè‰¯ã‘ã‚Œã°ã€ä¸‰äº•ä½å‹éŠ€è¡Œã®å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã¯å¯èƒ½ ä¸‰äº•ä½å‹éŠ€è¡Œã®ç‰¹å¾´ã¯ã¾ãšã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ä¼šç¤¾ã¨ã®é€£æºã—ãŸã‚µãƒ¼ãƒ“ã‚¹ãŒé…åŠ›çš„ãªã“ã¨ãŒã‚ã’ã‚‰ã‚Œã¾ã™ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã§ã¯éŠ€è¡Œã‚«ãƒ¼ãƒ‰ãƒãƒ¼ãƒ³ã§ã™ã‹ã‚‰ã€ä½•ã‚ˆã‚Šå®‰ã„é‡‘åˆ©ãŒå¤§ãã„åˆ©ç‚¹ã«ãªã‚Šã¾ã™ã€‚æ¦‚ãéŠ€è¡Œç³»ã®å¯©æŸ»ã«å¿…è¦ãªæ™‚é–“ã¯é•·ããªã‚‹ã‚ˆã†ã§ã™ãŒã€ä¸‰äº•ä½å‹éŠ€è¡Œã§ã¯ã‚«ãƒ¼ãƒ‰ç™ºè¡ŒãŒå½“æ—¥ã«è¡Œãªã£ã¦ãã‚Œã¾ã™ã€‚ ä¸‰äº•ä½å‹éŠ€è¡Œã¯å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒã§ãã‚‹ã‹ã¨è¨€ã†ã¨å¾®å¦™ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ç”³è¾¼ã‹ã‚‰å¯©æŸ»çµæžœã®é€£çµ¡ã¾ã§ã¯ã€åœŸæ—¥
tks_period 2006/11/28
åˆ†ã‹ã‚Šæ˜“ã„ã€‚ãªã‹ãªã‹æ—¥æœ¬èªžã§ã¾ã¨ã‚ã¦ã‚‹æ‰€ç„¡ã„ã‚ˆãã€‚å¤§æ¦‚å…¬å¼ãƒ˜ãƒ«ãƒ—è¦‹ã¦è§£æ±ºã—ã¦ã‚‹ã ã‚ã†ã‘ã©ã€‚ã€€mysqlã‚’é«˜é€Ÿã«å‹•ã‹ãã†ã¨ã™ã‚‹ã¨çµæ§‹ãƒ¡ãƒ¢ãƒªå¿…è¦ãªã‚“ã ã‚ˆãªã€‚ä»¥å‰512MBã—ã‹ãªã„ä¸Šã«httpdã¨å…±æœ‰ã§ã‚„ã£ã¦ãŸã¨ãã¯è‹¦åŠ´ã—ãŸã€‚

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