[B! db] sgtakeruã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sgtakeru id:sgtakeru

dbã«é–¢ã™ã‚‹sgtakeruã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (22)

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

InnoDBè¡Œãƒãƒƒã‚¯å¾…ã¡ã®ç§’æ•°ã‚’ã‚»ãƒƒã‚·ãƒ§ãƒ³å˜ä½ã§æŒ‡å®šã™ã‚‹[MySQL 5.1, MySQL 5.5ã®å ´åˆ] | ã‚ãƒ ãƒ©ãƒ‡ãƒ¼ãƒ“ãƒ¼ãƒ–ãƒã‚°
InnoDBã®è¡Œãƒãƒƒã‚¯å¾…ã¡æ™‚é–“ã¯ç§’å˜ä½ã§innodb_lock_wait_timeoutã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã«æŒ‡å®šã—ãŸæ™‚é–“å¾…ã¤ä»•æ§˜ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚(ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯50ç§’) ãŸã MySQLã§ã¯ã“ã®å¤‰æ•°ã¯ã‚°ãƒãƒ¼ãƒãƒ«ã§ã—ã‹è¨å®šã§ããšã€ä¸€éƒ¨ã®ã‚¯ã‚¨ãƒªã®ãŸã‚ã ã‘ã«ã‚°ãƒãƒ¼ãƒãƒ«è¨å®šã‚’å¤‰æ›´ã™ã‚‹ã®ã¯ã‚¤ãƒ³ãƒ‘ã‚¯ãƒˆãŒå¤§ããã€ç‰¹å®šã®æŽ¥ç¶š(ã‚»ãƒƒã‚·ãƒ§ãƒ³)ã‚„ã‚¯ã‚¨ãƒªå˜ä½ã§è¨å®šã§ããªã„ã‹ã¨ã„ã†æ©Ÿèƒ½è¦æ±‚ãŒã‚ã’ã‚‰ã‚Œã¦ã„ã¾ã—ãŸã€‚ innodb_lock_wait_timeout is not dynamic, not per session ãƒ“ãƒ«ãƒˆã‚¤ãƒ³ã®InnoDBã§ã¯ã€ã“ã®å‹•ä½œã¯å¤‰ã‚ã‚Šã¾ã›ã‚“ãŒã€Pluginã®InnoDB(MySQL 5.1 + InnoDB Plugin 1.0, ã‚‚ã—ãã¯MySQL 5.5(InnoDB Plugin 1.1))ã§ã¯ã€innodb_lock_wait_timeoutã«ã‚»ãƒƒã‚·ãƒ§ãƒ³å˜ä½ã®ã‚‚ã®ãŒç”¨æ„ã•ã‚Œã€ä»¥ä¸‹
sgtakeru 2013/06/28
*programming

infrastructure

db

performance
ãƒªãƒ³ã‚¯
RDBMSã«é–¢ã™ã‚‹å…¸åž‹çš„ãªèª¤è§£ãŒçµ¶ãˆãªã„ã¨ã„ã†ç¾å®Ÿ
æ–°å…¥ç¤¾å“¡å¿…èªã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŸºæœ¬ã‚’ç†è§£ã—ã‚ˆã† - ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãªãœå¿…è¦ãªã®ï¼Ÿï¼šITproã¨ã„ã†è¨˜äº‹ã«å¯¾ã™ã‚‹ãƒ–ã‚¯ãƒžã§æ¬¡ã®ã‚ˆã†ãªIDã‚³ãƒ¼ãƒ«ãŒæ¥ãŸã€‚ï¼ˆç¾åœ¨ã¯ã‚³ãƒ¡ãƒ³ãƒˆè¿”ã—ã¸ã®ãŠç¤¼ãŒå…¥ã£ã¦ã„ã‚‹ã®ã§ã€æ–‡å—æ•°åˆ¶é™ã®ãŸã‚ã‚ªãƒªã‚¸ãƒŠãƒ«ã®ã‚³ãƒ¡ãƒ³ãƒˆã¯å°‘ã—åˆ‡ã‚Šè©°ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ï¼‰ "ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’2æ¬¡å…ƒã®è¡¨å½¢å¼ã§è¡¨ç¾"ã“ã†ã„ã†ã®ã‚‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒ2æ¬¡å…ƒæ§‹é€ ã¨ã„ã†èª¤è§£ã®ä¸€ç¨®ãªã‚“ã ã‚ã†ã‹ã€‚id:nippondanjiã•ã‚“ãŒæ›¸ã„ã¦ãŸã‚ˆã†ãªã€‚ ã•ã¦ã€ã“ã®ç–‘å•ã«å¯¾ã™ã‚‹æ£è§£ã¯å¦‚ä½•ãªã‚‹ã‚‚ã®ã ã‚ã†ã‹ï¼Ÿ ã¤ã„å…ˆæ—¥ã€Œ7ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 7ã¤ã®ä¸–ç•Œã€ã®æ›¸è©•ã§æ›¸ã„ãŸã°ã‹ã‚Šã ãŒãƒ»ãƒ»ãƒ» è¨€ã†ã¾ã§ã‚‚ãªããã®é€šã‚Šã§ã‚ã‚‹ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒ2æ¬¡å…ƒçš„ãªæ§‹é€ ã‚’æŒã£ã¦ã„ã‚‹ã¨ã„ã†ã®ã¯å…¸åž‹çš„ãªèª¤è§£ã ã€‚ï¼ˆã¡ãªã¿ã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®æ¬¡å…ƒã¯å±žæ€§ã®æ•°ã«ç‰ã—ã„ã€‚nå€‹ã®å±žæ€§ãŒã‚ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã¯næ¬¡å…ƒã€‚ï¼‰ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦ã¡ã‚ƒã‚“ã¨å¦ç¿’ã—ã¦ã„
sgtakeru 2013/06/01
2æ¬¡å…ƒã ã¨å‹˜é•ã„ã—ã¦ãŸã€‚RDBMSã®ç†è«–ã¯ãŠã‚ãã‹ã«ã—ã¦ã‚‹ã¨ã“ã‚ã ã€‚ã€‚

