[B! database][DataBase] Glnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Gln id:Gln

databaseã¨DataBaseã«é–¢ã™ã‚‹Glnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (66)

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

ã“ã‚Œã‹ã‚‰MySQLã‚’ã‚¤ãƒã‹ã‚‰å¦ã¶äººã«æ§ã’ãŸã„23å€‹ã®ã‚³ãƒžãƒ³ãƒ‰ãƒªã‚¹ãƒˆ
ã©ãƒ¼ã‚‚ã€‚ä»Šå¹´ã®æ˜¥é ƒã‹ã‚‰MySQLã‚’å¦ã³å§‹ã‚ãŸã€ã™ã‚‹ã·ï¼ˆ @isloop ï¼‰ã§ã™ã€‚ å¦ã³åˆã‚ã®ã“ã‚ã¯ã€ã€ŒãŸã‹ã ã‹æ–‡å—åˆ—ã‚’è¨˜éŒ²ã™ã‚‹ã ã‘ã§ãªã‚“ã¦ã‹ã£ãŸã‚‹ã„ã‚“ã ã€‚ã‚„ã£ã±ã‚ŠCSVä¿å˜ã«é€ƒã’ã‚ˆã†ã‹ãªã€‚ã€ã¨æ€ã£ã¦ã„ã¾ã—ãŸã€‚ãŒã€æœ€è¿‘ã«ãªã£ã¦ã‚ˆã†ã‚„ãæ…£ã‚Œã¦ããŸã‚ˆã†ã§ã€ã€Œçµæ§‹ä¾¿åˆ©ã˜ã‚ƒã‚“MySQLã€ã¨æ€ãˆã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã—ãŸã€‚ ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã¯ã€å¦ã³åˆã‚ã®é ƒã«æ¬²ã—ã‹ã£ãŸã€Œã¨ã‚Šã‚ãˆãšã“ã‚Œã ã‘è¦šãˆãŸã‚‰ãªã‚“ã¨ã‹ãªã‚‹MySQLã®ã‚³ãƒžãƒ³ãƒ‰ãƒªã‚¹ãƒˆã€ã¨ã„ã†ã‚‚ã®ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ ã“ã‚Œã‹ã‚‰MySQLã‚’ã‚¤ãƒã‹ã‚‰å¦ã³ãŸã„ã¨ã„ã†äººãŒå‚è€ƒã«ãªã‚Œã°ã“ã‚Œå¹¸ã„ã€‚
Gln 2014/07/15
mysql

database
ãƒªãƒ³ã‚¯
MySQLite: SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’èªã¿æ›¸ãã™ã‚‹MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³
Gln 2014/02/18
mysqlite

sqlite

DB

database

mysql

mariadb
ãƒªãƒ³ã‚¯
ASUS Padfone Android: ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ Memento Databaseã€€å®Ÿç”¨ç·¨
Gln 2014/02/09
Android

database

ã‚¢ãƒ—ãƒª
ãƒªãƒ³ã‚¯
ASUS Padfone Android: ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ Memento Databaseã€€ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ç·¨
Gln 2014/02/09
Android

database

ã‚¢ãƒ—ãƒª
ãƒªãƒ³ã‚¯
ASUS Padfone Android: ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ Memento Databaseã€€ãƒ‡ãƒ¼ã‚¿ç™»éŒ²ç·¨
Gln 2014/02/09
Android

database

ã‚¢ãƒ—ãƒª
ãƒªãƒ³ã‚¯
ASUS Padfone Android: ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ Memento Databaseã€€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆç·¨
Gln 2014/02/09
database

Android

