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

fjwr38 id:fjwr38

databaseã«é–¢ã™ã‚‹fjwr38ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

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

LevelDBå…¥é–€ (åŸºæœ¬ç·¨) - from scratch
ã•ã¦ã€ä»Šå›žã¯æ¯”è¼ƒçš„æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã§ã‚ã‚‹LevelDBã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ LevelDBã¯1å¹´ã»ã©å‰ã‹ã‚‰Node.jsç•Œéšˆã§ã¯ãƒ–ãƒ¼ãƒ ãŒæ¥ã¦ã„ã¦ã€ç†ç”±ãŒã‚ˆãã‚ã‹ã£ã¦ã„ãªã‹ã£ãŸã‚“ã§ã™ãŒã€ã¾ã¨ã‚ã¦ã„ã‚‹å†…ã«åˆ†ã‹ã‚‹ã‹ãªã¨æ€ã£ã¦ã¾ã¨ã‚ã¾ã—ãŸã€‚ä»Šå›žã¯Node.jsç„¡é–¢ä¿‚ã§LevelDBã®åŸºç¤Žçš„ãªã“ã¨ã ã‘èª¿æŸ»ã—ãŸçµæžœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ Node.jsã§ä½¿ã£ã¦ã¿ã‚‹è©±ã¯å¾Œã«å›žã—ã¾ã™ã€‚ LevelDBã¨ã¯? key-valueåž‹ã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ä¸€ã¤ã§ã™ã€‚ Googleã®ç ”ç©¶è€…ã§ã‚ã‚‹ã€Jeff Deanã¨Sanjey GhemawatãŒé–‹ç™ºã—ã€2011å¹´ã«å…¬è¡¨ã•ã‚Œã¾ã—ãŸã€‚C++ã§æ›¸ã‹ã‚Œã¦ãŠã‚Šã€å¤šãã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§bindingsãŒæ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ã‚‚ã¡ã‚ã‚“ã€JavaScript/Node.jsã§ã‚‚æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ LevelDB ã¯ Google ã®BigTableã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’æŒ
fjwr38 2014/05/05
node.js

database
ãƒªãƒ³ã‚¯
Amazon.co.jp: MySQLã«ã‚ˆã‚‹ã‚¿ãƒ•ãªã‚µã‚¤ãƒˆã®ä½œã‚Šæ–¹: ä½è—¤çœŸäºº, æ¡‘é‡Žç« å¼˜, å²¡ç”°é”å…¸, å¤§é»’åœç¥: æœ¬
fjwr38 2014/01/08
ã„ã„ã»ã‚“ã‚‰ã—ã„

MySQL

database
ãƒªãƒ³ã‚¯
VoltDB - Wikipedia
VoltDBã¯Ingresã‚„PostgreSQLã«æºã‚ã£ãŸãƒžã‚¤ã‚±ãƒ«ãƒ»ã‚¹ãƒˆãƒ¼ãƒ³ãƒ–ãƒ¬ãƒ¼ã‚«ãƒ¼ã«ã‚ˆã‚Šè¨è¨ˆã•ã‚ŒãŸã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ã€‚ACIDã«æº–æ‹ ã—ãŸé–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã§ã‚ã‚Šã€ã‚·ã‚§ã‚¢ãƒ¼ãƒ‰ãƒ»ãƒŠãƒƒã‚·ãƒ³ã‚°ãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«ã‚ˆã‚‹ã‚‚ã®ã§ã‚ã‚‹ã€‚GPL ãƒãƒ¼ã‚¸ãƒ§ãƒ³3ã®ã‚‚ã¨ã§ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ã‚‹ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã‚ã‚‹ã€‚VoltDBã¯å¦è¡“çš„ãªH-Storeãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’åŸºç¤Žã¨ã—ã¦ã„ã‚‹ã€‚[2] VoltDBã¯é–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚Šã€ãƒ—ãƒªã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã•ã‚ŒãŸJavaã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‹ã‚‰ã®SQLã‚¢ã‚¯ã‚»ã‚¹ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ã€‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®å˜ä½ã¯ã‚¹ãƒˆã‚¢ãƒ¼ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§ã‚ã‚Šã€ã“ã‚Œã¯SQLã¨JavaãŒæ··åˆã•ã‚ŒãŸã‚‚ã®ã§ã‚ã‚‹ã€‚VoltDBã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã«å€‹ã€…ã®ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã«ãŠã‘ã‚‹ã‚¹ãƒ¬ãƒƒãƒ‰ã§ã®æ°´å¹³ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã‚’åˆ©ç”¨ã—ã€å …ç‰¢æ€§ã®ãŸã‚ã«k-safety(åŒæœŸçš„ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³)ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã€‚ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒ
fjwr38 2013/12/12
database
ãƒªãƒ³ã‚¯
SQLite3ã‚’ä½¿ç”¨ã™ã‚‹ - Python Tips
è»½é‡ãƒ»é«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹SQLiteã‚’Pythonã‹ã‚‰æ‰±ã†ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Python2.5ã‹ã‚‰æ¨™æº–ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«å…¥ã‚Šã¾ã—ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä½œæ¥ã¯ä¸è¦ã§ã™ã€‚ ä½¿ç”¨æ–¹æ³• sqlite3ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ #!python2.6 # -*- coding: utf-8 -*- import sqlite3 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ con = sqlite3.connect("data.db") ãƒ•ã‚¡ã‚¤ãƒ«ãŒã™ã§ã«å˜åœ¨ã™ã‚‹ã¨ãã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ãŒãªã„ã¨ãã¯æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ã€‚ isolation_levelã«Noneã‚’æŒ‡å®šã™ã‚‹ã¨ã€è‡ªå‹•ã‚³ãƒŸãƒƒãƒˆãƒ¢ãƒ¼ãƒ‰ã«ãªã‚Šã¾ã™ã€‚ con = sqlite3.connect('temp.db', isolation_level=None) ç‰¹åˆ¥ãªåå‰ã§ã‚ã‚‹ ":memory:" ã‚’ä½¿ã†ã¨RAMä¸Šã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ c
fjwr38 2012/07/06
sqlite

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