db

mysql
ãƒªãƒ³ã‚¯
MySQLãŒãŠã‹ã—ã„ï¼ã‚ãªãŸãªã‚‰ã©ã†ã—ã¾ã™ã‹ï¼Ÿ â€“ MySQL Casual Advent Calendar 2011 - As a Futurist...
ã—ã‚ã£ã™ï¼DBA å…¼ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å…¼ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚„ã£ã¦ã‚‹ riywo ã§ã™ã€‚ä½•ã®ãƒã‚¿ã‚’æ›¸ã“ã†ã‹ãªãã¨è€ƒãˆãŸã®ã§ã™ãŒã€æ£ç›´ãƒã‚¿ã‚’ä»•è¾¼ã‚€æ™‚é–“ã‚‚ãªã‹ã£ãŸã®ã§åƒ•ãŒã„ã¤ã‚‚ã‚„ã£ã¦ã‚‹ã“ã¨ã‚’ã•ã‚‰ã£ã¨ç´¹ä»‹ã™ã‚‹ã¨ã„ã†ã“ã¨ã§å‹˜å¼ã—ã¦ä¸‹ã•ã„ï¼žï¼œ MySQL ãŒãŠã‹ã—ã„ï¼ 03:14 hidek: ãªã‚“ã‹ã‚¨ãƒ©ãƒ¼å‡ºã¾ãã£ã¦ã‚‹ã‚“ã ã‘ã©ï¼ 03:14 zigorou: MySQL ã¨é€šä¿¡ã—ã¦ã‚‹ã¨ã“ã£ã½ã„ 03:15 riywo: è¦‹ã¾ã™ ã“ã‚“ãªã‚„ã‚Šã¨ã‚Šã¯çš†ã•ã‚“æ—¥å¸¸èŒ¶é£¯äº‹ã§ã™ã‚ˆãï¼Ÿãï¼Ÿãï¼Ÿã“ã‚“ãªæ™‚ã«ã€DB ã«è²¬ä»»ã‚’æŒã¤ã‚‚ã®ã¨ã—ã¦çœŸã£å…ˆã«å¯¾å¿œã™ã‚‹ã®ãŒåƒ•ã‚‰ã®ä»•äº‹ã§ã™ã€‚ã§ã‚‚ã€ã˜ã‚ƒã‚å…·ä½“çš„ã«ã“ã®ã‚ã¨ä½•ã‚’ã—ã¾ã—ã‚‡ã†ï¼Ÿæ—¢ã«ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¨ãƒ©ãƒ¼ã ã‚‰ã‘ã§ä¸€åˆ»ã‚’äº‰ã†çŠ¶æ…‹ã§ã™ã€‚ (å¯¾å¿œé–‹å§‹) ã¾ãšã¯ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ä»Šå›žã®æ§˜ãªå ´åˆã¯ã‚¢ãƒ—ãƒªã®ã‚¨ãƒ©ãƒ¼ãƒã‚°ã«ã©ã°ã£ã¨ MySQL ã«é–¢ã™ã‚‹ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ã¾ãšã¯ãã‚Œã‚’è¦‹ã‚‹ã“ã¨ãŒå§‹ã¾
sgtakeru 2011/12/27
development

mysql

db