ã‚¢ãƒ—ãƒª
ãƒªãƒ³ã‚¯
å€‹äººçš„ãªæƒ…å ±ã‚’ã¾ã¨ã‚ã¦ç®¡ç†ã§ãã‚‹ã€ŒMemento Databaseã€
ã‚¢ãƒ—ãƒªåï¼šMemento Databaseï¼ˆVer.2.1.0ï¼‰ é‡‘é¡ï¼šç„¡æ–™ï¼ˆ2013å¹´3æœˆ12æ—¥æ™‚ç‚¹ï¼‰ ã‚«ãƒ†ã‚´ãƒªï¼šä»•äº‹åŠ¹çŽ‡åŒ– é–‹ç™ºï¼šLuckyDroid ä½¿ç”¨ç«¯æœ«ï¼šLYNX 3D SH-03C ãŠã™ã™ã‚åº¦ï¼šâ˜…â˜…â˜…â˜†â˜† æœ¬æ£šã«ã‚ã‚‹æœ¬ã‚„CDãªã©ã®æƒ…å ±ã‹ã‚‰ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãªã©ã®æ©Ÿå¯†æƒ…å ±ã«ã„ãŸã‚‹ã¾ã§ã€å¤šãã®äººã¨å…±æœ‰ã™ã‚‹å¿…è¦ã¯ãªã„ã‘ã‚Œã©ã€è‡ªåˆ†ã«ã¨ã£ã¦å¿…è¦ãªæƒ…å ±ã‚’ã¾ã¨ã‚ã¦ãŠããŸã„ã‚±ãƒ¼ã‚¹ã¯æ„å¤–ã¨å¤šã„ã ã‚ã†ã€‚ãã†ã—ãŸãƒ‘ãƒ¼ã‚½ãƒŠãƒ«ãªæƒ…å ±ã‚’é›†ç´„ã§ãã‚‹ã®ãŒã€ŒMemento Databaseã€ã ã€‚ ã“ã®ã‚¢ãƒ—ãƒªã¯ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ä¸Šã§åˆ©ç”¨ã§ãã‚‹å€‹äººå‘ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã€‚ã€Œæœ¬ã®ãƒªã‚¹ãƒˆã€ã€Œæ–™ç†ã®ãƒ¬ã‚·ãƒ”ã€ãªã©ç›®çš„ã«å¿œã˜ãŸãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½œæˆã—ã€ãã®ä¸ã«ãƒ‡ãƒ¼ã‚¿ã‚’ç™»éŒ²ã—ã¦ãŠãã“ã¨ã§ã€å¾Œã‹ã‚‰ç°¡å˜ã«æƒ…å ±ã‚’å¼•ãå‡ºã›ã‚‹ã€‚ æœ¬æ ¼çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã®æ©Ÿèƒ½ã‚’å‚™ãˆã¦ãŠã‚Šã€ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ç™»éŒ²ã§ãã‚‹é …ç›®ã¯è‡ªèº«ã§è‡ªç”±ã«æ±ºã‚ã‚‹ã“ã¨ãŒå¯èƒ½ã ã€‚ãŸã¨ãˆã°æœ¬ã‚’ç®¡ç†ã—ãŸ
Gln 2014/02/09
database

android

ã‚¢ãƒ—ãƒª
ãƒªãƒ³ã‚¯
Memento Database : ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºè‡ªåœ¨ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆã‚¢ãƒ—ãƒªï¼è‹±èªžã«è² ã‘ãšã–ã£ãã‚Šè§£èª¬ï¼ç„¡æ–™Androidã‚¢ãƒ—ãƒª | ã‚ªã‚¯ãƒˆãƒ
ã€ŽMemento Databaseã€ã¯ã€ã©ã‚“ãªæƒ…å ±ã§ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã§ãã‚‹ãƒ‘ãƒ¼ã‚½ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆã‚¢ãƒ—ãƒªã§ã™ã€‚ é …ç›®ã‚’è‡ªç”±ã«ä½¿ã„ã‚„ã™ãä½œã‚Šã‹ãˆã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§ã€è‡ªåˆ†ã ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒç°¡å˜ã«ä½œã‚Œã¾ã™ï¼ ã¨ã„ã†èª¬æ˜Žã‚’èªã‚“ã§ã€ã€Œãã‚Œã¯ä¾¿åˆ©ï¼â€¦ã§ã‚‚è‹±èªžã€ã¨è¸µã‚’è¿”ã™æ–¹ã€å°‘ãªããªã„ã¨æ€ã„ã¾ã™ã€‚ ãã“ã§ä»Šå›žã¯ã€è‹±èªžã®å…¨ãã‚ã‹ã‚‰ãªã„ç§ãŒæ‰‹æŽ¢ã‚Šã§ã€ã“ã®ä¾¿åˆ©ã•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ï¼
Gln 2014/02/09
Android

