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

Kanasansoft id:Kanasansoft

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

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

SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã‚‚ã‚Œã®è²¬ä»»ã‚’é–‹ç™ºä¼šç¤¾ã«å•ã†åˆ¤æ±º
ãƒã‚¤ãƒ³ãƒˆã¯ä¸‹è¨˜ã®é€šã‚Šã§ã™ã€‚ Xç¤¾ï¼ˆåŽŸå‘Šï¼‰ã¯ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–ã«ã¤ã„ã¦ç‰¹ã«æŒ‡ç¤ºã¯ã—ã¦ã„ãªã‹ã£ãŸ æå®³è³ å„Ÿã«ã¤ã„ã¦å€‹åˆ¥å¥‘ç´„ã«å®šã‚ã‚‹å¥‘ç´„é‡‘é¡ã®ç¯„å›²å†…ã¨ã™ã‚‹æå®³è³ å„Ÿè²¬ä»»åˆ¶é™ãŒã‚ã£ãŸ å½“åˆã‚·ã‚¹ãƒ†ãƒ ã¯ã‚«ãƒ¼ãƒ‰æ±ºæ¸ˆã‚’å¤–éƒ¨å§”è¨—ã—ç›´æŽ¥ã‚«ãƒ¼ãƒ‰æƒ…å ±ã‚’æ‰±ã£ã¦ã„ãªã‹ã£ãŸ Xç¤¾ãŒã€Œã‚«ãƒ¼ãƒ‰ä¼šç¤¾æ¯Žã®æ±ºæ¸ˆé‡‘é¡ã‚’çŸ¥ã‚ŠãŸã„ã€ã¨Yç¤¾ã«ä¾é ¼ã‚’ã—ã¦ã€ãã®çµæžœã‚«ãƒ¼ãƒ‰æƒ…å ±ã‚’ã„ã£ãŸã‚“DBã«ä¿å˜ã™ã‚‹ä»•æ§˜ã¨ãªã£ãŸï¼ˆ2010å¹´1æœˆ29æ—¥ï¼‰ Xç¤¾ã‹ã‚‰ã®å•ã„åˆã‚ã›ã«å¯¾ã—ã¦Yç¤¾ã¯ã€ã‚«ãƒ¼ãƒ‰æƒ…å ±ã‚’ä¿æŒã—ãªã„æ–¹å¼ã«å¤‰æ›´ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã€ãã®ã»ã†ãŒå®‰å…¨ã¨ãªã‚Šã€è²»ç”¨ã¯20ä¸‡å††ç¨‹åº¦ã§ã‚ã‚‹æ—¨ã‚’ä¼ãˆãŸï¼ˆ2010å¹´9æœˆ27æ—¥ï¼‰ãŒã€ãã®å¾ŒXç¤¾ã¯æ”¹è‰¯ã®æŒ‡ç¤ºã‚’ã—ãªã‹ã£ãŸ ä»¥ä¸‹ã®è„†å¼±æ€§ãã®ä»–ãŒèªã‚ã‚‰ã‚ŒãŸ ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†æ©Ÿèƒ½ã®IDã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒ admin/password ã§ã‚ã£ãŸ å€‹äººæƒ…å ±ãŒè¨˜è¼‰ã•ã‚ŒãŸãŠå•ã„åˆã‚ã›ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®é–²è¦§ãŒå¯èƒ½ï¼ˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãƒªã‚¹ãƒ†ã‚£ãƒ³ã‚°ã¨æ„å›³ã—ãªã„ãƒ•ã‚¡ã‚¤
Kanasansoft 2015/01/24
privacy

db

security

sql

development
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kanasansoft 2013/04/03
RDBã«é–¢ã™ã‚‹éžå¸¸ã«å¤šãã®ãƒŽã‚¦ãƒã‚¦ãŒè¼‰ã£ã¦ã„ã‚‹ã€‚

db

programming

database

sql

tips
ãƒªãƒ³ã‚¯
MongoDBã®è–„ã„æœ¬(The Little MongoDB Book) - cuspy diary
Karl Seguinã•ã‚“ã®ã€ŒThe Little Mongo DB Bookã€ã‚’å’Œè¨³ã—ã¾ã—ãŸã€‚ ã“ã®æœ¬ã¯Mongo DBã®åŸºç¤Žã‚’å®Ÿéš›ã«æ‰‹ã‚’å‹•ã‹ã—ã¦å¦ã¶ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã§ã™ã€‚ Mongo DBã®åŸºç¤Žã‹ã‚‰ã€ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã®è¨è¨ˆæ–¹æ³•ã€MapReduceãªã©å¹…åºƒã„å†…å®¹ã‚’ã‚«ãƒãƒ¼ã—ã¦ã„ã¾ã™ã€‚ ã¾ãŸã€ç‰¹åˆ¥Mongo DBã«èˆˆå‘³ãŒç„¡ãã¦ã‚‚ç†è€…ã®NoSQLã¸ã®è€ƒãˆæ–¹ã¯ä¸€èªã®ä¾¡å€¤ãŒã‚ã‚‹ã ã‚ã†ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰PDFç‰ˆ the-little-mongo db-book-ja.pdf epubç‰ˆ the-little-mongo db-book-ja.epub(ã‚ã‚“ã¾ã‚Šãã‚Œã„ã«çµ„ç‰ˆã§ãã¦ãªã„ã‘ã©â€¦) èª¤è¨³ãªã©ã‚ã‚Œã° @hamano ã¾ã§ ã‚½ãƒ¼ã‚¹ã¯ã“ã¡ã‚‰: https://github.com/hamano/the-little-mongo db-book æ›´æ–°å±¥æ´2012/04/17 v1.0 åˆç‰ˆå…¬é–‹ã€‚ 2012/06/15 v
Kanasansoft 2012/04/18
mongodb