*tips
ãƒªãƒ³ã‚¯
è¤‡åˆä¸»ã‚ãƒ¼ã‚’é¿ã‘ã‚‹ã¹ãç†ç”± - è™Žå¡š
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®è©±ã‚’ã—ã¦ã„ã¦ã€ã€Œé€£ç•ªã®ä¸»ã‚ãƒ¼ã¯æ¥å‹™ä¸Šæ„å‘³ã®ãªã„ãƒ‡ãƒ¼ã‚¿ã ã‹ã‚‰ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«æŒãŸã›ã‚‹ã®ã¯ãƒ ãƒ€ã ã€‚è¤‡åˆä¸»ã‚ãƒ¼ã«ã™ã‚‹ã¹ãã€ã¨ã„ã†æ„è¦‹ã‚’èžãæ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ è„Šé«„åå°„ã§ã€Œãªã„ã‚ãƒ¼ã€ã¨æ€ã£ãŸã‚‚ã®ã®ã€ç†ç”±ã‚’ä¸Šæ‰‹ãèª¬æ˜Žã§ããªã‹ã£ãŸã®ã§ã€æ”¹ã‚ã¦è€ƒãˆã¦ã¿ã¾ã—ãŸã€‚ ãã®çµæžœã€æ¬¡ã®ã‚ˆã†ãªçµè«–ã«è‡³ã‚Šã¾ã—ãŸã€‚ å˜ä¸€ã®é€£ç•ªã‚«ãƒ©ãƒ ã«ã‚ˆã‚‹ä¸»ã‚ãƒ¼ã¨ã€è¤‡åˆã‚«ãƒ©ãƒ ã«ã‚ˆã‚‹ä¸»ã‚ãƒ¼ã¨ã§è¿·ã£ãŸã‚‰ å®Ÿè£…ã‚’ã‚·ãƒ³ãƒ—ãƒ«ã«ã—ã€æ¥å‹™å¤‰æ›´ã®å½±éŸ¿ç¯„å›²ã‚’å°ã•ãã™ã‚‹ãŸã‚ã«ã€è¤‡åˆä¸»ã‚ãƒ¼ã‚’é¿ã‘ã‚‹ ã¨ã„ã†ã‚ã‘ã§ã€èª¿ã¹ãŸã“ã¨ã‚„è€ƒãˆãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚# é–“é•ã£ã¦ã„ã‚‹éƒ¨åˆ†ãŒã‚ã‚Œã°ã€æ•™ãˆã¦ã„ãŸã ã‘ã‚‹ã¨å¬‰ã—ã„ã§ã™ã€‚ ï¼ˆ2011/07/25 è¿½è¨˜ï¼‰è¤‡åˆä¸»ã‚ãƒ¼ã¨ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã«ã¤ã„ã¦ã¯ã€è¦ä»¶ã‚„ã‚·ã‚¹ãƒ†ãƒ ã«ä¾å˜ã—ã¦å¤šæ§˜ãªåˆ¤æ–ãŒã‚ã‚Šã†ã‚‹ã¨æ€ã„ã¾ã™ã€‚ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€ã€Œé¿ã‘ã‚‹ã¹ãã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã«ã—ãŸã®ã¯æ¥µç«¯ã§ã—ãŸã€‚ç”³ã—è¨³ã‚ã‚Šã¾ã›ã‚“ã€‚ã”æŒ‡æ‘˜ä¸‹ã•ã£ãŸçš†ã•ã‚“ã€ã‚ã‚Š
sgtakeru 2011/07/15
*programming

db
ãƒªãƒ³ã‚¯
DBã®ã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã€ãŒå¿…è¦ãªç†ç”±ã€€ ï¼ˆPostgreSQLã§ï¼Œãƒ•ã‚¡ãƒ³ãƒˆãƒ ãƒ»ãƒªãƒ¼ãƒ‰ã‚’é˜²æ¢ã™ã¹ãã‚µãƒ³ãƒ—ãƒ«äº‹ä¾‹ï¼‰ - ä¸»ã«è¨€èªžã¨ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«é–¢ã—ã¦
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ï¼Œã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã€ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚‹ã€‚ ä»¥ä¸‹ã§ã¯ï¼Œãã‚ŒãŒ ãªãœå¿…è¦ãªã®ã‹ï¼Ÿ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒ¬ãƒ™ãƒ«ã§ã¯ï¼Œã©ã†ã—ã¦é§„ç›®ãªã®ã‹ï¼Ÿ PostgreSQLã§ã¯ï¼Œã©ã†ã‚„ã£ã¦ãƒ¬ãƒ™ãƒ«ã‚’å¤‰æ›´ãƒ»ç¢ºèªã™ã‚‹ã®ã‹ï¼Ÿ ãªã©ã‚’å–ã‚Šä¸Šã’ã‚‹ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ« ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã¨ã¯ï¼š è¤‡æ•°ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒåŒæ™‚ã«å®Ÿè¡Œã•ã‚ŒãŸå ´åˆã«ã€ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®å½±éŸ¿ãŒã©ã®ãã‚‰ã„ã€Œåˆ†é›¢ã€ã™ã‚‹ã‹ï¼Œã®ãƒ¬ãƒ™ãƒ«ã€‚ ANSIè¦æ ¼ã§ã¯ï¼Œï¼”ã¤ã®ãƒ¬ãƒ™ãƒ«ãŒã‚ã‚‹ã€‚ READ UNCOMMITTED ï¼ˆä¸€ç•ªä½Žã„ï¼‰ READ COMMITTED REPEATABLE READ SERIALIZABLEï¼ˆä¸€ç•ªé«˜ã„ï¼‰ å¾¹åº•æ¯”è¼ƒ!! PostgreSQL vs MySQLã€€ç¬¬ï¼“å›žï¼šãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æ¯”è¼ƒ http://thinkit.co.jp/free/article/060... ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã«è©³ã—ã
sgtakeru 2011/01/05
åˆ†ã‹ã‚Šã‚„ã™ã„ã€‚

*programming

db

