[B! DB,SQL] tyruã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tyru id:tyru

DB,SQLã«é–¢ã™ã‚‹tyruã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (16)

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

JSONã§å…¥å‡ºåŠ›å¯èƒ½ãªNoSQLã€ŒCouchbaseã€ãŒæœ€åˆã®è£½å“ã‚’ãƒªãƒªãƒ¼ã‚¹
JSONå½¢å¼ã§å…¥å‡ºåŠ›å¯èƒ½ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã€ŒCouchOneã€ã¨ã€Memcachedäº’æ›ã®ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ã€ŒMembaseã€ã€ãã‚Œãžã‚Œã®é–‹ç™ºä¼æ¥ãŒå…ˆæœˆåˆä½µã—ãŸã€ŒCouchbaseã€ã‹ã‚‰ã€æœ€åˆã®è£½å“ã€ŒCouchbase Serverã€ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚Linuxç‰ˆã€Windowsç‰ˆã€MacOSç‰ˆãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ ç„¡å„Ÿã®Community Editionã¨åŒæ™‚ã«ã€24æ™‚é–“365æ—¥ã®ã‚µãƒãƒ¼ãƒˆãŒã‚ã‚‹Enterprise Editionã‚‚ãƒªãƒªãƒ¼ã‚¹ã€‚ä¸¡è€…ã®æ©Ÿèƒ½ã«é•ã„ã¯ãªã„ã¨ã®ã“ã¨ã€‚ åˆä½µå¾Œ1ã‚«æœˆã§çµ±åˆè£½å“ã‚’ãƒªãƒªãƒ¼ã‚¹ Couchbaseã¯ã€JSONã§å…¥å‡ºåŠ›å¯èƒ½ã§ã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆãŒä¸è¦ãªã€æŸ”è»Ÿæ€§ãŒé«˜ãä½¿ã„ã‚„ã™ã„ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰éƒ¨åˆ†ã¨ã€Memcachedã¨äº’æ›æ€§ã®ã‚ã‚‹é«˜é€Ÿãªãƒ¡ãƒ¢ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥æ©Ÿèƒ½ã‚’å‚™ãˆã€è‡ªå‹•ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã¨ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã«ã‚ˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’å‚™ãˆãŸãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‹ã‚‰æ§‹æˆ
tyru 2011/03/17
json

NoSQL

DB,SQL

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: viã®ä¸ã§SQLã‚’å®Ÿè¡Œã™ã‚‹
ã“ã‚“ã«ã¡ã¯ï¼Œttsuruoka ã§ã™ï¼Ž vi ã®ä¸ã§ SQL ã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ãŒã§ãã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ï¼Œ dbext.vimã‚’ç´¹ä»‹ã—ã¾ã™ï¼Ž æ©Ÿèƒ½(ä¸€éƒ¨) - ex ã‚³ãƒžãƒ³ãƒ‰ã§ SQL æ–‡ã‚’å…¥åŠ›ã—ã¦ï¼Œãã®çµæžœã‚’å–å¾— :Select user_id from users order by rand() limit 7 Result ãƒãƒƒãƒ•ã‚¡ã«çµæžœãŒè¡¨ç¤ºã•ã‚Œã¾ã™ - é¸æŠžã—ãŸãƒ†ã‚ã‚¹ãƒˆéƒ¨åˆ†ã®SQLã‚’å®Ÿè¡Œ // ãƒ—ãƒã‚°ãƒ©ãƒ ä¸ã®SQL $query = "SELECT * FROM users LIMIT 10"; // å¤‰æ•°ãŒå«ã¾ã‚Œã¦ã„ã‚‹å ´åˆ $query = "SELECT * FROM users LIMIT $n"; // ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ãƒ¼ãŒå«ã¾ã‚Œã¦ã„ã‚‹å ´åˆ $query = "SELECT * FROM users LIMIT ?"; php ç‰ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ SQL ã‚’
tyru 2011/03/04
DB,SQL