ebook

pdf

book

db

nosql
ãƒªãƒ³ã‚¯
åŒ¿åã«ã‚ˆã‚‹å‘Šç™ºã€ŒMongoDBã¯ä½¿ã£ã¦ã¯ã„ã‘ãªã„ã€ | gihyo.jp
ã€ŒPASTEBINã€ã¨ã„ã†ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã®å‡ºåŠ›ã‚„ã‚¨ãƒ©ãƒ¼ãƒã‚°ã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãªã©ã‚’å¼µã‚Šä»˜ã‘ã¦å…±æœ‰ã™ã‚‹Webã‚µã‚¤ãƒˆãŒã‚ã‚Šã€ãã“ã«æŠ•ç¨¿ã•ã‚ŒãŸå†…å®¹ãŒè°è«–ã‚’å·»ãèµ·ã“ã—ã¾ã—ãŸã€‚ã€Œâ Don't use Mongo DBã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ãŒä»˜ã‘ã‚‰ã‚ŒãŸæ–‡ç« ã«ã¯ã€ãƒ˜ãƒ“ãƒ¼ã«Mongo DBã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰ã®è¾›è¾£ï¼ˆã—ã‚“ã‚‰ã¤ï¼‰ãªæ‰¹åˆ¤ãŒç¶´ï¼ˆã¤ã¥ï¼‰ã‚‰ã‚Œã¦ã„ã¾ã—ãŸã€‚ å‘Šç™ºè€…ã¯ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ã¦æ•°åƒä¸‡ä»¶ã‚‚ã®ãƒ¦ãƒ¼ã‚¶ç®¡ç†ã«Mongo DBã‚’åˆ©ç”¨ã—ã¦ãŠã‚Šã€ã“ã‚Œã¾ã§é•·ã„é–“10genç¤¾ï¼ˆMongo DBã®é–‹ç™ºå…ƒï¼‰ã‹ã‚‰æœ€é«˜ãƒ¬ãƒ™ãƒ«ã®ï¼‰æœ‰å„Ÿã‚µãƒãƒ¼ãƒˆã‚’å—ã‘ã¦ã„ãŸãŸã‚é»™ã£ã¦ã„ãŸãŒã€å°‘ã—ã§ã‚‚å¤šãã®äººã«è¦é˜ã‚’é³´ã‚‰ã™ã¹ãç«‹ã¡ä¸ŠãŒã£ãŸãã†ã§ã™ã€‚Mongo DBã®æ‰±ã„ã‚„ã™ã•ã‚„ã‚¹ã‚ãƒ¼ãƒžãƒ•ãƒªãƒ¼ãªãƒ¢ãƒ‡ãƒ«ã€è±Šå¯Œãªå®Ÿç¸¾ãªã©ã«ä¸€å®šã®è©•ä¾¡ã‚’ã—ã¤ã¤ã‚‚ã€å¤§è¦æ¨¡ãªç’°å¢ƒã§å®Ÿéš›ã«å‹•ã‹ã•ãšã«åˆ¤æ–ã™ã‚‹ã®ã¯æ™‚ã«é‡å¤§ãªå•é¡Œã¨ãªã‚Šã€Mongo DBã«ã¯ãã‚ŒãŒå‘ã„ã¦ã„ãªã„ã¨è¨€ã„åˆ‡ã£ã¦ã„ã¾ã™ã€‚ å…·ä½“çš„ã«
Kanasansoft 2011/12/29
å˜ãªã‚‹æ‰¹åˆ¤ã«çµ‚ã‚ã‚‰ãšã€æ”¹å–„ã«å‘ã‹ã†ç™ºå±•çš„ãªå±•é–‹ã‚’æœ›ã‚€ã€‚/å¤ã„æƒ…å ±ãªã®ã‹ã€‚

mongodb

db

kvs
ãƒªãƒ³ã‚¯
www.tamandua-webtools.net is Expired or Suspended.
ã€Œ www.tamandua-webtools.net ã€ã®ãƒšãƒ¼ã‚¸ã¯ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ãŒç„¡åŠ¹ãªçŠ¶æ…‹ã§ã™ã€‚ ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆç®¡ç†è€…ã®æ–¹ã¯ã“ã¡ã‚‰ã‹ã‚‰å¤‰æ›´ãƒ»æ›´æ–°ã‚’è¡Œã£ã¦ãã ã•ã„ã€‚ ã€Œ www.tamandua-webtools.net ã€is Expired or Suspended. The WHOIS is here.
Kanasansoft 2011/02/22
db

database

sql