db

database

python
ãƒªãƒ³ã‚¯
Androidã§ä½¿ãˆã‚‹OR Mapper: ORMLite Â« NAVER Engineers' Blog
ã“ã‚“ã«ã¡ã¯ã€‚é–‹ç™ºãƒãƒ¼ãƒ ã®é§’æ´¥ã§ã™ã€‚ ã“ã“åŠå¹´ã»ã©ã€å¼Šç¤¾ã‚¢ãƒ—ãƒªLINEã®Androidç‰ˆã‚’é–‹ç™ºã—ã¦ã„ã¾ã™ã€‚é–¢ä¿‚è€…ä¸€åŒã®é ‘å¼µã‚Šã‚‚ã‚ã£ã¦Androidãƒ¦ãƒ¼ã‚¶ãƒ¼ 100ä¸‡äººé”æˆã¨ã„ã†éžå¸¸ã«ã†ã‚Œã—ã„çŠ¶æ³ãªã®ã§ã™ãŒã€ã‹ãªã‚Šã®ãƒã‚¤ã‚¹ãƒ”ãƒ¼ãƒ‰ã§é–‹ç™ºãŒé€²ã¿ã¾ã—ãŸã®ã§ã‚ã¾ã‚Šå†’é™ºã›ãšã«ã€åŠ›æŠ€ã§å°‘ã—æ³¥è‡ãå®Ÿè£…ã—ã¦ã„ã‚‹ç®‡æ‰€ã‚‚ã‚ã‚Šã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‘¨ã‚Šã‚‚æ™®é€šã«SQLite DatabaseçµŒç”±ã§SQLæ–‡ã‚’æ›¸ã„ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã§ãã‚Œã°OR Mapperã‚’ä½¿ã„ãŸã‹ã£ãŸâ€¦ ã¨ã„ã†åçœç‚¹ãŒã‚ã‚Šã€ç¾åœ¨é–‹ç™ºçŠ¶æ³ãŒå°‘ã—è½ã¡ç€ã„ãŸ (ã®ã‹â€¦? æœ¬å½“ã«â€¦?) ä»Šã®ã†ã¡ã«ãã£ã¡æ–¹é¢ã‚’èª¿ã¹ã¦ãŠã“ã†ã‹ã¨æ€ã„ã¾ã™ã€‚ Androidã§ã¯ãã®ã‚¹ãƒšãƒƒã‚¯ã®éƒ½åˆä¸Š, è»½ãå‹•ä½œã™ã‚‹OR MapperãŒå‘ã„ã¦ã„ãã†ã§ã™ã€‚ãã†ã„ã†è¦–ç‚¹ã§è‰²ã€…æŽ¢ã—ã¦è¦‹ãŸã¨ã“ã‚ORMLiteãŒè‰¯ã•ãã†ãªæ°—ãŒã—ã¾ã—ãŸã€‚æ£å¼ã«Androidã«å¯¾å¿œã—ã¦ã„ã‚‹ã¨è¬³ã£ã¦ã„ã‚‹ã®ã‚‚å¬‰ã—ã„ã¨ã“ã‚ã€‚
fjwr38 2012/06/14
database

Android

ORMLite