vim

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
Rubyã‹ã‚‰Gitã‚’ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¨ã—ã¦ä½¿ã†Â·Git Store MOONGIFT
ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã‚µã‚¤ãƒˆãªã©ã§ã¯ãƒ¦ãƒ¼ã‚¶ãŒè‡ªç”±ã«ãƒ†ã‚ã‚¹ãƒˆã‚’å¤‰æ›´ã§ãã‚‹æ©Ÿèƒ½ãŒã‚ã‚‹ã€‚è‡ªåˆ†ã®ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ«ã‚’æ›´æ–°ã—ãŸã‚Šã€Wikiã®ã‚ˆã†ã«ã‚³ãƒ©ãƒœãƒ¬ãƒ¼ãƒˆã™ã‚‹ã‚ˆã†ãªã‚‚ã®ã ã€‚ãã®éš›ã€é‡è¦ã«ãªã‚‹ã®ãŒå±¥æ´ç®¡ç†æ©Ÿèƒ½ã ã€‚ãƒ¦ãƒ¼ã‚¶ã®é–“é•ã£ãŸä¿®æ£ãªã©ã‚’å…ƒã«æˆ»ã—ãŸã‚Šã€æ‚ªæ„ã‚ã‚‹æ›´æ–°ã‹ã‚‰ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’ä¿è·ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ Gitã‚’ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã«ä½¿ã†ã¨ã„ã†æ–¹æ³•ï¼ æ›´æ–°å‰ã«ç¾åœ¨ã®ãƒ†ã‚ã‚¹ãƒˆã‚’å…¨ã¦ä¿å˜ã—ã¦ã—ã¾ã†ã®ã‚‚æ‰‹ã ãŒã€ã“ã“ã§ã¯Gitã‚’ä½¿ã†ã¨ã„ã†æ‰‹æ³•ã‚’ã”ç´¹ä»‹ã—ãŸã„ã€‚ä½¿ã„æ–¹ã‚‚ç°¡å˜ã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Git Storeã€Gitã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã ã€‚ Git Storeã¯ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã¨ã„ã†ã“ã¨ã‚‚ã‚ã£ã¦ã€ã‚ãƒ¼ã¨å€¤ã®ä»•çµ„ã¿ã‚’ã¨ã£ã¦ã„ã‚‹ã€‚ã‚ãƒ¼ã‚’æŒ‡å®šã—ã¦å€¤ã‚’å…¥ã‚Œã€ã‚³ãƒŸãƒƒãƒˆã‚’è¡Œãˆã°ãã®ãƒ‡ãƒ¼ã‚¿ãŒé©ç”¨ã•ã‚Œã‚‹ã€‚memcachedã®ã‚ˆã†ãªã‚·ãƒ³ãƒ—ãƒ«ã•ã§ã€ãã‚Œã§ã„ã¦å±¥æ´ç®¡ç†ã¾ã§ã•ã‚Œã‚‹ã®ãŒç´ æ™´ã‚‰ã—ã„ã€‚ãªãŠã€ãã®ãƒã‚°ã‚„å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³
tyru 2011/02/21
ruby

git

DB,SQL

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
Firefox Bookmarks dump/restore script.
tyru 2011/01/25
ã€ŒFirefox Bookmarks dump/restore scriptã€ã¾ããƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—/å¾©å…ƒã¨ã‹firefoxã‹ã‚‰ã§ãã‚‹ã‘ã©ãªã‚“ã¨ãªãDBIã®ã‚³ãƒ¼ãƒ‰ã¨ã—ã¦ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ãŠã“ã†

firefox

perl

DB,SQL

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
Leo's Chronicle: ãœã²æŠ¼ã•ãˆã¦ãŠããŸã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ•™ç§‘æ›¸
å…ˆæ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã§å°‘ã—è©±ã—ãŸã®ã§ã™ãŒã€åƒ•ãŒåœ¨å¦ã—ã¦ã„ãŸã¨ãã®æ±å¤§ã«ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã¶ãŸã‚ã®ã‚³ãƒ¼ã‚¹ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸï¼ˆDBé–¢ä¿‚ã®æŽˆæ¥ã¯å¹´ã«ï¼‘ã¤ã‹ï¼’ã¤ã‚ã‚‹ç¨‹åº¦ã€‚ç¾åœ¨ã¯ã©ã†ãªã‚“ã ã‚ã†ï¼Ÿï¼‰ã€‚ãã‚“ãªã¨ãã«å½¹ã ã£ãŸã®ã¯ã€ã‚„ã¯ã‚Šæ•™ç§‘æ›¸ã€‚èªã¿ã‚„ã™ã„ã‚‚ã®ã‹ã‚‰é †ã«ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ï¼ˆã¨ã¯ã„ã£ã¦ã‚‚ã™ã¹ã¦è‹±èªžã®æœ¬ã§ã™ã€‚ã‚ã—ã‹ã‚‰ãšï¼‰ ä¸€ç•ªã®ãŠè–¦ã‚ã¯ã€Raghu Ramakrishnanå…ˆç”Ÿ (ç¾åœ¨ã¯ã€Yahoo! Research) ã®ã€ŒDatabase Management Systems (3rd Edition)ã€ã€‚åˆå¦è€…ã‹ã‚‰ç ”ç©¶è€…ã¾ã§å¹…åºƒãä½¿ãˆã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã®åŸºæœ¬æ¦‚å¿µã‹ã‚‰ã€å•ã„åˆã‚ã›æœ€é©åŒ–ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç†ãªã©ã€ã“ã‚Œã‚‰ã‚’å®Ÿè£…ãƒ»è©•ä¾¡ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã€ã€ŒDBã®ä¸–ç•Œã§ã®å¸¸è˜ã€ãŒã€ä¸å¯§ãªèªžã‚Šå£ã§ãµã‚“ã ã‚“ã«ç››ã‚Šè¾¼ã¾ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®1å†Šã‚’èªã‚“ã§ãŠã‘ã°ã€DBã®ä¸–ç•Œã§è°è«–ã™ã‚‹ãŸã‚ã®
tyru 2011/01/20
DB,SQL