sqlite
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®ã‚³ãƒ¼ãƒ‰ãŒæ›¸ã‹ã‚ŒãŸãƒŠãƒ³ãƒãƒ¼ãƒ—ãƒ¬ãƒ¼ãƒˆ
ã‚‚ã—ã“ã‚Œã§ã‚ªãƒ¼ãƒ“ã‚¹ãªã©ã®é€Ÿåº¦é•åãƒã‚§ãƒƒã‚¯æ©Ÿå™¨ã®ã‚·ã‚¹ãƒ†ãƒ ãŒãƒ€ã‚¦ãƒ³ã—ãŸã‚‰ã€ãã‚Œã¯ã‚ªãƒ¼ãƒ“ã‚¹å´ã®è¨è¨ˆãƒŸã‚¹ã¨ã„ã†ã‚ˆã‚Šã¯ã€ã“ã®ã‚®ãƒ¼ã‚¯ã®æ–¹ãŒå¤©æ™´ã‚Œã€ã¨ã„ã†æ°—ãŒã—ã¾ã™ãã€‚ [See Also] Joel Johnsonï¼ˆã„ã¡ã‚‹ï¼‰
Kanasansoft 2010/03/26
QRã‚³ãƒ¼ãƒ‰ã«åŸ‹ã‚è¾¼ã‚€ã®ã‚‚æœ‰ã‚Šã‹ã€‚

sql

security

programming

db

joke

humor
ãƒªãƒ³ã‚¯
memcachedãƒ—ãƒãƒˆã‚³ãƒ«ã«ã¤ã„ã¦
â€» memcachedãƒ—ãƒãƒˆã‚³ãƒ«ã®ä»•æ§˜æ›¸ã¯ä»¥ä¸‹ã«ã‚ã‚Šã¾ã™ã€‚ http://code.sixapart.com/svn/memcached/trunk/server/doc/protocol.txt ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜ã‚’è¡Œã†ã‚³ãƒžãƒ³ãƒ‰(set,add,replace,append,prepend)ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ–‡æ³•ã¨ãªã‚Šã¾ã™ã€‚ <ã‚³ãƒžãƒ³ãƒ‰> <key> <flags> <exptime> <bytes> <data> <key>ã¯ä¿å˜ã™ã‚‹ãŸã‚ã®ã‚ãƒ¼åã‚’æŒ‡å®šã—ã¾ã™ã€‚å®Ÿè£…ã«ã‚ˆã£ã¦ã‚‚ç•°ãªã‚Šã¾ã™ãŒã€æœ€å¤§é•·ã¯250byteã§ã™ã€‚ <flags>ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç‰¹æœ‰ã®32bitã®å€¤(0ã€œ4294967295)ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ãŒã§ãã€ãƒ‡ãƒ¼ã‚¿ã®å–å¾—æ™‚ã«æ ¼ç´ã—ãŸæ™‚ã®å€¤ãŒè¿”ã•ã‚Œã¾ã™ã€‚ <exptime>ã¯ãƒ‡ãƒ¼ã‚¿ã®æœ‰åŠ¹æœŸé–“ã‚’ç§’æ•°ã§æŒ‡å®šã—ã¾ã™ã€‚æŒ‡å®šã—ãŸæ™‚é–“çµŒéŽã™ã‚‹ã¨ã€è‡ªå‹•çš„ã«ã‚ãƒ¼ãŒå‰Šé™¤ã•ã‚Œã¾ã™ã€‚0ã‚’æŒ‡å®šã™ã‚‹ã¨è‡ªå‹•å‰Šé™¤ã•ã‚Œ
Kanasansoft 2010/03/26
kvs

db

memcached
ãƒªãƒ³ã‚¯
Key Value Storeã«ã¤ã„ã¦
ä¸»ãª3ã¤ã®æ©Ÿèƒ½ã«ã¤ã„ã¦å®Ÿè£…çŠ¶æ³ã‚’ç¤ºã—ã¦ã¿ã¾ã—ãŸã€‚ ã€Œãƒ‡ãƒ¼ã‚¿æ°¸ç¶šåŒ–ã€ã¨ã¯ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒã‚’å†èµ·å‹•ã—ã¦ã‚‚ãƒ‡ãƒ¼ã‚¿ãŒå¤±ã‚ã‚Œãªã„ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªã§ã¯ãªãHDDç‰ã«æ ¼ç´ã§ãã‚‹æ©Ÿèƒ½ã§ã™ã€‚ä¾‹ãˆã°ã€memcachedã¯ãƒ¡ãƒ¢ãƒªã«ãƒ‡ãƒ¼ã‚¿ã‚’ç½®ããŸã‚ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒã‚’å†èµ·å‹•ã™ã‚‹ã¨ãƒ‡ãƒ¼ã‚¿ãŒå¤±ã‚ã‚Œã¾ã™ã€‚ ã€Œãƒ‡ãƒ¼ã‚¿å†—é•·åŒ–ã€ã¨ã¯ã€æ ¼ç´ã—ãŸãƒ‡ãƒ¼ã‚¿ãŒã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒå´ã§è‡ªå‹•çš„ã«è¤‡æ•°ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒã«ã‚³ãƒ”ãƒ¼ãŒä½œã‚‰ã‚Œã‚‹æ©Ÿèƒ½ã§ã™ã€‚1å°(ã¾ãŸã¯æ•°å°)ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒãŒãƒ€ã‚¦ãƒ³ã—ã¦ã‚‚ãƒ‡ãƒ¼ã‚¿ãŒå¤±ã‚ã‚Œã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã€Œãƒ‡ãƒ¼ã‚¿åˆ†æ•£ã€ã¨ã¯ã€ã‚ãƒ¼ã®ãƒãƒƒã‚·ãƒ¥å€¤ç‰ã‚’å…ƒã«ãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´å…ˆã®ã‚µãƒ¼ãƒã‚’æŒ¯ã‚Šåˆ†ã‘ã‚‹æ©Ÿèƒ½ã§ã€è² è·åˆ†æ•£ã‚’å›³ã‚‹ã“ã¨ãŒã§ãã‚‹æ©Ÿèƒ½ã§ã™ã€‚ãªãŠã€memcachedã€Tokyo Tyrantã«ã¯ã‚µãƒ¼ãƒå´ã§ã®åˆ†æ•£æ©Ÿèƒ½ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ã‚ˆã£ã¦æ ¼ç´å…ˆã‚µãƒ¼ãƒã‚’åˆ†æ•£ã•ã›ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ã€‚ memcachedãƒ—ãƒãƒˆã‚³
Kanasansoft 2010/03/26
kvs