Androidé–‹ç™º
ãƒªãƒ³ã‚¯
MySQLã‚’ã•ã‚‰ã«ç†è§£ã™ã‚‹ãŸã‚ã«èªã‚“ã è¨˜äº‹ã¾ã¨ã‚ - $shibayu36->blog;
æœ€è¿‘MySQLã®å‹‰å¼·ã‚’ã—ã¦ã„ã¾ã—ãŸã€‚å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQLã‚’èªã‚€ã¹ãã¨ã„ã†è©±ã‚’èžã„ã¦ã„ãŸã®ã§ã™ãŒã€ã‹ãªã‚Šç¶²ç¾…çš„ã«æ›¸ã‹ã‚Œã¦ã„ã¦ã€ä»Šã®çŸ¥è˜ã§ã¯ã©ã‚ŒãŒé‡è¦ãªã®ã‹ã‚ã‹ã‚‰ãªã„çŠ¶æ…‹ã§ã—ãŸã€‚ãã“ã§è‰²ã€…èª¿ã¹ã¦ã¿ã¦ã€å‚è€ƒã«ãªã‚‹è¨˜äº‹ã‚’ã„ãã¤ã‹è¦‹ã¤ã‘ãŸã®ã§ã€å°‘ã—ã¾ã¨ã‚ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¾ã¨ã‚ãŸè¨˜äº‹ã‚’èªã‚“ã§ã€å¤§ä½“ä»¥ä¸‹ã®ã“ã¨ãŒç†è§£ã§ãã¾ã—ãŸã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ã‚ã‚Œæ–¹ã¨ãã®æ§‹é€ (MyISAMã¨InnoDB) EXPLAINã®è©³ã—ã„ä½¿ã„æ–¹ã€è¦‹æ–¹ InnoDBã®ç‰¹æ€§ ALTER TABLEã®ç‰¹æ€§ ãƒ¬ãƒ—ãƒªé…å»¶ ã¾ãšæœ€åˆã« Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã® ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŠ€è¡“[å®Ÿè·µ]å…¥é–€ (Software Design plus)posted with amazlet at 12.06.02æ¾ä¿¡ å˜‰ç¯„ æŠ€è¡“è©•è«–ç¤¾ å£²ã‚Šä¸Šã’ãƒ©ãƒ³ã‚ãƒ³ã‚°: 9767 Amazon.co.jp ã§è©³ç´°ã‚’è¦‹ã‚‹ æ¾ä¿¡ã•ã‚“ã®æ›¸ã„ãŸã€ŒWebã‚¨ãƒ³ã‚¸
fjwr38 2012/06/03
MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DataBase

tips
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹
1. åˆå¿ƒè€…å‘ã‘ MySQLã®å§‹ã‚æ–¹ MySQL Beginners Talk ã¨ã¿ãŸã¾ã•ã²ã‚ 2012-05-29 åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹ - MySQL Beginners Talk Powered by Rabbit 1.0.6 2. è‡ªå·±ç´¹ä»‹ âœ“ ã¨ã¿ãŸã¾ã•ã²ã‚ âœ“ MySQLãƒ¦ãƒ¼ã‚¶ä¼š(ä»£è¡¨) âœ“ id:tmtms âœ“ @tmtms âœ“ Rubyã‹ã‚‰MySQLã‚’ä½¿ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªæ›¸ã„ãŸã‚Š 1/80 åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹ - MySQL Beginners Talk Powered by Rabbit 1.0.6
fjwr38 2012/05/30
MySQL

db

database

mysql
ãƒªãƒ³ã‚¯
Androidã‚¢ãƒ—ãƒªã«ãŠã‘ã‚‹DBãƒ•ã‚¡ã‚¤ãƒ«ã®æ£ã—ã„ä½¿ã„æ–¹
ã¯ã˜ã‚ã« Androidã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã™ã‚‹ä¸Šã§SQLiteã‚’ä½¿ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†ã“ã¨ã¯å¤šã€…ã‚ã‚Šã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã®æ°¸ç¶šåŒ–ã‚„æ¤œç´¢ã¨ã„ã£ãŸå‡¦ç†ã‚’å®¹æ˜“ã«å®Ÿè£…ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§ã€å¤šãã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ä½¿ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ã—ã‹ã—ã€Androidã«ã¯SQLiteã‚’ä½¿ç”¨ã™ã‚‹ãŸã‚ã®æ–¹æ³•ãŒä»¥ä¸‹ã®ã‚ˆã†ã«ã„ãã¤ã‹ç”¨æ„ã•ã‚Œã€ãã‚Œãžã‚Œãƒ•ã‚¡ã‚¤ãƒ«ä½œæˆæ™‚ã®ãƒ‘ãƒ¼ãƒŸãƒƒã‚·ãƒ§ãƒ³ã®æŒ™å‹•ãŒç•°ãªã£ã¦ã„ã¾ã™ã€‚ SQLite Database#openOrCreateDatabaseã‚’ä½¿ç”¨ã—ã¦ä½œæˆã™ã‚‹ Context#openOrCreateDatabaseã‚’ä½¿ç”¨ã—ã¦ä½œæˆã™ã‚‹ SQLiteOpenHelperã‚¯ãƒ©ã‚¹ã‚’ä½¿ç”¨ã—ã¦ä½œæˆã™ã‚‹ ã‚‚ã—ã€é–‹ç™ºè€…ãŒã“ã‚Œã‚‰æ–¹æ³•ã®æŒ™å‹•ã‚’ååˆ†ã«ç†è§£ã—ã¦ã„ãªã„å ´åˆã€çŸ¥ã‚‰ãšã®ã†ã¡ã«è„†å¼±æ€§ã‚’ä½œã‚Šè¾¼ã‚“ã§ã—ã¾ã„ã¾ã™ã€‚ å®Ÿéš›ã«ã€ã„ãã¤ã‹ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯SQLite Database#openOrCreateDa
fjwr38 2012/05/09
db

sqlite

Android

programming

database

SQLite
ãƒªãƒ³ã‚¯
1