book

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
ç¬¬3å›žã€€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚«ãƒãƒªâ€•ã€Œã‚‚ã—ã‚‚ã€ã«å‚™ãˆã€è»¢ã‚“ã§ã‚‚æ³£ã‹ãªã„åã«ãªã‚‹ï¼ˆ1ï¼‰ | gihyo.jp
ã¯ã˜ã‚ã« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ã€é‡è¦ãªãƒ‡ãƒ¼ã‚¿ãŒå¤šãä¿å˜ã•ã‚Œã¦ã„ã¾ã™ã€‚ä¼æ¥ã®è²¡å‹™çŠ¶æ³ã‹ã‚‰ã€ç§ãŸã¡å€‹äººã®ãƒ—ãƒ©ã‚¤ãƒã‚·ãƒ¼ã«é–¢ã‚ã‚‹ã‚‚ã®ã¾ã§ã€è¿‘å¹´ã§ã¯ã»ã¨ã‚“ã©ã‚ã‚Šã¨ã‚ã‚‰ã‚†ã‚‹ãƒ‡ãƒ¼ã‚¿ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã•ã‚Œã¦ã„ã¾ã™ã€‚ã‚‚ã—ã€ãã®ãƒ‡ãƒ¼ã‚¿ãŒä½•ã‹ã®é–“é•ã„ã§æ¶ˆå¤±ã—ã¦ã—ã¾ã£ãŸã‚‰ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã—ã¦ã„ãŸä¼æ¥ã‚„ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã‚’è«‹ã‘è² ã£ãŸä¼æ¥ã®å—ã‘ã‚‹ãƒ€ãƒ¡ãƒ¼ã‚¸ã¯è¨ˆã‚Šã—ã‚Œã¾ã›ã‚“ã€‚ ã—ã‹ã—ç¾å®Ÿã«ã¯ã€ãƒ‡ãƒ¼ã‚¿æ¶ˆå¤±ã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ã¯å®šæœŸçš„ã¨æ€ãˆã‚‹ãã‚‰ã„ç¹°ã‚Šè¿”ã—å ±ã˜ã‚‰ã‚Œã¾ã™ã€‚æœ€è¿‘ã§ã¯ã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã®Evernoteã§ãƒ‡ãƒ¼ã‚¿ãŒæ¶ˆãˆã€é¡§å®¢6,323äººã«å½±éŸ¿ã‚’ä¸ŽãˆãŸå¯èƒ½æ€§ãŒã‚ã‚‹ã¨å ±ã˜ã‚‰ã‚ŒãŸè©±ã¯è¨˜æ†¶ã«æ–°ã—ã„ã§ã™ã—ã€æ˜¨å¹´ã«ã¯Microsoftå‚˜ä¸‹ã®æºå¸¯é›»è©±å‘ã‘ã‚µãƒ¼ãƒ“ã‚¹Dangerã§ã‚‚ãƒ¦ãƒ¼ã‚¶ãƒ‡ãƒ¼ã‚¿ãŒæ¶ˆå¤±ã™ã‚‹äº‹ä»¶ãŒèµ·ãã¾ã—ãŸã€‚ ã“ã†ã—ãŸéšœå®³ãŒç™ºç”Ÿã™ã‚‹åŽŸå› ã¯ã€å¤§ããåˆ†ã‘ã¦2ã¤ã‚ã‚Šã¾ã™ã€‚1ã¤ç›®ã¯è«–ç†éšœå®³ã¨å‘¼ã°ã‚Œã‚‹ã‚‚ã®ã§ã€ãã‚‚ãã‚‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒã‚¸ãƒƒã‚¯ã«æ¬ é™¥ãŒã‚ã£ã¦ã€
tyru 2011/01/20
backup