postgresql
ãƒªãƒ³ã‚¯
å¤–éƒ¨æŽ¥ç¶šã‚’è¨±å¯ã—ã¦ã¿ã‚‹ - æ‚²å–œäº¤ã€…ã€€-ã¸ãŸã‚Œã®æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´-
Linuxç‰ã«DBã‚½ãƒ•ãƒˆã‚’å°Žå…¥ã—ãŸã®ãªã‚‰ã€å¤–éƒ¨æŽ¥ç¶šã‚’å®¹èªã§ãã‚‹ã‚ˆã†ã«ã—ã¦ãŠã‹ãªã‘ã‚Œã°éžå¸¸ã«é¢å€’ã Oracleã§è¨€ãˆã°ã€ãƒªã‚¹ãƒŠãƒ¼ã®è¨å®šãŒã“ã®å®šç¾©ã«ã‚ãŸã‚‹ã€‚MySQLã§ã¯ãƒ¦ãƒ¼ã‚¶ãƒ¼ä½œæˆæ™‚ã«ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’åˆ©ç”¨ã§ãã‚‹ãƒ›ã‚¹ãƒˆã‚’æŒ‡å®šã§ãã‚‹(ã“ã®æ™‚ã«å®šç¾©ã—ãªã‘ã‚Œã°ãƒ›ã‚¹ãƒˆã‚’å•ã‚ãªã„å¤–éƒ¨æŽ¥ç¶šãŒå¯èƒ½) ã‚“ã˜ã‚ƒã€PostgreSQLã§ã¯ã©ã†ã„ã†é¢¨ã«è¨å®šã™ã‚Œã°è‰¯ã„ã®ã‹ æŽ¥ç¶šã®è¨å®šå®šç¾©ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªå†…ã®dataãƒ•ã‚¡ã‚¤ãƒ«ã«å˜åœ¨ã™ã‚‹ pg_hba.confã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ãŒãã‚Œ ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®å¤§ä½“63è¡Œç›®ã‹ã‚‰ãŒè¨å®šã‚’å®šç¾©ã—ã¦ã„ã‚‹ # TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 0.0.0.0/xx md5ã“ã‚“ãªè¨˜è¿°ãŒãªã•ã‚Œã¦ã„ã‚‹ 8.2ã®confã§ã¯IPã¨ãƒžã‚¹ã‚¯ãŒä¸€ã¤ã®åŒºåˆ†ã§å®šç¾©ã•ã‚Œã¦ã„ã‚‹ãŒã€ä»–
sgtakeru 2010/12/21
postgresqlã§å¤–éƒ¨ç«¯æœ«ã‹ã‚‰ã€DBã‚µãƒ¼ãƒã¸ã®ã‚¢ã‚¯ã‚»ã‚¹è¨±å¯

*software

postgresql

db
ãƒªãƒ³ã‚¯
ï¼»PostgreSQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬39å›ž PostgreSQL 8.4ã®æ–°æ©Ÿèƒ½ã€Œå†å¸°SQLã€ã¨æœ€æ–°æƒ…å ±
æ¥å¹´ã¯ã˜ã‚ã®ãƒªãƒªãƒ¼ã‚¹ã‚’ç›®æŒ‡ã—ã¦é–‹ç™ºä¸ã®PostgreSQL 8.4ã®å§¿ãŒè¦‹ãˆå§‹ã‚ã¦ããŸã€‚ä»Šå›žã¯8.4ã®æ–°æ©Ÿèƒ½ã®ç›®çŽ‰ã®ä¸€ã¤ã§ã‚ã‚‹ã€Œå†å¸°SQLã®ã‚µãƒãƒ¼ãƒˆã€ã‚’ä¸å¿ƒã«ãŠè©±ã—ã™ã‚‹ã€‚ é–‹ç™ºã«ã‚ãŸã£ã¦ã¯ï¼ŒPostgreSQLã®å¤§è¦æ¨¡åˆ©ç”¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚ã‚‹ä½å‹é›»å·¥æƒ…å ±æ ªå¼ä¼šç¤¾ãŒãƒªã‚½ãƒ¼ã‚¹ã‚’æä¾›ã—ï¼Œç†è€…ã®å‹¤å‹™ã™ã‚‹SRA OSSæ—¥æœ¬æ”¯ç¤¾ãŒPostgreSQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã¨ã®èª¿æ•´ãŠã‚ˆã³å®Ÿè£…ã‚’æ‹…å½“ã—ãŸã€‚æœ€çµ‚çš„ã«ã¯PostgreSQLã‚³ã‚¢ãƒ¡ãƒ³ãƒã‚‰ã®å”åŠ›ã§å®Ÿè£…ãŒãƒ–ãƒ©ãƒƒã‚·ãƒ¥ã‚¢ãƒƒãƒ—ã•ã‚Œï¼Œ8.4ã¸ã®å–ã‚Šè¾¼ã¿ãŒç¢ºå®šã—ãŸã€‚ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã«ãŠã‘ã‚‹å†å¸°å‡¦ç† å†å¸°å‡¦ç†ã¯Cã‚„Javaãªã©ã®é€šå¸¸ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã§ã¯æ™®é€šã«ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ãŠã‚Šï¼Œã†ã¾ãä½¿ã†ã¨åŠ¹çŽ‡ã®ã‚ˆã„ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ãã‚Œã„ã«æ›¸ãã“ã¨ãŒã§ãã‚‹ã€‚å†å¸°å‡¦ç†ã¯å†å¸°çš„ãªæ§‹é€ ã‚’æŒã¤ãƒ‡ãƒ¼ã‚¿ï¼Œä¾‹ãˆã°æœ¨æ§‹é€ ã‚„ãƒªã‚¹ãƒˆæ§‹é€ ã‚’å‡¦ç†ã™ã‚‹éš›ã«è‰¯ãä½¿ã‚ã‚Œã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹å†å¸°å‡¦ç† å†å¸°SQLã¨ã¯ï¼Œæ–‡å—
sgtakeru 2010/12/09
withå¥ã‚’ä½¿ãˆã‚‹ã®ã¯ã€8.4ã‹ã‚‰ã€‚

