[B! sqlite] yasu_boyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yasu_boy id:yasu_boy

sqliteã«é–¢ã™ã‚‹yasu_boyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

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

sqlite

å…¥é–€

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
SQLiteã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
SQLite ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã‚’ä½¿ç”¨ã›ãšãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¯Žã«1ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½¿ã£ã¦ç®¡ç†ã—ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã¯ä½¿ç”¨ã—ãªã„ãŸã‚ã‚µãƒ¼ãƒã¨ã—ã¦å¸¸æ™‚ç¨¼å‹•ã•ã›ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã‚³ãƒžãƒ³ãƒ‰ã‹ã‚‰åˆ©ç”¨ã™ã‚‹ãŸã‚ã«ã¯ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½¿ã„ã€ PHP ã‚„ Ruby on Rails ãªã©ã‹ã‚‰åˆ©ç”¨ã™ã‚‹ã«ã¯ DLL ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ã“ã“ã§ã¯ SQLite ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ—ãƒã‚°ãƒ©ãƒ ã¨ DLL ã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰æ–¹æ³•åŠã³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚
yasu_boy 2010/12/16
å‚è€ƒ

sqlite

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
ninnin.net blog: FTPã‚¢ã‚¯ã‚»ã‚¹ã®ã¿ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã§SQLiteã‚’ä½¿ã†
FTPã‚¢ã‚¯ã‚»ã‚¹ã®ã¿ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã§SQLiteã‚’ä½¿ã† ä»•äº‹ã®è¦æ¨¡çš„ã«ã€ã©ã†ã—ã¦ã‚‚ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã‚’ä½¿ã†ã“ã¨ãŒå¤šã„ã€‚ ã‚€ã‚ã‚“å°‚ç”¨ã‚µãƒ¼ãƒã¯é«˜ãã¦ä½¿ãˆãªã„ã€‚ è‡ªå‰ã‚µãƒ¼ãƒã«ç›¸ä¹—ã‚Šã—ã¦ã‚‚è‰¯ã„ã®ã ãŒã€æœ€è¿‘ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã¯æœˆ500å††ã€œ1500ç¨‹åº¦ã§ååˆ†ãªã‚‚ã®ãŒå€Ÿã‚Šã‚‰ã‚Œã€è‡ªå‰ã‚µãƒ¼ãƒã«æ¯”ã¹ã‚Œã°ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£çš„ã«ã‚‚å®‰å¿ƒæ„ŸãŒã‚ã‚‹ã€‚ MySQLã‚„PostgreSQLãŒä½¿ãˆã‚‹ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒã‚‚å¢—ãˆã¦ããŸãŒã€ã‚ªãƒ—ã‚·ãƒ§ãƒ³æ–™é‡‘ãŒã‹ã‹ã‚‹ã“ã¨ãŒå¤šã„ã€‚ ç¾åœ¨åˆ©ç”¨ã—ã¦ã„ã‚‹FTPæ“ä½œã®ã¿ã®ãƒ—ãƒãƒã‚¤ãƒ€ã§å¼·å¼•ã«SQLiteã‚’å‹•ã‹ã—ã¦ã¿ã‚‹ã“ã¨ã«ã—ãŸã€‚ SQLiteã‚’åˆ©ç”¨ã™ã‚‹ç†ç”±ã¯ãƒ—ãƒã‚»ã‚¹ãŒä¸ŠãŒã‚‰ãªã„ã‚¿ã‚¤ãƒ—ã®DBã§ã‚ã‚‹ã“ã¨ã€DBå†…å®¹ã¯ãƒ•ã‚¡ã‚¤ãƒ«ã«è½ã¡ã‚‹ã®ã§ã€FTPã®ã¿ã§ã‚‚ç®¡ç†ã—ã‚„ã™ã„ã“ã¨ãªã©ã§ã‚ã‚‹ã€‚ ã¾ãšã¯ä¸‹æº–å‚™ã‚’è¡Œã†ã€‚ æ›¸ãè¾¼ã¿å¯èƒ½ï¼ˆ777ï¼‰ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ç”¨æ„ã€ã“ã“ã§ã¯workã¨ã„ã†åå‰ã«ã™ã‚‹ã€‚ <?php system("/
yasu_boy 2010/12/16
ã“ã‚Œè¦‹ã¦ã‚„ã£ã¦ã¿ã‚Œã°ã„ã„ã®ã‹ãªï¼Ÿ

sqlite

ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒ

PHP
ãƒªãƒ³ã‚¯
MOONGIFT: Â» SQLiteã‚’GUIã§ç®¡ç†ã€ŒSQLite Database Browserã€:ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’æ¯Žæ—¥ç´¹ä»‹
SQLiteã¯DLLãƒ•ã‚¡ã‚¤ãƒ«ã ã‘ã§ã™ãã«åˆ©ç”¨ã§ãã‚‹ç°¡æ˜“çš„ãªDBã§ã¯ã‚ã‚‹ãŒã€æ€ã£ã¦ã„ã‚‹ã‚ˆã‚Šã‚‚ã—ã£ã‹ã‚Šã¨å‹•ä½œã—ã¦ãã‚Œã‚‹ã€‚ ä»–ã®DBã®ã‚ˆã†ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚æ‰‹é–“ã‚‚ãªãã™ãã«åˆ©ç”¨ã§ãã‚‹ã®ãŒä¾¿åˆ©ã ã€‚æœ€è¿‘ã¯PHP5ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒã‚‚å¢—ãˆãŸã®ã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¢ãƒƒãƒ—ã™ã‚‹ã ã‘ã§ã™ãã«åˆ©ç”¨ã§ãã‚‹ã¨ã„ã†ã®ã‚‚æ‰‹è»½ã§ã„ã„ã€‚ ãã‚“ãªSQLiteã§ã‚ã‚‹ãŒã€ç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã¯æ¨™æº–ã§ã¯ç”¨æ„ã•ã‚Œã¦ã„ãªã„ã€‚æ™®åŠã®ãŸã‚ã«ã¯é«˜æ©Ÿèƒ½ã€ã‹ã¤æ‰‹è»½ãªç®¡ç†ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã®å˜åœ¨ã¯æ¬ ã‹ã›ãªã„ã ã‚ã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯SQLite Database Browserã€SQLiteã‚’GUIã§æ“ä½œã§ãã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ SQLite Database Browserã‚’ä½¿ã†ã¨ã€GUIãƒ™ãƒ¼ã‚¹ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆã¯ã‚‚ã¡ã‚ã‚“ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¨è¨ˆã‚„ãƒ‡ãƒ¼ã‚¿ã®ç·¨é›†ãŒã§ãã‚‹ã€‚SQLã‚’å®Ÿè¡Œã—ã¦çµæžœã‚’è¦‹ã‚‹ã“ã¨ã‚‚å¯èƒ½ã ã€‚ã‚‚ã¡ã‚ã‚“ã€æ—¥æœ¬èªžã«å¯¾å¿œ
yasu_boy 2010/12/16
SQLiteã¯DLLãƒ•ã‚¡ã‚¤ãƒ«ã ã‘ã§ã™ãã«åˆ©ç”¨ã§ãã‚‹ç°¡æ˜“çš„ãªDBã€‚

sqlite

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
SQLite ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ»ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨å®Ÿè¡Œ (Windows ã®å ´åˆ)
SQLite ã¯ï¼Œãƒ‘ãƒ–ãƒªãƒƒã‚¯ãƒ‰ãƒ¡ã‚¤ãƒ³ã®çµ„ã¿è¾¼ã¿åž‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã§ã™ï¼Ž ã“ã® Web ãƒšãƒ¼ã‚¸ã§ã¯ï¼ŒSQLite ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ»ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨å®Ÿè¡Œã‚’è¡Œã„ã¾ã™ï¼Ž SQLite ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ»ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®ä¸ã«ã™ã§ã« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ãŒçµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã¾ã™ï¼Ž SQLite ã®åˆ©ç‚¹ã‚’å¤§èƒ†ã«ã¾ã¨ã‚ã‚‹ã¨ï¼Œ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆï¼ˆãƒ¦ãƒ¼ã‚¶åã‚„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ï¼‰ æ¨©é™ ã®ã“ã¨ã‚’è€ƒãˆãªãã¦ã‚‚ä½¿ãˆã¾ã™ï¼Žé€šä¿¡ã—ã¾ã›ã‚“ã®ã§ï¼Œãƒ•ã‚¡ã‚¤ãƒ¤ã‚¦ã‚ªãƒ¼ãƒ«ï¼ˆä¾‹ãˆã° Windows ã®ãƒ•ã‚¡ã‚¤ãƒ¤ã‚¦ã‚ªãƒ¼ãƒ«ï¼‰ã®è¨å®šã§æ‚©ã‚€ã“ã¨ã‚‚ãªã„ã§ã—ã‚‡ã†ï¼Žä»¥ä¸ŠãŒåˆ©ç‚¹ã§ã™ï¼Ž ãƒªãƒ¢ãƒ¼ãƒˆã‹ã‚‰ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯è¶Šã—ã§æŽ¥ç¶šã™ã‚‹æ©Ÿèƒ½ã¯ã‚ã‚Šã¾ã›ã‚“ï¼ˆãã®ã¯ãšã§ã™ï¼‰ï¼Ž è¤‡æ•°ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å…±æœ‰ã™ã‚‹ãŸã‚ã®æ©Ÿèƒ½ã‚‚ã‚ã‚Šã¾ã›ã‚“ï¼Žï¼ˆã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ»ã‚µãƒ¼ãƒãƒ»ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨ã„ã†è€ƒãˆæ–¹ã‚’ã¨ã£ã¦ã„ã¾ã›ã‚“ï¼‰ï¼Ž â€» å‹‰å¼·ç”¨ã¨ã—ã¦ã¿ã‚‹ã¨ï¼š
yasu_boy 2010/12/16
ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

sqlite

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
SQLite ControlCenter æ—¥æœ¬èªžç‰ˆ
SQL C Library ã® SQLite ã® DB ã‚’ GUI ã§å‚ç…§ã§ãã‚‹ãƒ„ãƒ¼ãƒ« SQLiteCC (SQLite Control Center) ã‚’æ—¥æœ¬èªžåŒ–ã—ãŸã‚‚ã®ã§ã™ï¼Žæœ¬å®¶ã® SQLiteCC ã§ã¯å¯¾å¿œã—ã¦ã„ãªã„ SQLite3 ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚æ‰±ãˆã¾ã™ï¼Ž æœ¬å®¶ SQLiteCC ã®ç‰¹å¾´ æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆï¼Œæ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã®ä½œæˆãŒå¯èƒ½ è¡¨ãƒ‡ãƒ¼ã‚¿ï¼Œãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ï¼Œã‚¹ã‚ãƒ¼ãƒžï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼Œãƒˆãƒªã‚¬ãƒ¼ã‚’å‚ç…§å¯èƒ½ ã‚°ãƒªãƒƒãƒ‰ä¸Šã§è¡¨ãƒ‡ãƒ¼ã‚¿ã‚’ç·¨é›†å¯èƒ½ æ–‡æ³•è§£æžã«ã‚ˆã‚‹ãƒã‚¤ãƒ©ã‚¤ãƒˆå¯èƒ½ãªã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼æè¼‰ æ—¥æœ¬èªžç‰ˆã®ç‰¹å¾´ æ—¥æœ¬èªžè¡¨ç¤ºã§ãã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ è¡¨ã«æ—¥æœ¬èªž (UTF-8/Shift-JIS) ãŒè¡¨ç¤ºã§ãï¼Œè¡¨ã§ç›´æŽ¥å¤‰æ›´ã™ã‚‹éƒ¨åˆ†ã‚‚æ—¥æœ¬èªžãŒé€šã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ ã‚¯ã‚¨ãƒªãƒ¼éƒ¨ã«ã‚‚æ—¥æœ¬èªžãŒä½¿ãˆã¾ã™ï¼Ž SQLiteCC3 ç³»ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚æ“ä½œå¯èƒ½ï¼Ž ã‚°ãƒªãƒƒãƒ‰ã‚„ã‚¨ãƒ‡ã‚£ã‚¿éƒ¨ã®ãƒ•ã‚©
yasu_boy 2010/12/16
SQLite ã® DB ã‚’ï¼§ï¼µï¼©ã§ã„ã˜ã‚Œã‚‹ã‚½ãƒ•ãƒˆã£ã¦ã“ã¨ï¼Ÿ

sqlite

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

software
ãƒªãƒ³ã‚¯
http://www.cpa-lab.com/tech/046
yasu_boy 2010/12/16
phpã®SQLiteã‚’ä½¿ã†ã¨mysqlãªã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒä½¿ãˆãªã„æ‰€ã§ã‚‚ã€ãã‚Œã£ã½ã„ã‚‚ã®ãŒä½¿ãˆã‚‹ã¨ã„ã†ã“ã¨ã‹ãªã€€ã„ã„ãªã“ã‚Œ

mysql

ã‚µãƒ¼ãƒ

ãƒ‡ãƒ¼ã‚¿

sqlite
ãƒªãƒ³ã‚¯
1