DB,SQL

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
ç¬¬5å›žã€€SQLã§æœ¨æ§‹é€ ã‚’æ‰±ã†ï½žå…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«ã€€ï¼ˆ1ï¼‰å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«ã¨ã¯ä½•ã‹ | gihyo.jp
ã¯ã˜ã‚ã« æœ¨æ§‹é€ ã¨å‘¼ã°ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã®ä¸€ç¨®ãŒã‚ã‚Šã¾ã™ã€‚1ã¤ã®ãƒ«ãƒ¼ãƒˆï¼ˆæ ¹ï¼‰ã¨å‘¼ã°ã‚Œã‚‹ãƒŽãƒ¼ãƒ‰ã‚’å§‹ç‚¹ã¨ã—ã¦ã€ï¼ˆâ é€šå¸¸ï¼‰è¤‡æ•°ã®ãƒªãƒ¼ãƒ•ï¼ˆè‘‰ï¼‰ã¨å‘¼ã°ã‚Œã‚‹ãƒŽãƒ¼ãƒ‰ã¾ã§ã‚’çµŒè·¯ã§çµã‚“ã§ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã§ã™ã€‚ãã®åã®ã¨ãŠã‚Šè‡ªç„¶ç•Œã«ã‚ã‚‹ã€Œæœ¨ã€ã®æ§‹é€ ã§ã™ã—ã€å¦æ ¡æ™‚ä»£ã€ç¢ºçŽ‡ã®æŽˆæ¥ã§æ¨¹çŠ¶å›³ã‚’æ›¸ã„ãŸçµŒé¨“ã®ã‚ã‚‹äººã‚‚ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ ã“ã®æ§‹é€ ã¯ã€ç§ãŸã¡ã®å‘¨å›²ã«ã¨ã¦ã‚‚ãŸãã•ã‚“å˜åœ¨ã—ã¾ã™ã€‚å®¶ç³»å›³ã‚„çµ„ç¹”å›³ã‚‚æœ¨ã§ã™ã—ã€ITé–¢é€£ã®ä¾‹ã§ã¯ã€ãƒ’ãƒ¼ãƒ—ã‚„RDBã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªï¼ˆãƒ•ã‚©ãƒ«ãƒ€ï¼‰ã«ã‚ˆã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã‚„XMLã‚‚æœ¨æ§‹é€ ã§ã™ã€‚Webã®æŽ²ç¤ºæ¿ã§ã‚‚ã€æœ€åˆã®æ›¸ãè¾¼ã¿ã‚’ãƒ«ãƒ¼ãƒˆã¨ã—ã¦ãã‚Œã«å¯¾ã—ã¦ã‚³ãƒ¡ãƒ³ãƒˆãŒã¤ã‘ã‚‰ã‚Œã€ãã®ã‚³ãƒ¡ãƒ³ãƒˆã«ã¾ãŸã‚³ãƒ¡ãƒ³ãƒˆãŒã¤ã‘ã‚‰ã‚Œã‚‹ã¨ã„ã†ãƒ—ãƒã‚»ã‚¹ã§æœ¨æ§‹é€ ã‚’å½¢æˆã—ã¾ã™ã€‚ã“ã“ã§ã¯1ã¤ã®æ›¸ãè¾¼ã¿ãŒãƒŽãƒ¼ãƒ‰ã«ãªã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ã«ã€IT æŠ€è¡“ã¨æœ¨æ§‹é€ ã¯åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„é–¢ä¿‚ã«ã‚ã‚Šã¾ã™ã—ã€å¤šãã®åˆ†é‡Žã§å¿œç”¨ã•ã‚Œã¦ã‚‚ã„ã‚‹ã®ã§ã™ãŒã€å®Ÿã¯é•·ã„
tyru 2011/01/20
å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«