ã‚¢ãƒ—ãƒª

database
ãƒªãƒ³ã‚¯
æ°¸ç¶šåŒ–å¯¾å¿œã®ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªDBã€ŒRedisã€ãŒç™»å ´ ï¼ ï¼ IT
2009/02/26 memcachedã«ä¼¼ãŸã‚ãƒ¼ã¨å€¤ã®å¯¾ã‚’ä¿å˜ã™ã‚‹ã‚¿ã‚¤ãƒ—ã®æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒRedisã€ãŒGoogle Codeã§2æœˆ25æ—¥ã«ãƒ™ãƒ¼ã‚¿ç‰ˆã¨ã—ã¦å…¬é–‹ã•ã‚ŒãŸã€‚é–‹ç™ºã—ãŸã®ã¯ã€ã‚¤ã‚¿ãƒªã‚¢äººã§ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã®é–‹ç™ºè€…ã€Salvatore Sanfilippoæ°ã€‚åŒæ°ã¯ã‚¤ã‚¿ãƒªã‚¢ã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚µã‚¤ãƒˆã‚„ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚µã‚¤ãƒˆã‚’ç«‹ã¡ä¸Šã’ãŸçµŒé¨“ãŒã‚ã‚Šã€ç¾åœ¨ã¯Webã‚µã‚¤ãƒˆã®è¨ªå•è€…ã‚’ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§è¿½åŠ è¡¨ç¤ºã™ã‚‹ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹æƒ…å ±å–å¾—ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™ºä¸ã¨ã„ã†ã€‚ Redisã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ã€GPL2ã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã€‚ANSI Cã§æ›¸ã‹ã‚Œã¦ã„ã¦ã€Linuxã‚„Mac OS Xã‚’å«ã‚€å¤šãã®POSIXã‚·ã‚¹ãƒ†ãƒ ã§å‹•ãã€‚ç¾åœ¨ã€PHPã‚„Rubyã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’é–‹ç™ºä¸ã¨ã„ã†ã€‚ Redisã¯memcachedã®ã‚ˆã†ã«ã‚ãƒ¼ã¨å€¤ã®å¯¾ã‚’ã€ã™ã¹ã¦ãƒ¡ãƒ¢ãƒªä¸Šã«ä¿å˜ã™ã‚‹ã€‚ãŸã ã—ã€memcachedã¨ç•°ãªã‚Šã€åŒæ™‚
Gln 2014/01/01
db

memory

memcached

database

kvs

Redis
ãƒªãƒ³ã‚¯
ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã®å¯¿å‘½å‚¾å‘ãŒã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ä¼šç¤¾ãŒé›†ã‚ãŸãƒ‡ãƒ¼ã‚¿ã‹ã‚‰æ˜Žã‚‰ã‹ã«
By Kevin Collins ä»•äº‹ã‚„ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆã«ã‚‚ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ¼ãŒæ·±ãå…¥ã‚Šè¾¼ã‚“ã§ãã¦ã€å¤šãã®ãƒ‡ãƒ¼ã‚¿ã‚„æƒ…å ±ãŒãƒ‘ã‚½ã‚³ãƒ³ã®ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã«ä¿å˜ã•ã‚Œã¦ã„ã‚‹äººã‚‚å¤šã„ã¯ãšã€‚ã—ã‹ã—ã€ãã‚“ãªãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã«ãƒˆãƒ©ãƒ–ãƒ«ãŒç™ºç”Ÿã—ã€ä¸ã®ãƒ‡ãƒ¼ã‚¿ãŒå¤±ã‚ã‚Œã¦ã—ã¾ã£ãŸã‚‰â€¦â€¦ã€‚æ©Ÿæ¢°ã§ã‚ã‚‹é™ã‚Šã€é–“é•ã„ãªãã„ã¤ã‹ã¯æ•…éšœã™ã‚‹ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã§ã™ãŒã€ãã‚“ãªãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã®å¯¿å‘½ã«ã¤ã„ã¦ã€èˆˆå‘³æ·±ã„ãƒ‡ãƒ¼ã‚¿ãŒç™ºè¡¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ Backblaze Blog Â» How long do disk drives last? http://blog.backblaze.com/2013/11/12/how-long-do-disk-drives-last/ ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç™ºè¡¨ã—ãŸã®ã¯ã€ã‚¢ãƒ¡ãƒªã‚«ã§ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒ‡ãƒ¼ã‚¿ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’é–‹ç™ºã™ã‚‹Backblazeç¤¾ã§ã™ã€‚ã“ã‚Œã¾ã§ã®5å¹´ã«ã‚ãŸã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã‹ã‚‰å–å¾—ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æžã—
Gln 2013/11/14
GIGAZINE