*programming

sql

postgresql

db
ãƒªãƒ³ã‚¯
How to update unique values in SQL using a PostgreSQL sequence?
sgtakeru 2010/12/07
*programming

sql

db

postgresql
ãƒªãƒ³ã‚¯
æ–‡å—åˆ—åž‹ã®ä½¿ã„åˆ†ã‘ â€” Let's Postgres
ã¾ãŸã€PostgreSQL ã«ã¯ã„ã‚ã‚†ã‚‹ CLOB, BLOB ã®ã‚ˆã†ãªå·¨å¤§ãƒ‡ãƒ¼ã‚¿å°‚ç”¨ã®åž‹ã¯å˜åœ¨ã›ãšã€1GB ã¾ã§ã§ã‚ã‚Œã° text ã‚„ bytea åž‹ã‚’ãã®ã¾ã¾ä½¿ãˆã¾ã™ã€‚1GB ã‚’è¶…ãˆã‚‹å ´åˆã¯ãƒ©ãƒ¼ã‚¸ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚‚åˆ©ç”¨ã§ãã¾ã™ãŒã€ã‚¢ã‚¯ã‚»ã‚¹ã‚„ç®¡ç†ã®æ–¹æ³•ã«ã‚¯ã‚»ãŒã‚ã‚‹ãŸã‚ãŠå¥¨ã‚ã§ãã¾ã›ã‚“ã€‚æ•°MBã¾ã§ã¯ text ã‚„ bytea ã‚’ä½¿ã„ã€ãã‚Œã‚’è¶…ãˆã‚‹ã‚ˆã†ãªã‚‰å¤–éƒ¨ãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦ä¿æŒã—ãŸã»ã†ãŒã€ã‚€ã—ã‚å®‰å¿ƒã—ã¦é‹ç”¨ã§ãã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ char ã¨ varchar, text ã®æ¯”è¼ƒ PostgreSQL ã®æ–‡å—åˆ—ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ 1. char(n) ã‚„ varchar(n) ã® 'n' ã¯ã€Œæ–‡å—æ•°ã€ã‚’è¡¨ã™ ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ãƒã‚¤ãƒˆæ•°ã‚’è¡¨ã™ã‚‚ã®ã‚‚ã‚ã‚‹ã®ã§æ³¨æ„ã—ã¾ã—ã‚‡ã†ã€‚ 2. char(n) ã¯ n æ–‡å—ã«ãªã‚‹ã‚ˆã†ã«æœ«å°¾ã«ç©ºç™½ã‚’è¿½åŠ ã—ã¦ä¿æŒã™ã‚‹ n æ–‡å—ã´ã£ãŸã‚Šã§ç„¡ã„é™ã‚Šã€æœ«å°¾ã®ç©ºç™½ã®
sgtakeru 2010/10/29
varcharã¨textã¯å†…éƒ¨ã§ã¯ãŠãªã˜å‹•ãã€‚charã€varcharã€textã®ä½¿ã„åˆ†ã‘ãŒã‚ã‹ã‚‹ã€‚

db

postgresql

*programming
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
sgtakeru 2010/10/21
DBã«é–¢ã™ã‚‹ã“ã¨ã«å¯¾ã™ã‚‹è†¨å¤§ãªè³‡æ–™ã€‚

*programming

db

sql
ãƒªãƒ³ã‚¯
SSDå°‚ç”¨ã«è¨è¨ˆã•ã‚ŒãŸã€ŒReThinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãªã„æ–°ã—ã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
SSDå°‚ç”¨ã«è¨è¨ˆã•ã‚ŒãŸã€ŒReThinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãªã„æ–°ã—ã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ SSDãŒHDDã«ä»£ã‚ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ã—ã¦æ™®åŠã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ã“ã¨ã‚’èƒŒæ™¯ã«ã€SSDã«ç‰¹åŒ–ã—ãŸã¾ã£ãŸãæ–°ã—ã„ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’å‚™ãˆãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é–‹ç™ºã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ä¼æ¥ãŒã‚ã‚Šã¾ã™ã€‚ã€ŒReThinkDBã€ã§ã™ã€‚ æ˜¨å¹´7æœˆã«ã€Publickeyã§ã¯ReThinkDBã®æ¦‚è¦ã‚’è¨˜äº‹ã€ŒSSDã«æœ€é©åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒRethinkDBã€ã€ãƒãƒƒã‚¯ã‚‚ãƒã‚°ã‚‚ä½¿ã‚ãšã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å®Ÿç¾ã€ã§ä¼ãˆã¾ã—ãŸã€‚ ãã®è¨˜äº‹ã®ä¸ã§ã¯ã€ReThinkDBãŒãƒãƒƒã‚¯ã‚’ä½¿ã‚ãšã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨ä¸ã§ã‚‚ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆãŒã¨ã‚Œã€ã¾ãŸç•°å¸¸çµ‚äº†ã—ã¦ã‚‚å®¹æ˜“ã«å¾©å¸°ã§ãã‚‹æ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã‚‹ã€ã¨ã„ã£ãŸã“ã¨ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ 4æœˆã«ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§ã«è¡Œã‚ã‚ŒãŸã€ŒMySQL Conference & Ex
sgtakeru 2010/05/11
å¸¸ã«æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ã‚’ä½œæˆã—ã¦ã€å¾Œã‚ã‹ã‚‰èªã¿ã ã™ã€‚å¤‰æ›´å±¥æ´ã‚’è¦‹ã‚‹ã¨ãã‚‚ã‚ã‹ã‚Šã‚„ã™ã„ï¼Ÿ