DB,SQL

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
é…åˆ—ã‹ã‚‰åŠ¹çŽ‡è‰¯ããƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½œã‚‹ : ã«ã½ãŸã‚“ç ”ç©¶æ‰€
my @a = qw(foo bar baz); ã“ã‚“ãªé…åˆ—ã‹ã‚‰ ?,?,? ã¨ã„ã†æ–‡å—åˆ—ã‚’ä½¿ã„ãŸã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ä¾‹ãˆã°ã€ SELECT * FROM hoge WHERE user_id IN (?,?,?); ã¿ãŸã„ãª SQL ã«ã™ã‚‹å ´åˆã®ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½œã‚‹ã¨è¨€ã£ãŸå…·åˆã«ã€‚ ç¤¾å†… IRC ã§ã€clouder ã•ã‚“ãŒè¨€ã„å‡ºã—ã¦ã€ 18:27 <clouder>join(',', map('?', @a)) 18:27 <clouder> ã“ã‚“ãªã®ã—ã‹æ€ã„ã¤ã‹ãªã„ã€‚ã€‚ ã¨è¨€ã†ã€‚ ã¾ãã€ãã‚ŒãŒå¦¥å½“ã¨ã„ã†ã‹ã€æ™®é€šãã‚ŒãŒæ€ã„æµ®ã‹ã¶ã‚ˆãªãƒ¼ã£ã¦æ€ã£ã¦ãŸã‚‰ã€ä¼šç¤¾ã® dos ã•ã‚“ã¨ã„ã†äººãŒ 19:15 <dos> '?,' x @a; ã§ s/,$//; ã¨ã„ã†ï½¿ï¾˜ï½ï½°ï½¼ï½®ï¾ ã¨ã‹ã€ç•°æ§˜ãªã“ã¨ã‚’è¨€ã„å‡ºã—ãŸã€‚ sub placeholder_from_array { return join(',',
tyru 2010/11/14
perl

DB,SQL

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³groongaã‚’ãƒ†ã‚¹ãƒˆãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ - ã‚°ãƒ‹ãƒ£ãƒ©ãã‚“ã®ã‚°ãƒ‹ãƒ£ã‚°ãƒ‹ãƒ£å‚™å¿˜éŒ²@ã¯ã¦ãª
å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã®groongaã‚’ãƒ†ã‚¹ãƒˆãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ groonga æœ¬æ—¥é–‹å‚¬ã•ã‚ŒãŸã€key-value storeå‹‰å¼·ä¼šã§ç™ºè¡¨ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ä»Šã¾ã§ã€Sennaã«ã¯ TritonnçµŒç”±ã§ä½¿ã£ãŸå ´åˆã€MySQLå´ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã®ä½µç”¨ãŒé›£ã—ãã€Sennaæœ¬æ¥ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒç™ºæ®ã§ããªã‹ã£ãŸã€‚ å¾“æ¥ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã§ã¯ã€ãƒˆãƒ¼ã‚¯ãƒŠã‚¤ã‚¶ã®åˆ‡ã‚Šæ›¿ãˆãªã©ã®æŸ”è»Ÿæ€§ãŒãªã‹ã£ãŸã€‚ ã¨ã„ã£ãŸå•é¡ŒãŒã‚ã‚Šã¾ã—ãŸã€‚ groongaã¯ã€ãã‚Œã«å¯¾ã™ã‚‹è¿”ç”ã§ã™ã€‚ è‡ªåˆ†ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ›¸ã‘ã°ã„ã„ã‚“ã˜ã‚ƒãï¼Ÿ æŸ”è»ŸãªAPIç”¨æ„ã™ã‚Œã°ã„ã„ã‚“ã˜ã‚ƒãï¼Ÿ ã£ã¦ã“ã¨ã§ã™ãã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€key-valueã‚¹ãƒˆã‚¢ã‚’çµ„ã¿åˆã‚ã›ãŸcolumnã‚¹ãƒˆã‚¢çš„ãªæ„Ÿã˜ã«ãªã£ã¦ã„ã¾ã™ã€‚ è©³ç´°ã«ã¤ã„ã¦ã¯ã€ä»Šå¾Œåˆ¥ã‚¨ãƒ³ãƒˆãƒªã‚„ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§è¿°ã¹ã¾ã™ã€‚ ä»Šå¾Œã¯ã€Sennaã¯ãƒã‚°ä¿®æ£ã®ã¿è¡Œã†ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãƒ¢ãƒ¼ãƒ‰ã«ç§»è¡Œã—ã¾ã™ã€‚ å®Ÿéš›ä½¿ã£ã¦ã¿ã‚ˆã† ä»Šå›ž
tyru 2010/11/05
groonga