database

hdd

PC

Storage
ãƒªãƒ³ã‚¯
PostgreSQLã¯ã‚‚ã¯ã‚„ãŸã ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ã‚‰ãš â”€PostgreSQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2013 åŸºèª¿è¬›æ¼”ãƒ¬ãƒãƒ¼ãƒˆ | gihyo.jp
PostgreSQLã¯ã‚‚ã¯ã‚„ãŸã ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ã‚‰ãš â”€PostgreSQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2013 åŸºèª¿è¬›æ¼”ãƒ¬ãƒãƒ¼ãƒˆ Not so much as a database as a data Platformï¼ˆå˜ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¶…ãˆãŸãƒ‡ãƒ¼ã‚¿ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã¨ã—ã¦ã®å˜åœ¨â ï¼‰â â”€11æœˆ8æ—¥ã€éƒ½å†…ã§é–‹å‚¬ã•ã‚ŒãŸã€ŒPostgreSQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2013ã€ï¼ˆâ ä¸»å‚¬: æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼šï¼‰ã®åŸºèª¿è¬›æ¼”ã«ç™»å£‡ã—ãŸHerokué–‹ç™ºè€…ã®ãƒ”ãƒ¼ã‚¿ãƒ¼ãƒ»ã‚²ãƒ¼ã‚¬ãƒ³ï¼ˆPeter Geogheganï¼‰æ°ã¯PostgreSQLã‚’ã“ã†è¡¨ç¾ã—ã¾ã—ãŸã€‚ æ¥å¹´ã«ã¯æ¬¡ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®PostgreSQL 9.4ã®ãƒªãƒªãƒ¼ã‚¹ãŒæœŸå¾…ã•ã‚Œã¦ã„ã¾ã™ãŒã€ã‚²ãƒ¼ã‚¬ãƒ³æ°ã®è¨€ã†"ãƒ‡ãƒ¼ã‚¿ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ "ã¨ã—ã¦PostgreSQLã¯ã©ã®ã‚ˆã†ãªé€²åŒ–ã‚’é‚ã’ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚æœ¬ç¨¿ã§ã¯ã®åŸºèª¿è¬›æ¼”ã®å†…å®¹ã‚’ã‚‚ã¨ã«ã€PostgreSQLã®æ¬¡ãªã‚‹
Gln 2013/11/12
database

postgresql

DB
ãƒªãƒ³ã‚¯
SQLite Home Page
What Is SQLite? SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day. More Information... The SQLite file format is stable, cross
Gln 2013/10/11
database
ãƒªãƒ³ã‚¯
GoogleãŒMySQLã‹ã‚‰MariaDBã¸å†…éƒ¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¹—ã‚Šæ›ãˆã‹
GoogleãŒå†…éƒ¨ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’MySQLã‹ã‚‰MariaDBã«ä¹—ã‚Šæ›ãˆãŸã®ã§ã¯ãªã„ã‹ã€ã¨ã„ã†è¨˜äº‹ãŒå…ˆé€±ã‹ã‚‰ã„ãã¤ã‹å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ Google swaps out MySQL, moves to MariaDB â€¢ The Register Google Waves Goodbye To MySQL In Favor Of MariaDB â€“ ReadWrite Google quietly dumps Oracle MySQL for MariaDB | ZDNet ä¸€ç•ªæœ€åˆã®è¨˜äº‹ã¨ãªã£ãŸThe Registgerã§ã¯ã€æ¬¡ã®ã‚ˆã†ã«æ›¸ã„ã¦ã„ã¾ã™ã€‚ Google is migrating its MySQL systems over to MariaDB, allowing the search company to get away from the Oracle-bac
Gln 2013/09/17
Google