db
ãƒªãƒ³ã‚¯
ãƒ™ãƒ³ãƒãƒ£ãƒ¼ä¼æ¥ã®çµŒå–¶å±æ©Ÿãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆMETI/çµŒæ¸ˆç”£æ¥çœï¼‰
å¤šãã®ãƒ™ãƒ³ãƒãƒ£ãƒ¼ä¼æ¥ãŒèµ·æ¥å¾Œã«ã€åŒã˜ã‚ˆã†ãªå¤±æ•—ã€ãƒˆãƒ©ãƒ–ãƒ«ã€ãƒ’ãƒ¤ãƒªã¨ã—ãŸçµŒé¨“ã‚’ã—ã¦ãŠã‚Šã€æˆé•·ã«ä¼¸ã³æ‚©ã‚€ä¼æ¥ãŒå¤šã„ã¨è¨€ã‚ã‚Œã¦ã„ã¾ã™ã€‚ãã“ã§ã€ãƒ™ãƒ³ãƒãƒ£ãƒ¼ä¼æ¥ã®çµŒå–¶è€…ãŒæ§˜ã€…ãªå ´é¢ã§æ±ºæ–ã‚’ä¸‹ã™éš›ã®ã€Œè»¢ã°ã¬å…ˆã®æ–ã€ã¨ã—ã¦ã€å°†æ¥èµ·ã“ã‚Šã†ã‚‹ãƒªã‚¹ã‚¯ã‚’äºˆè¦‹ã§ãã‚‹ã‚ˆã†ãªå¤±æ•—ã€ãƒˆãƒ©ãƒ–ãƒ«ã€ãƒ’ãƒ¤ãƒªã¨ã—ãŸçµŒé¨“ã®äº‹ä¾‹ã‚’åŽé›†ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã—ã¾ã—ãŸã€‚ãƒ™ãƒ³ãƒãƒ£ãƒ¼ä¼æ¥ã®æˆé•·ã«å‘ã‘ãŸçµŒå–¶åˆ¤æ–ã®ææ–™ã¨ã—ã¦ã”åˆ©ç”¨ã„ãŸã ã‘ã‚Œã°å¹¸ç”šã«å˜ã˜ã¾ã™ã€‚ æœ¬ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ã€å¹³æˆ19å¹´åº¦ã«ãƒ™ãƒ³ãƒãƒ£ãƒ¼ä¼æ¥ã«ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼èª¿æŸ»ã‚’å®Ÿæ–½ã—ã¦åŽé›†ã—ãŸ83ã®å¤±æ•—ã€ãƒˆãƒ©ãƒ–ãƒ«ã€ãƒ’ãƒ¤ãƒªã¨ã—ãŸçµŒé¨“ã«é–¢ã™ã‚‹äº‹ä¾‹ã‚’æŽ²è¼‰ã—ã¦ã„ã¾ã™ã€‚äº‹ä¾‹ã¯ã€ãƒ™ãƒ³ãƒãƒ£ãƒ¼ä¼æ¥ã®æˆé•·ã‚¹ãƒ†ãƒ¼ã‚¸ã‚„å¤±æ•—ã€ãƒˆãƒ©ãƒ–ãƒ«ã€ãƒ’ãƒ¤ãƒªã¨ã—ãŸçµŒé¨“ã®åŽŸå› åŠã³çµæžœã¨ã„ã£ãŸåˆ†é¡žé …ç›®ã‚’ã‚‚ã¨ã«æ¤œç´¢ãŒå¯èƒ½ã¨ãªã£ã¦ã„ã¾ã™ã€‚
Kanasansoft 2009/08/05
business

data

database

db

management

tips