DB,SQL
ãƒªãƒ³ã‚¯
NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
tyru 2010/10/27
NoSQL

mysql

DB,SQL

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
Vimã‹ã‚‰ä»»æ„ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œ - mfumiã®æ—¥è¨˜
ãµã¨SQLã‚’å‹‰å¼·ã—ã‚ˆã†ã¨æ€ã£ãŸã‚“ã§ã™ãŒã€ã¡ã¾ã¡ã¾ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰å…¥åŠ›ã™ã‚‹ã®ã¯ãã¤ã„ã®ã§ã€Vimã‹ã‚‰æ“ä½œã§ããªã„ã®ã‹ãªãƒ¼ã¨ã‹å¦„æƒ³ã—ã¦ãŸã‚‰æ™®é€šã«ã‚ã‚Šã¾ã—ãŸã€‚ dbext.vim - Provides database access to many DBMS (Oracle, Sybase, Microsoft, MySQL, DBI,..) : vim online ä½¿ã„æ–¹ åˆæœŸè¨å®š ã¾ãšã¯ã˜ã‚ã«ä½¿ç”¨ã™ã‚‹SQLç‰ã®è¨å®šã‚’ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ :DBPromptForBufferParameters ã‹ã€<Leader>sbp(æ™®é€š<Leader>ã¯\)ã‚’ã™ã‚‹ã¨å¯¾è©±å½¢å¼ã§è¨å®šãŒã§ãã¾ã™ã€‚ä»¥ä¸‹ã®é …ç›®ãªã©ã‚’è¨å®šã—ã¾ã™ã€‚ ãƒ»ä½¿ç”¨ã™ã‚‹SQLã®ç¨®é¡ž(MySQLã¨ã‹SQLiteã¨ã‹) ãƒ»ãƒ¦ãƒ¼ã‚¶ãƒ¼å ãƒ»ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ ãƒ»ã‚µãƒ¼ãƒãƒ¼ã®ãƒ›ã‚¹ãƒˆå ãƒ»ä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å ä»–ã«ã‚‚ã‚‚ã£ã¨ã„ã‚ã„ã‚ã¨è¨å®šã§ãã‚‹
tyru 2010/10/26
vim

DB,SQL

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
ã‚¯ãƒ©ãƒƒã‚ãƒ³ã‚°ãƒžãƒž
Randall Munroe
tyru 2010/10/19
security

neta

DB,SQL

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
MySQLã®VARCHARã‚µã‚¤ã‚ºã«ã¤ã„ã¦
æ£ç¢ºãªæœ€å¤§é•·ãŒã‚ã‹ã‚‰ãªã„ã¨ãã®æœ€å°ã‹ã¤ååˆ†ãªã‚µã‚¤ã‚ºã®å€¤ã£ã¦ã©ã†æ±ºã‚ã‚‹ã®ãŒè‰¯ã„ã®ã ã‚ã†ãƒ¼ã¨æ€ã£ã¦ã¤ã¶ã‚„ã„ã¦ã¿ãŸã¨ã“ã‚ã€å¤šãã®æ–¹ã€…ã«è¿”ä¿¡ã„ãŸã ã‘ã¾ã—ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚
tyru 2010/09/28
DB,SQL