mysql

database

MariaDB
ãƒªãƒ³ã‚¯
MySQL Indexå‹‰å¼·ä¼šå¤–éƒ¨å…¬é–‹ç”¨
12. Â© CROOZ,Inc. 12 ï¼‘ï¼ŽINDEXã¨ã¯ãªã«ã‹ ä½•æžšç›®ãŒãªã«ã‹ã‚’äº‹å‰ã«ãƒ¡ãƒ¢ã£ã¦ãŠã‘ã°è‰¯ã„ï¼ ã‚¹ãƒ¼ãƒˆ ãƒ©ãƒ³ã‚¯ ä½ç½® ãƒãƒ¼ãƒˆ Q 1 ã‚¹ãƒšãƒ¼ãƒ‰ 9 2 : : : ãƒ€ã‚¤ãƒ¤ 1 40 : : : ã‚¹ãƒšãƒ¼ãƒ‰ 6 45 ãªãœãªã‚‰ã€è¦æ±‚ã¯ã€Œã‚«ãƒ¼ãƒ‰ã‚’å¼•ãå›žæ•°ã‚’æœ€ã‚‚å°‘ãªã ã—ã¦ã‚¹ãƒšãƒ¼ãƒ‰6ã‚’æŽ¢ã™ã“ã¨ã€ ã‚»ã‚³ã„ã¨ã‹ãŠã‚‚ã†ãƒ’ãƒˆã¯ã„ã‚‹ã‹ ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒä½•ã‚‚ã‚»ã‚³ã„ã“ ã¯ã—ã¦ã„ãªã„ã§ã™ã€‚ å‰ææ¡ä»¶ãªã©ä¸€åˆ‡ãªã„ã‹ã‚‰ ã“ã®ãƒ¡ãƒ¢ã•ãˆã‚ã‚Œã°ä½ç½®ã‚’æŒ‡å®šã—ã¦1å›žå¼•ã‘ã°æ¸ˆã‚€
Gln 2013/09/12
mysql

DB

database

performance

sql

slideshare
ãƒªãƒ³ã‚¯
SQLiteå…¥é–€
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã® SQLite ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLite ã¯ã‚µãƒ¼ãƒã¨ã—ã¦å‹•ä½œã•ã›ã‚‹ã®ã§ã¯ãªãå˜ç‹¬ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦å‹•ä½œã•ã›ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚ç°¡å˜ãªä¸Šã«éžå¸¸ã«ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆãªãŸã‚ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ä¸€ç·’ã«é…å¸ƒã™ã‚‹ã¨ã„ã£ãŸåˆ©ç”¨ã‚‚æ•°å¤šãã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã“ã§ã¯ SQLite ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆæ–¹æ³•ã€ãã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ãŸã‚Šå–å¾—ã—ãŸã‚Šã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ä¸€ã¤ä¸€ã¤è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚
Gln 2013/07/07
database

sqlite

sql

tutorial
ãƒªãƒ³ã‚¯
SQLAlchemy
The Python SQL Toolkit and Object Relational Mapper SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language. Documentation Curre
Gln 2013/07/07
database

object

python