work
ãƒªãƒ³ã‚¯
Firefoxã®æ¿€é‡ãŒãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‰Šé™¤ã—ãŸã‚‰æ”¹å–„ã—ãŸã§ã”ã–ã‚‹ : ãƒã‚±ã‚¹ã‚¿ç¤¾é•·æ—¥è¨˜
æœ€è¿‘ã€ã©ã†ã‚‚ãƒ‘ã‚½ã‚³ãƒ³ãŒé‡ã„ãªã‚ã€ã¨æ€ã£ã¦ãŸã®ã§ã™ã€‚ ã‚‚ã£ã¨ã„ã†ã¨ã€FirefoxãŒç•°å¸¸ã«é‡ã„ã€‚ãƒšãƒ¼ã‚¸ã‚’é–‹ã“ã†ã¨ã™ã‚‹ã¨ã‚‚ãŸã¤ãã—ã€ã‚¿ãƒ–ã‚’åˆ‡ã‚Šæ›¿ãˆã‚‹æ™‚ã‚‚ã‚‚ãŸã¤ãã€‚ ãƒ‘ã‚½ã‚³ãƒ³ã®ã›ã„ã ã‚ã†ã‹ã¨ã€ã„ã‚ã„ã‚ã¨è©¦ã—ã¦ãŸã®ã§ã™ãŒã€ãªã‹ãªã‹åŠ¹æžœãŒã§ãšã€‚ (Â´ï½¥Ï‰ï½¥`)é‡ã„ãªã ã¨é‡ã„ãªãŒã‚‰1é€±é–“ãã‚‰ã„æˆ‘æ…¢ã—ã¦ã¾ã—ãŸã€‚ ã—ã‹ã—ã€ãã‚ŒãŒé•·ã„é–“ç¶šãã¨ã€ã ã‚“ã ã‚“ã¨è…¹ãŒç«‹ã£ã¦ãã¦ é‡ã„ã‚ˆï¼ãƒ½(`Ð”Â´)ï¾‰ ï¾‘ï½¯ï½·ï½° ã¨ã‚¤ãƒ©ã‚¤ãƒ©ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ç”Ÿç”£æ€§ãŒè½ã¡ã¦ãŸã‚ã‘ã§ã™ã€‚ ã§ã€ä»Šæ—¥ã€‚ ã„ã¤ã‚‚ã«æ¯”ã¹ã¦é‡ã„é‡ã„é‡ã„ï¼ãƒ½(`Ð”Â´)ï¾‰ï¾Œï½«ï½«ï½¯ï½«ï½µï½«ï½« ã¨ãªã£ã¦ã„ãŸã®ã§ã™ãŒã€æ‰“ã¡åˆã‚ã›ã®ä¸ã§Gmailã‚’é–‹ã“ã†ã¨ã—ãŸã‚‰ã‚‚ãŸã¤ãã‚‚ãŸã¤ãï¼ (ãƒŽ#`Ð”Â´)ãƒŽâŒ’â”»â”â”»ã€€ï½·ï¾žï½¬ï½±ï½±ï½±ï½± é–‹ã‹ããˆã‚ˆï¼ï¼ ãƒ½(`(`(`(`ãƒ½(`Ð”Â´)ï¾‰ ãƒ•ã‚¡ãƒ»ãƒ•ã‚©ã‚¡ãƒ»ãƒ•ãƒ¯ã‚©ã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªã‚ªãƒ³!! ã£ã¦ãªã‚Šã€ã¤ã„ãã®å ´ã®å‹¢ã„ã§F
Kanasansoft 2009/04/16
å±¥æ´ã‚„ã‚ãƒ£ãƒƒã‚·ãƒ¥ç‰ã®å‰Šé™¤ã‹ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ãƒ•ã‚©ãƒ«ãƒ€å†…ã®.sqliteã®åœ§ç¸®ã‚’å…ˆã«ã™ã¹ãã€‚å‰Šé™¤ã¯æœ€çµ‚æ‰‹æ®µã€‚æ‰‹å‰å‘³å™Œ http://www.kanasansoft.com/weblab/2008/10/sqlitedb.html vacuumã®å‰ã«.sqliteã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’!

db

sql

firefox
ãƒªãƒ³ã‚¯
æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå¾Œç·¨ï¼‰
ï¼žï¼žå‰ç·¨ ãƒãƒƒã‚·ãƒ¥åˆ©ç”¨ã§æ¯”è¼ƒã‚’æ¸›ã‚‰ã™ å¾Œç·¨ã§ã¯ã¾ãšï¼Œã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãŒé¸æŠžã™ã‚‹æœ€çŸçµŒè·¯ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…±é€šã®ã‚ãƒ¼ã‚’ç”¨ã„ã¦çµåˆã™ã‚‹ã€Œã‚¸ãƒ§ã‚¤ãƒ³ã€ã¯ã„ãã¤ã‹ã®æ–¹å¼ãŒã‚ã‚‹ã€‚ãã®ä¸€ã¤ã§ã‚ã‚‹ãƒãƒƒã‚·ãƒ¥ãƒ»ã‚¸ãƒ§ã‚¤ãƒ³ã¯ï¼Œãƒãƒƒã‚·ãƒ¥é–¢æ•°ã‚’ä½¿ã£ã¦ï¼Œä¸€ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ãƒ¼ã‹ã‚‰ãƒãƒƒã‚·ãƒ¥å€¤ã‚’è¨ˆç®—ã™ã‚‹ï¼ˆå›³4ï¼‰ã€‚ã•ã‚‰ã«ï¼Œãƒãƒƒã‚·ãƒ¥å€¤ã¨è©²å½“ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã§æ§‹æˆã™ã‚‹ã€Œãƒãƒƒã‚·ãƒ¥ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ã€ã‚’ä½œæˆã™ã‚‹ã€‚åŒæ§˜ã«äºŒã¤ç›®ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ãƒãƒƒã‚·ãƒ¥å€¤ã‚’è¨ˆç®—ã—ï¼Œãã®å€¤ã‚’åŸºã«æ¤œç´¢ã™ã‚‹ãƒãƒƒã‚·ãƒ¥ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ç‰¹å®šã™ã‚‹ã€‚ãƒãƒƒã‚·ãƒ¥å€¤ã‚’è¨ˆç®—ã™ã‚‹ã ã‘ã§æ¯”è¼ƒå¯¾è±¡ã®ãƒ‡ãƒ¼ã‚¿ãŒçµžã‚Šè¾¼ã‚ã‚‹ã®ã§ï¼Œã»ã‹ã®ã‚¸ãƒ§ã‚¤ãƒ³æ–¹å¼ã‚ˆã‚Šã‚‚é«˜é€Ÿã«ãªã‚‹å ´åˆãŒã‚ã‚‹ã€‚ãŸã ã—ï¼Œã€Œå„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å±•é–‹ã§ãã‚‹ã ã‘ã®ãƒ¡ãƒ¢ãƒªãƒ¼å®¹é‡ãŒå¿…è¦ã«ãªã‚‹ã€‚ãƒ¡ãƒ¢ãƒªãƒ¼ãŒè¶³ã‚Šãªã„ã¨é€†ã«é…ããªã‚‹ã€ï¼ˆä¼Šè—¤å¿ ãƒ†ã‚¯ãƒŽã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚º ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ æŠ€è¡“éƒ¨ éƒ¨é•·ä»£è¡Œ å®®ç”°æ¦æ°ï¼‰ã¨ã„ã£ãŸæ³¨æ„ç‚¹ãŒã‚ã‚‹ã€‚ å›³4â—ãƒãƒƒã‚·ãƒ¥ãƒ»ã‚¸ãƒ§ã‚¤ãƒ³
Kanasansoft 2007/09/13
db

performance

tips

tuning

development
ãƒªãƒ³ã‚¯
æœ€çŸã‹ã¤æœ€é€Ÿã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ŒDBé«˜é€ŸåŒ–æŠ€è¡“ã€ï¼ˆå‰ç·¨ï¼‰ï¼šITpro
ãƒã‚¤ãƒ³ãƒˆ ãƒ»é«˜åº¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ã‚¸ãƒ§ã‚¤ãƒ³ã‚’åˆ©ç”¨ã—ï¼Œæœ€çŸçµŒè·¯ã§ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ ãƒ»ãƒ¡ãƒ¢ãƒªãƒ¼ä¸è¶³ã‚’è‡ªå¾‹çš„ã«è§£æ¶ˆã—ï¼Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ã‚’é«˜ã‚ã‚‹ ãƒ»ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ¼DBã¯å…¨ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¡ãƒ¢ãƒªãƒ¼ã§å‡¦ç†ã—ï¼Œé«˜é€ŸåŒ–ã‚’å›³ã‚‹ ç›®çš„åœ°ã«æ—©ãåˆ°ç€ã—ãŸã„ãªã‚‰ï¼Œæœ€çŸã®çµŒè·¯ã‚’æœ€é€Ÿã§è¡Œã‘ã°ã‚ˆã„ã€‚ã“ã‚Œã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã§ã‚‚åŒæ§˜ã ï¼ˆå›³1ï¼‰ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã®æœ€çŸçµŒè·¯ã‚’è¦‹ã¤ã‘ï¼Œãƒ¡ãƒ¢ãƒªãƒ¼ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ã‚’å¢—ã‚„ã—ã¦ï¼Œæœ€é€Ÿã§ãŸã©ã‚Šç€ãã€‚DBã«ã¯ãã‚“ãªæŠ€è¡“ãŒè©°ã¾ã£ã¦ã„ã‚‹ã€‚ å›³1â—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–æŠ€è¡“ã®ãƒã‚¤ãƒ³ãƒˆ ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã‚’ä½¿ã„ã€ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ã€‚ã¾ãŸã€ã§ãã‚‹ã ã‘ãƒ¡ãƒ¢ãƒªãƒ¼ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã›ã¦ãŠãã“ã¨ã§ã€ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ã€ã¨ã„ã†äºŒã¤ã®ãƒã‚¤ãƒ³ãƒˆãŒã‚ã‚‹ [ç”»åƒã®ã‚¯ãƒªãƒƒã‚¯ã§æ‹¡å¤§è¡¨ç¤º] ä»¥ä¸‹ã§ã¯ï¼Œï¼ˆ1ï¼‰ãƒ‡ãƒ¼ã‚¿ã«ãŸã©ã‚Šç€ãæœ€çŸã®é“ã‚’é¸ã¶ä»•çµ„ã¿ã¨ï¼Œï¼ˆ2ï¼‰ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’ä¸Šã’ã‚‹ä»•çµ„ã¿ã®
Kanasansoft 2007/09/13
db

performance

tips

tuning

development
ãƒªãƒ³ã‚¯
mixiã®ç”Ÿã¿ã®è¦ªâ€œãƒã‚¿ãƒ©æ°â€ãŒèªžã‚‹MySQLã®æ„å¤–ãªåˆ©ç”¨æ³• ï¼ TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
æ—¥è¨˜ã ã‘ã§4å„„ä»¶ã®ãƒ‡ãƒ¼ã‚¿ ãƒŸã‚¯ã‚·ã‚£ãŒé‹å–¶ã™ã‚‹SNSã€Œmixiã€ã¯ã€2007å¹´7æœˆæœ«æ®µéšŽã§ãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ãŒ1110ä¸‡äººã€‚äººãŒ12äººé›†ã¾ã‚Œã°ã€1äººã¯mixiãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ã†ã‚ã‘ã ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–çŽ‡ï¼ˆãƒã‚°ã‚¤ãƒ³é–“éš”ãŒ3æ—¥ä»¥å†…ï¼‰ã¯ç´„62ï¼…ã¨é«˜ãã€2007å¹´4æœˆã‹ã‚‰6æœˆã®æœˆé–“å¹³å‡ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¯117.5å„„ã«é”ã—ãŸã€‚æ—¥è¨˜ã ã‘ã§ã‚‚4å„„ä»¶ä»¥ä¸Šã«ä¸Šã‚‹ãªã©ã€è“„ç©ã™ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚‚èŽ«å¤§ã€‚2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‹ã‚‰ã€ã‚ãšã‹3å¹´åŠã§ç¾åœ¨ã®å·¨å¤§ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¸ã¨ç™ºå±•ã—ãŸã®ã ã€‚ ãƒŸã‚¯ã‚·ã‚£ã¯ã€ã€ŒLAMPï¼ˆOSã®Linuxã€Webã‚µãƒ¼ãƒã®Apacheã€DBMSã®MySQLã€é–‹ç™ºè¨€èªžã®Perlã€PHPã€Pythonï¼‰ã€ã¨å‘¼ã°ã‚Œã‚‹Webã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®æ¨™æº–çš„ãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆä»¥ä¸‹ã€OSSï¼‰ã§ã‚·ã‚¹ãƒ†ãƒ ã‚’è‡ªç¤¾é–‹ç™ºã—ã€å®‰ä¾¡ãªPCã‚µãƒ¼ãƒã‚’1000å°ä»¥ä¸Šé€£ãã‚‹è¶…åˆ†æ•£æ§‹æˆã§mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã¦ã„ã‚‹ï¼ˆåºƒå‘Šé…ä¿¡ãªã©å‘¨è¾ºæ©Ÿèƒ½ã§ã¯
Kanasansoft 2007/09/13
db

interview

mysql

performance

perl

programming

scalability

server

sql

sns
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kanasansoft 2007/09/03
algorithm

database

db

programming

tips

sql
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€NEWSã€‘SQLæ–‡ã‚’GUIã§ä½œæˆã§ãã‚‹ãƒ•ãƒªãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€
GUIã«ã‚ˆã‚‹SQLæ–‡ã®ä½œæˆãªã©ã€ã•ã¾ã–ã¾ãªé–‹ç™ºæ”¯æ´æ©Ÿèƒ½ã‚’å‚™ãˆã‚‹SQLé–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€v1.1.7.413ãŒ6æœˆ4æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã€‚Windows 2000/XPã«å¯¾å¿œã—ã¦ãŠã‚Šã€å€‹äººä½¿ç”¨ãƒ»æ¥å‹™ã«ã‹ã‹ã‚ã‚‰ãšãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã¨ã—ã¦åˆ©ç”¨å¯èƒ½ã€‚ç¾åœ¨ä½œè€…ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ ã€Œé»’çŒ« SQL Studioã€ã¯ã€SQLæ–‡ã®ä½œæˆã‚„ãƒ†ã‚¹ãƒˆã‚’è¡Œãˆã‚‹æ±Žç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€‚æœ¬ã‚½ãƒ•ãƒˆä¸Šã‹ã‚‰OLE DBæŽ¥ç¶šã¾ãŸã¯ODBCãƒ‰ãƒ©ã‚¤ãƒã«å¯¾å¿œã™ã‚‹å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ç›´æŽ¥æŽ¥ç¶šå¯èƒ½ã§ã€ä½œæˆã—ãŸSQLæ–‡ã‚’å®Ÿéš›ã«ãƒ†ã‚¹ãƒˆå®Ÿè¡Œã§ãã‚‹ã€‚ç”»é¢ã¯3ãƒšã‚¤ãƒ³æ§‹æˆã§ã€å·¦å´ã«ã¯è¤‡æ•°ã®SQLã‚½ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç®¡ç†ã§ãã‚‹ãƒ•ã‚¡ã‚¤ãƒ©ãƒ¼ã€ä¸å¤®ã«ã¯è¤‡æ•°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¿ãƒ–ã§åˆ‡ã‚Šæ›¿ãˆã¦è¡¨ç¤ºã§ãã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã€å³å´ã«ã¯æŽ¥ç¶šã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚’ãƒ„ãƒªãƒ¼ã¨ãƒªã‚¹ãƒˆã§è¡¨ç¤ºã™ã‚‹â€œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©â€ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ SQLæ–‡ã®ä½œæˆæ™‚ã¯ã€ã•ã¾ã–
Kanasansoft 2007/07/05
db

gui

sql

software

tool
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã®ãƒ¢ãƒ‡ãƒªãƒ³ã‚°
Kanasansoft 2007/06/20
database

db

data

model

debian

development
ãƒªãƒ³ã‚¯
ã€ŒPostgreSQLã¯é…ã„ã€ã¯æœ¬å½“ã‹ï¼Ÿï¼šOSSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¯”è¼ƒ - CNET Japan
å°åˆ·ã™ã‚‹ ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ ãƒ†ã‚ã‚¹ãƒˆ HTML é›»åæ›¸ç± PDF ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ãƒ†ã‚ã‚¹ãƒˆ é›»åæ›¸ç± PDF ã‚¯ãƒªãƒƒãƒ—ã—ãŸè¨˜äº‹ã‚’Myãƒšãƒ¼ã‚¸ã‹ã‚‰èªã‚€ã“ã¨ãŒã§ãã¾ã™ LAMPã‚„LAPPã¨ã„ã£ãŸè¨€è‘‰ãŒç¤ºã—ã¦ã„ã‚‹ã‚ˆã†ã«ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆOSSï¼‰ã§ã®ä»£è¡¨çš„ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã¨ã„ãˆã°ã€ã€ŒMySQLã€ã¨ã€ŒPostgreSQLã€ã ã€‚ã“ã®2ã¤ã®RDBMSã¯åŒç‰ã§ã‚ã‚‹ã‹ã®ã‚ˆã†ã«æ€ã‚ã‚Œã¦ã„ã‚‹ãŒã€ã—ã‹ã—PostgreSQLã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å›£ä½“ã€Œæ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼šã€ã§ç†äº‹é•·ã‚’å‹™ã‚ã‚‹ç‰‡å²¡è£•ç”Ÿæ°ã«ã‚ˆã‚Œã°ã€ã€ŒPostgreSQLã¯ã‚ã¾ã‚Šä¿¡ç”¨ã•ã‚Œã¦ã„ãªã„ã€ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ãã†ã ã€‚ ã€Œååˆ†ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚ŒãŸMySQLã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãªã„PostgreSQLã‚’æ¯”è¼ƒã—ãŸã‚Šã€åå¯¾ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚ŒãŸPostgreSQLã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãªã„MySQLã‚’æ¯”è¼ƒã—ãŸã‚Šã€ã‚ã‚‹ã„ã¯æ¯”
Kanasansoft 2007/04/13
benchmark

db

performance

software

sql
ãƒªãƒ³ã‚¯
MySQLã®ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹10ã®Tips - PHPãƒ—ãƒï¼ãƒ‹ãƒ¥ãƒ¼ã‚¹
å¹³ç´ ã‚ˆã‚Šã€ŒPHPãƒ—ãƒï¼ã€ã‚’ã”æ„›é¡§ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ 2006å¹´ã‚ˆã‚Šé‹å–¶ã—ã¦ã¾ã„ã‚Šã¾ã—ãŸã€ŒPHPãƒ—ãƒï¼ã€ã§ã™ãŒã€ã‚µãƒ¼ãƒ“ã‚¹ã®åˆ©ç”¨çŠ¶æ³ã‚’é‘‘ã¿ã¾ã—ã¦ã€2018å¹´9æœˆ25æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã•ã›ã¦ã„ãŸã ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã¾ã—ã¦ã€2018å¹´8æœˆ28æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’æŒã¡ã¾ã—ã¦ã€æ–°è¦ä¼šå“¡ç™»éŒ²ãªã‚‰ã³ã«Q&AæŽ²ç¤ºæ¿ã¸ã®æ–°ãŸãªè³ªå•ã€å›žç”ã®æŠ•ç¨¿ã‚’åœæ¢ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ãªãŠã€ã”ç™»éŒ²ã„ãŸã ã„ãŸçš†æ§˜ã®å€‹äººæƒ…å ±ã«ã¤ãã¾ã—ã¦ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†å¾Œã€å¼Šç¤¾ãŒè²¬ä»»ã‚’ã‚‚ã£ã¦æ¶ˆåŽ»ã„ãŸã—ã¾ã™ã€‚ ã“ã‚Œã¾ã§å¤šãã®çš†æ§˜ã«ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ã¦ã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã€çš†æ§˜ã«ã¯ã”ä¸ä¾¿ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ã“ã¨ã€å¿ƒã‚ˆã‚ŠãŠè©«ã³ç”³ã—ä¸Šã’ã¾ã™ã€‚ æœ¬ä»¶ã«é–¢ã™ã‚‹ãŠå•ã„åˆã‚ã›ã¯ã“ã¡ã‚‰ã‚ˆã‚ŠãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kanasansoft 2007/04/10
db

mysql

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

mysql

programming

search
ãƒªãƒ³ã‚¯
1