mysql

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
NoSQLã®æˆåŠŸã¯1:10å•é¡Œã«ã‹ã‹ã£ã¦ã„ã‚‹:Kenn's Clairvoyance
ã“ã“2-3å¹´ã»ã©ã€ã„ã‚ã‚†ã‚‹éžSQLç³»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒãƒ›ãƒƒãƒˆãªè©±é¡Œã«ãªã£ã¦ãã¦ã„ã¾ã™ã€‚ã“ã®ãƒ ãƒ¼ãƒ–ãƒ¡ãƒ³ãƒˆã‚’ç·ç§°ã—ã¦ã€ŒNoSQL (Not-only SQL)ã€ã¨å‘¼ã°ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã‚ˆã†ã§ã™ã€‚ã¾ã‚‹ã§SQLã‚’å¦å®šã—ã¦ã„ã‚‹ã‹ã®ã‚ˆã†ãªèª¤è§£ã‚’æ‹›ãã‚„ã™ã„ç”¨èªžã§ã™ãŒã€ã‹ã¨ã„ã£ã¦ã‚ãƒ¼ãƒ»ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚„åˆ—æŒ‡å‘DBã‚’ç·ç§°ã§ãã‚‹ä»–ã®å‘¼ã³æ–¹ã‚‚ãªã„ã®ã§ã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯NoSQLã¨ã„ã†ç”¨èªžã‚’ä½¿ã†ã“ã¨ã«ã—ã¾ã™ã€‚ Oracleã‚„MySQLãªã©ã®SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒæˆç†Ÿã—ã¦ã„ãä¸€æ–¹ã§ã€SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç‰¹å¾´ã¥ã‘ã‚‹å¼±ç‚¹ã§ã‚ã‚‹æŸ”è»Ÿæ€§ã®ãªã•ã€å …ç‰¢ã•ã¨å¼•ãæ›ãˆã«çŠ ç‰²ã«ãªã£ãŸæ›´æ–°æ€§èƒ½ã®ä½Žã•ã€ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®é›£ã—ã•ãªã©ã‹ã‚‰ã€ã€Œä½•ã§ã‚‚ã‹ã‚“ã§ã‚‚RDBã€ã‹ã‚‰ã€Œç›®çš„ã«å¿œã˜ãŸæ°¸ç¶šåŒ–ã€ãŒæ¨¡ç´¢ã•ã‚Œã‚‹æµã‚Œã«ãªã£ã¦ãã¾ã—ãŸã€‚ æ™‚ã‚’åŒã˜ãã—ã¦ã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã®ä¸–ç•Œã§ã‚‚ã€Memcachedã®ã‚‚ã¤ã‚·ãƒ³ãƒ—ãƒ«ãªAPIã®ä½¿ã„ã‚„ã™ã•ãŒè©•ä¾¡ã•ã‚Œã‚‹ä¸€æ–¹ã€LRUã«ã‚ˆ
tyru 2010/09/23
NoSQL

DB,SQL

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¦ã¶ (1) - åˆºèº«â˜†ãƒ–ãƒ¼ãƒ¡ãƒ©ãƒ³ã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼
å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQL ç¬¬2ç‰ˆã¨Linux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰é‹ç”¨å…¥é–€ã‚’èªã‚“ã§ã€ MySQL ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦å‹‰å¼·ã—ãªãŠã—ã¦ã„ã‚‹ã€‚ç†è§£ãŒæ›–æ˜§ã ã£ãŸéƒ¨åˆ†ã®çŸ¥è˜ã‚’æ·±ã‚ã‚‰ã‚ŒãŸã‚Šã€è‡ªåˆ†ã®é–“é•ã„ã«æ°—ã¥ã‘ãŸã‚Šã—ã¦ã€ã¨ã¦ã‚‚åŽç©«ãŒå¤šã„ã€‚ ãƒ•ãƒ«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã¨ãƒ•ãƒ«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚¹ã‚ãƒ£ãƒ³ Linux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰é‹ç”¨å…¥é–€ P185 ã«æ›¸ã„ã¦ã‚ã‚‹ã‚±ãƒ¼ã‚¹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’åˆ©ç”¨ã—ã¦ã¦ã‚‚å¯¾è±¡ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒå¤šã„ã¨ãƒ©ãƒ³ãƒ€ãƒ I/OãŒå¤§é‡ã«ç™ºç”Ÿã—ã¦é…ããªã‚‹ã€‚èªã‚€ã¹ããƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒå¤šã„ã®ãªã‚‰ã°ãƒ•ãƒ«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã®ã»ã†ãŒI/Oä¸€å›žã§å¤šãã®ãƒ–ãƒãƒƒã‚¯ã‚’èªã¿è¾¼ã‚ã‚‹ã®ã§é€Ÿã„ã€‚ IGNORE INDEX ãƒ’ãƒ³ãƒˆã‚’ä¸Žãˆã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ã¨ã„ã†ä¾‹ãŒã‚ã£ãŸã€‚ ãƒžãƒ«ãƒã‚«ãƒ©ãƒ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ç¯„å›²æ¤œç´¢ SELECT * FROM users WHERE a = ? AND b >= ? and (c IS NULL OR c >=
tyru 2010/09/22
DB,SQL

mysql

!share-with

!tumblr-tech
ãƒªãƒ³ã‚¯
1