SQLAlchemy
ãƒªãƒ³ã‚¯
ã€Œæ¼”ç®—åã®ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã¨ã€ŒSSJIã€
ã€Œæ¼”ç®—åã®ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã¨ã€ŒSSJIã€ï¼šNoSQLã‚’ä½¿ã†ãªã‚‰çŸ¥ã£ã¦ãŠããŸã„ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®è©±ï¼ˆ1ï¼‰ï¼ˆ1/2 ãƒšãƒ¼ã‚¸ï¼‰ ã“ã“æ•°å¹´ã€å¤§é‡ãƒ‡ãƒ¼ã‚¿å‡¦ç†æ™‚ã®é«˜é€Ÿæ€§ã‚„ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã®æŸ”è»Ÿæ€§ãªã©ã‹ã‚‰ã€ã€ŒNoSQLã€ãŒæ³¨ç›®ã‚’é›†ã‚ã¦ã„ã¾ã™ã€‚ãã‚Œã¨åŒæ™‚ã«ã€NoSQLã‚’ä½¿ã†ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾ã™ã‚‹æ”»æ’ƒæ‰‹æ³•ã‚‚ç ”ç©¶ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã“ã®è¨˜äº‹ã§ã¯ã€NoSQLã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ã¨å¯¾ç–ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ æ³¨ç›®é›†ã‚ã‚‹ã€ŒNoSQLã€ ã“ã“æ•°å¹´ã€NoSQLã¨å‘¼ã°ã‚Œã‚‹ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒæ³¨ç›®ã‚’é›†ã‚ã¦ã„ã¾ã™ã€‚NoSQLã¯SQLè¨€èªžã‚’ä½¿ç”¨ã—ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç·ç§°ã§ã€å¤§é‡ãƒ‡ãƒ¼ã‚¿å‡¦ç†æ™‚ã®é«˜é€Ÿæ€§ã‚„ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã®æŸ”è»Ÿæ€§ãªã©ã®ãƒ¡ãƒªãƒƒãƒˆãŒã‚ã‚‹ãŸã‚ã€å¾“æ¥ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆRDBï¼‰ã‚’è£œå®Œãƒ»ä»£æ›¿ã™ã‚‹ã‚‚ã®ã¨ã—ã¦ã€å¤§è¦æ¨¡ãªWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã©ã«ãŠã„ã¦NoSQLã‚’æŽ¡ç”¨ã™ã‚‹äº‹ä¾‹ãŒå¢—ãˆã¦ã„ã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªæ–°ã—ã„æŠ€è¡“ãŒæ™®åŠã—
Gln 2013/05/23
mongodb

nosql

database

db

security
ãƒªãƒ³ã‚¯
SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - é–‹ç™ºè€…ã‚’å¾…ã¡å—ã‘ã‚‹25ã®è½ã¨ã—ç©´ (æ‹¡å¤§ç‰ˆ)
14. SELECT c1.*, c2.*, c3.*, c4.* FROM Comments c1 -- 1éšŽå±¤ç›® LEFT OUTER JOIN Comments c2 ON c2.parent_id = c1.comment_id -- 2éšŽå±¤ç›® LEFT OUTER JOIN Comments c3 ON c3.parent_id = c2.comment_id -- 3éšŽå±¤ç›® LEFT OUTER JOIN Comments c4 ON c4.parent_id = c3.comment_id -- 4éšŽå±¤ç›® ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã«ã‚ˆã‚Šèµ·ã“ã‚‹ã“ã¨ ç´ æœ´ã™ãŽã‚‹æ•…ã« ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³
Gln 2013/04/22
database

db

sql