db

*software

*design
ãƒªãƒ³ã‚¯
NoSQL â€“ SQLã¯ã‚‚ã†å¤ã„?
Photo by shindotv ã“ã“æœ€è¿‘ã€æµ·å¤–ã®ãƒ–ãƒã‚°ã§ã€ŒNoSQLã€ã¨ã„ã†å˜èªžã‚’ã¡ã‚‡ã“ã¡ã‚‡ã“ã¨è¦‹ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ã“ã‚Œã¯æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ ãƒ¼ãƒ–ãƒ¡ãƒ³ãƒˆã§ã€ã€ŒSQL=ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ã€ã§ã¯ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®äº‹ã‚’æŒ‡ã—ã¦ã„ã¾ã™ã€‚ NoSQL DBã‚µãƒ¼ãƒã®æœ‰åãªç‰©ã¯ã€FacebookãŒãƒªãƒªãƒ¼ã‚¹ã—ãŸã€ŒCassandraã€ã€Erlangã§æ›¸ã‹ã‚ŒãŸã€ŒCouchDBã€ã€æ—¥æœ¬ã‹ã‚‰ã¯ã€mixiãŒãƒªãƒªãƒ¼ã‚¹ã—ã¦ã„ã‚‹ã€ŒTokyoTyrantã€ãŒã‚ã‚Šã¾ã™ã€‚ ã¾ãŸGoogle App Engineã§ã¯ã€DataStoreã¨ã„ã†BigTableãƒ™ãƒ¼ã‚¹ã®NoSQLã‚µãƒ¼ãƒ“ã‚¹ãŒæä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚ã‚‹ç¨‹åº¦ãƒ¦ãƒ¼ã‚¶ã‚’é›†ã‚ãŸã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã¯ã€å¤§æŠµã®å ´åˆãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã®æˆ¦ã„ã¨ãªã‚Šã¾ã™ã€‚ æŠ€è¡“èªŒã®ä¸ã§ã‚‚ã€Œã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆæŠ€æ³•ã€çš„ãªè¨˜äº‹ã‚’ç›®ã«ã™ã‚‹ã“ã¨ãŒå¢—ãˆã¦ããŸã“ã¨ã‹ã‚‰ã‚‚ã€å¤šãã®ã‚µã‚¤ãƒˆé‹å–¶è€…ãŒã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å•é¡Œã‚’æŠ±
sgtakeru 2009/11/11
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ°—ã«ã™ã‚‹åˆ†é‡Žã§ã¯ã€NoSQLã¸ã®ãƒ‘ãƒ©ãƒ€ã‚¤ãƒ ã‚·ãƒ•ãƒˆãŒå§‹ã¾ã£ã¦ã„ã‚‹ã€‚æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã«ãã‚‹ã«ã¯ã¾ã ã¾ã å…ˆã ã‚ã†ã€‚

db
ãƒªãƒ³ã‚¯
NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’40ç¨®é¡žä»¥ä¸Šãƒªã‚¹ãƒˆã‚¢ãƒƒãƒ—ã€ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ã«ã‚‚ã„ã‚ã„ã‚ã‚ã‚‹
Webã‚¹ã‚±ãƒ¼ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ãŸã‚ã«ã•ã¾ã–ã¾ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒç™»å ´ã—ã¦ãã¦ã„ã‚‹ã€ã¨ã„ã†ã“ã¨ã‚’æ˜¨æ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ç›®çš„åˆ¥ã«ä½¿ã„åˆ†ã‘ã‚‹ã¹ã—ã€ã§ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ç‰¹ã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ãªã„ã€éžSQLç³»ï¼ˆNoSQLï¼‰ã¨å‘¼ã°ã‚Œã‚‹ã•ã¾ã–ã¾ãªç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒç™»å ´ã—ã¦ãã¦ã„ã¾ã™ã€‚éžSQLç³»ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ä»¥å‰ã‹ã‚‰ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€éšŽå±¤åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãªã©ãŒå˜åœ¨ã—ã¦ã„ã¾ã—ãŸãŒã€æœ€è¿‘æ³¨ç›®ã•ã‚Œã¦ã„ã‚‹ã®ãŒã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¨å‘¼ã°ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚ ãƒ–ãƒã‚°ã€ŒHigh Scalabilityã€ã«ãƒã‚¹ãƒˆã•ã‚ŒãŸã‚¨ãƒ³ãƒˆãƒªã€ŒA Yes for a NoSQLÂ Taxonomyã€ã§ã¯ã€ã“ã‚Œã‚‰éžSQLç³»ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è©³ç´°ã«9åˆ†é¡žã—ã€ãã‚Œãžã‚Œã®åˆ†é¡žã«å±žã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒªã‚¹ãƒˆã‚¢ãƒƒãƒ—ã—ã¦ã„ã¾ã™ï¼ˆåŸºã«ãªã£ãŸã®ã¯ã€ŒNoSQL is aÂ Horseless Carriageã€
sgtakeru 2009/11/10
db
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» Introducing the Drizzle Project
ã“ã“ã—ã°ã‚‰ãã€æ°´é¢ä¸‹ã§Brian Akerã‚’ä»£è¡¨ã¨ã™ã‚‹MySQL/SUNã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŸã¡ã‚„ã€æ¥ç•Œã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒãƒƒã‚«ãƒ¼ãŸã¡ã¨MySQLã‚’ã‚¹ãƒªãƒ ãƒ€ã‚¦ãƒ³ã•ã›ãŸãƒžã‚¤ã‚¯ãƒã‚«ãƒ¼ãƒãƒ«RDBMSã‚’é–‹ç™ºã—ã¦ã„ãŸã®ã§ã™ãŒã€æœ¬æ—¥ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ã•ã‚ŒãŸã®ã§ã€æ—¥æœ¬èªžã§ã”ç´¹ä»‹ã•ã›ã¦ã„ãŸã ããŸã„ã¨æ€ã„ã¾ã™ã€‚ Drizzleã¨ã¯ï¼Ÿ Drizzleã¨ã¯å¿…è¦ã®ãªã„ã‚‚ã®ã¯ä¸€åˆ‡å˜åœ¨ã—ãªã„ã€æœ€ä½Žé™ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹é‡è¦–ãªã€ŒMySQLã‚ˆã‚Šã‚·ãƒ³ãƒ—ãƒ«ã§ã€è»½ãã€å®‰å®šã—ã¦ã€é«˜é€Ÿãªã€ MySQLã®forkã§ã™ã€‚ãƒžã‚¤ã‚¯ãƒã‚«ãƒ¼ãƒãƒ«ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŽ¡ç”¨ã—ãŸã®ã§ã€å¿…è¦ã®ãªã„ã‚‚ã®ã¯å¾Œä»˜ã‘ã§ãã‚‹æ§‹æˆã§ã™ã€‚ã“ã†ã„ã£ãŸç›®æ¨™ã‚‚ã‚ã‚Šã€ç¾åœ¨ã€Drizzleã®é–‹ç™ºãƒãƒ¼ãƒ ã¯MySQLã‚’ãƒ‰ãƒ©ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã«ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã—ã¦ã„ã¾ã™ã€‚ ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ Drizzleã§å¤§äº‹ãªäº‹ã¯ã€Drizzleã¯ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã‚ã‚‹ã¨ã„ã†äº‹ã§ã™ã€‚Montyã®ãƒ–
sgtakeru 2008/07/29
db

mixi

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

*programming

php

db
ãƒªãƒ³ã‚¯
YappoLogs: æ‚ªã®ã‚Šã§å¦ã¶svnadmin/tracå…¥é–€å®Ÿç”¨ç·¨
æ‚ªã®ã‚Šã§å¦ã¶svnadmin/tracå…¥é–€å®Ÿç”¨ç·¨ ã¨ã‚ã‚‹å¹³å’Œãªã‚ã‚‹é€±æœ«ã«äº‹ä»¶ã¯èµ·ã“ã£ãŸ xx:14 ([aopy]+) stfuawscæ±šæŸ“ãªã‚³ãƒ¼ãƒ‰ã‚’ciã£ã¦ã¾ã£ãŸ xx:14 (A) ã¡ã‚‡ xx:14 (B) ï½—ï½— xx:14 (C) ï½—ï½—ï½— xx:14 (D) stfuawsc xx:14 {[ainOS]+} ãƒ‘ãƒãƒ©ãƒ¼ãƒ‡ã‚£ã‚¹ã‚«ãƒƒã‚·ãƒ§ãƒ³ã¨ã„ã†äº‹ã§ã€ç›´è¿‘ã®ã‚³ãƒŸãƒƒãƒˆã—ãŸå†…å®¹ã‚’ã“ã®ä¸–ã‹ã‚‰æŠ¹æ¶ˆã—ãªã‘ã‚Œã°ãªã‚‰ãªããªã£ãŸã€‚ ã—ã‹ã‚‚tracä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚‚ã‚ã‚ã›ã¦..! æ¶ˆã—ãŸã„ãƒªãƒ“ã‚¸ãƒ§ãƒ³ã¯100ã§ã‚ã‚‹ã€‚ svnã®ãƒ‡ãƒ¼ã‚¿ã‚’æ¶ˆã™ã‚³ãƒžãƒ³ãƒ‰ã ã‘ã§ç›´å‰ã®ã‚³ãƒŸãƒƒãƒˆã‚’å–ã‚Šæ¶ˆã›ãªã„ã‚‚ã®ã‹ã¨èª¿ã¹ãŸãŒã€å‡ºæ¥ãªã„ã¨ã„ã†äº‹ãŒåˆ†ã‹ã£ãŸã€‚ ã¡ã‚‡ã£ã¨å†·é™ã«ãªã£ã¦ã€svnadmin dumpã¨svnadmin loadã®çµ„ã¿åˆã‚ã›ã§ä½•ã¨ã‹å‡ºæ¥ãªã„ã‹ï¼Ÿã¨è€ƒãˆ$ svnadmin dump /svn/public > /tmp/publ
sgtakeru 2008/07/10
ãã®ã¾ã¾ã‚³ãƒžãƒ³ãƒ‰ã‚’å‹•ã‹ã—ã¦ã‚‚ã ã‚ã€‚ãã¡ã‚“ã¨ç’°å¢ƒã«åˆã‚ã›ãªã„ã¨ã€‚ã‚ã‚‹ç¨‹åº¦ã®å‰æçŸ¥è˜ãŒå¿…è¦ã€‚