programming
ãƒªãƒ³ã‚¯
çµ„ã¿è¾¼ã¿åž‹ã‚°ãƒ©ãƒ•ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€Œneo4j 1.0ã€ã‚’è©¦ã—ã¦ã¿ã‚ˆã†
neo4jã¨ã¯ neo4jã¯Javaãƒ™ãƒ¼ã‚¹ã®çµ„ã¿è¾¼ã¿åž‹ã®ã‚°ãƒ©ãƒ•ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã§ã‚¹ã‚¦ã‚§ãƒ¼ãƒ‡ãƒ³ã®Neo Techno logyãŒæä¾›ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ ãªãŠã€neo4jã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ãŒã€ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯AGPLv3ã¨ãªã£ã¦ã„ã‚‹ã€‚ãã®ãŸã‚ã€neo4jã‚’ä½¿ç”¨ã—ã¦ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚µãƒ¼ãƒ“ã‚¹ãªã©ã‚’æ§‹ç¯‰ã—ãŸå ´åˆã‚‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’å…¬é–‹ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ã“ã‚Œã‚’å›žé¿ã™ã‚‹ãŸã‚ã®å•†ç”¨ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã€‚åˆ©ç”¨ã«ã‚ãŸã£ã¦ã¯æ³¨æ„ã—ã¦ã»ã—ã„ã€‚ neo4jã®æœ€æ–°ç‰ˆã¯2010å¹´2æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸ1.0ã¨ãªã£ã¦ã„ã‚‹ã€‚æœ¬ç¨¿ã§ã¯ã“ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹ã€‚ neo4jã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã‚ˆã‚Šneo4j-kernel-1.0-binary.zipã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã«å«ã¾ã‚Œã¦ã„ã‚‹neo4j-kernel-1.0.jarã¨geronimo-jta1.1spec-1.1.1.jarã‚’ã‚¯ãƒ©ã‚¹ãƒ‘ã‚¹ã«è¿½åŠ ã™
Gln 2013/04/19
neo4j

java

graph

db

database
ãƒªãƒ³ã‚¯
ã‚°ãƒ©ãƒ•åž‹NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆNeo4jã€InfiniteGraphï¼‰ç·¨
æ›¸ç±ç´¹ä»‹ æœ¬é€£è¼‰ã¯ä¸‹è¨˜æ›¸ç±ã‹ã‚‰ç¬¬5ç« ã‚’åŸºã«ã€ï¼ ITå‘ã‘ã«å†æ§‹æˆã—ã¦æŽ²è¼‰ã—ã¦ã„ã¾ã™ã€‚ ç›®æ¬¡ åº ç« ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã®æ™‚ä»£ ç¬¬1ç« NOSQLã¨ã¯ä½•ã‹? ç¬¬2ç« NOSQLã®ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« ç¬¬3ç« ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®åŸºæœ¬æ¦‚å¿µã¨æŠ€è¡“ ç¬¬4ç« Hadoopã¯NOSQL? ç¬¬5ç« ä¸»ãªNOSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ ç¬¬6ç« NOSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é¸æŠžåŸºæº– ç¬¬7ç« NOSQLã‚’ä½¿ã†ãƒ“ã‚¸ãƒã‚¹ æœ¬é€£è¼‰ã¯æ›¸ç±ã€ŽNOSQLã®åŸºç¤ŽçŸ¥è˜ã€ï¼ˆãƒªãƒƒã‚¯ãƒ†ãƒ¬ã‚³ãƒ åˆŠã€ISBNï¼š978-4897978871ï¼‰ã§è§£èª¬ã•ã‚Œã¦ã„ã‚‹å†…å®¹ã‹ã‚‰ä¸€éƒ¨ã‚’æŠœç²‹ã—ã€æœ¬é€£è¼‰å‘ã‘ã«ä¸€éƒ¨å†ç·¨é›†ã—ã¦æŽ²è¼‰ã—ãŸã‚‚ã®ã§ã™ã€‚ æ›¸ç±ã§ã¯ã€ä¸€èˆ¬ã«NoSQLã¨å‘¼ã°ã‚Œã¦ã„ã‚‹å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“ã«ã¤ã„ã¦ã€åŸºæœ¬æ¦‚å¿µã‹ã‚‰ä¸»è¦ãªãƒ—ãƒãƒ€ã‚¯ãƒˆã®ç‰¹æ€§ã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çµæžœã¾ã§ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã‚„ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®é•ã„ã¨ã„ã£ãŸåŸºæœ¬æ¦‚å¿µã‹ã‚‰ã€å„ãƒ—ãƒãƒ€ã‚¯ãƒˆã®ç‰¹å¾´ã‚’ç†è§£ã§ãã‚‹å†…å®¹ã«ãªã£ã¦ã„ã¾
Gln 2013/04/19
graph

db

database
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