*tips

svn

trac

db
ãƒªãƒ³ã‚¯
ï¼ ITï¼šSQLã‚¯ãƒªãƒ‹ãƒƒã‚¯ï¼ˆ1ï¼‰ Page 1/2 Oracle10gæ£è¦è¡¨ç¾
æœ¬é€£è¼‰ã¯SQLã®å¿œç”¨åŠ›ã‚’èº«ã«ä»˜ã‘ãŸã„ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€ã•ã¾ã–ã¾ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã™ã‚‹ã€‚SQLã®åŸºæœ¬æ§‹æ–‡ã¯å¹³æ˜“ãªã‚‚ã®ã ãŒã€å®Ÿå‹™ã§æ´»ç”¨ã™ã‚‹ã«ã¯æ•™ç§‘æ›¸çš„ãªè¨˜è¿°ã‚’ç†è§£ã™ã‚‹ã ã‘ã§ã¯ä¸ååˆ†ã ã€‚æœ¬é€£è¼‰ã¯ã€è‘—åãªãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³ã€ŒãŠã‚‰ï¼ã‚ªãƒ©ï¼ Oracle - ã©ã£ã·ã‚Šæ¤œè¨¼ç”Ÿæ´»ã€ã‚’ç™ºè¡Œã™ã‚‹ã‚¤ãƒ³ã‚µã‚¤ãƒˆãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã®ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã‚’åŸ·ç†é™£ã«è¿Žãˆã€SQLã®ã‚»ãƒ³ã‚¹å‘ä¸Šã«å½¹ç«‹ã¤å¤§æŠ€å°æŠ€ã‚’ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ Oracle 10gã§æ£è¦è¡¨ç¾ã«ã‚ˆã‚‹æ–‡å—åˆ—æ“ä½œãŒå¯èƒ½ã«ï¼ Oracle Database 10g ã§æ–°è¦ã«è¿½åŠ ã•ã‚ŒãŸæ£è¦è¡¨ç¾æ©Ÿèƒ½ã¯ã€ãƒ†ã‚ã‚¹ãƒˆå½¢å¼ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ãŸã‚ã®å¼·åŠ›ãªãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ã“ã‚Œã«ã‚ˆã‚ŠSQLã‚’ä½¿ç”¨ã—ãŸæ–‡å—ãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ã—ã€æ“ä½œã™ã‚‹èƒ½åŠ›ãŒå¤§å¹…ã«å‘ä¸Šã—ã¾ã™ã€‚ UNIXãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã¯å¤§å¤‰ãªã˜ã¿ã®æ·±ã„æ£è¦è¡¨ç¾ã€‚Oracle 10gã§ï¼ˆã‚„ã£ã¨ï¼ï¼Ÿï¼‰å®Ÿç¾ã•ã‚Œã¾ã—ãŸã€‚ã„ã¾ã¾ã§ã¯WHEREå¥ã®ä¸ã§â€œLIKEâ€ã¨ã¨ã‚‚ã«ä½¿ç”¨ã™
sgtakeru 2008/07/08
10gã‹ã‚‰ã®æ–°æ©Ÿèƒ½

*programming

sql

db

oracle

regexp
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
sgtakeru 2008/07/08
development

db

apache

couchdb

mapreduce

erlang
ãƒªãƒ³ã‚¯
sqlite: SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ä¼šè©±ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ
sqlite: SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ (This page was last modified on 2003/06/29 16:11:13 UTC) SQLite ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ã¯ sqlite ã¨ã„ã†ã‚·ãƒ³ãƒ—ãƒ«ãªã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ãŒå«ã¾ã‚Œã¾ã™ã€‚ã“ã‚Œã‚’ä½¿ã†ã¨ã€ãƒ¦ãƒ¼ã‚¶ã¯æ‰‹ä½œæ¥ã§ SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ã¦ SQL ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚ã“ã®æ–‡æ›¸ã§ã¯ sqlite ã®ä½¿ã„æ–¹ã«é–¢ã™ã‚‹æ¦‚ç•¥ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ èµ·å‹•ã™ã‚‹ sqlite ã‚’èµ·å‹•ã™ã‚‹ã«ã¯å˜ã« "sqlite" ã¨ã‚¿ã‚¤ãƒ—ã—ã€ãã®å¾Œã‚ã« SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¿æŒã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«åã‚’ä»˜ã‘ã¾ã™ã€‚ãƒ•ã‚¡ã‚¤ãƒ«ãŒå˜åœ¨ ã—ãªã„å ´åˆã¯ã€è‡ªå‹•çš„ã«æ–°ã—ãä½œã‚‰ã‚Œã¾ã™ã€‚èµ·å‹•å¾Œ sqlite ãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã€SQL ã‚’ã‚¿ã‚¤ãƒ—ã™ã‚‹ãŸã‚ã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆï¼ˆçµ‚äº†ã¯ã‚»ãƒŸã‚³ãƒãƒ³ï¼‰ã‚’ã‚¿ã‚¤ãƒ—ã—ã€ "E
sgtakeru 2008/06/19
ä½¿ã„æ–¹ã€‚

*programming

db

sqlite
ãƒªãƒ³ã‚¯
http://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/friends_timeline.php
sgtakeru 2008/06/10
*programming

db

algorithm

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