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

sirocco634 id:sirocco634

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

${{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 ã®ã‚«ãƒ©ãƒ ã§æŒ‡å®šå¯èƒ½ãªãƒ‡ãƒ¼ã‚¿åž‹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ æ ¼ç´ã•ã‚Œã‚‹å€¤ã®ãƒ‡ãƒ¼ã‚¿åž‹ å¤šãã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã‚«ãƒ©ãƒ æ¯Žã«ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã—ã¾ã™ã€‚ãã®ç‚ºã€ã‚«ãƒ©ãƒ æ¯Žã«æ ¼ç´ã§ãã‚‹å€¤ãŒæ±ºã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚SQLite ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å®šç¾©ã™ã‚‹æ™‚ã«ã‚«ãƒ©ãƒ æ¯Žã«ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã¯å¿…é ˆã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã—ãªã‹ã£ãŸã‚«ãƒ©ãƒ ã«ã¯è‰²ã€…ãªåž‹ã®å€¤ãŒæ ¼ç´ã•ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ãŸã ãƒ‡ãƒ¼ã‚¿åž‹ã‚’æŒ‡å®šã—ãªã‹ã£ãŸå ´åˆã§ã‚‚ã‚«ãƒ©ãƒ ã«æ ¼ç´ã•ã‚ŒãŸå€¤ãŒã©ã‚“ãªãƒ‡ãƒ¼ã‚¿åž‹ãªã®ã‹ã¯åŒºåˆ¥ã—ã¦ã„ã¦ã€ŒNULLã€ã€ŒINTEGERã€ã€ŒREALã€ã€ŒTEXTã€ã€ŒBLOBã€ã®5ç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿åž‹ã«åˆ†é¡žã—ã¾ã™ã€‚ NULL NULLå€¤ INTEGER ç¬¦å·ä»˜æ•´æ•°ã€‚1, 2, 3, 4, 6, or 8 ãƒã‚¤ãƒˆã§æ ¼ç´ R
sirocco634 2010/05/13
SQLiteã§åˆ©ç”¨å¯èƒ½ãªãƒ‡ãƒ¼ã‚¿åž‹

sqlite

sql
ãƒªãƒ³ã‚¯
Gaucheã‹ã‚‰SQLiteã‚’ä½¿ã† - ã†ã©ã‚“é§†å‹•é–‹ç™º
ã‚„ã£ã±RDBãŒä½¿ãˆã‚‹ã¨ä½•ã‹ã¨ä¾¿åˆ©ãªã®ã§ï¼ŒSQLiteã‚’ä½¿ã£ã¦ã¿ã‚‹ï¼Ž ã¾ãšã¯ï¼ŒGauche-dbd-sqlite3ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ï¼Žã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã¯ã‚°ã‚°ã£ã¦ãï¼Ž ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒçµ‚ã‚ã£ãŸã®ã§ï¼Œæ—©é€Ÿè©¦ã™ï¼Žã¾ãšã¯DBã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã—ã¦ã¿ã‚‹ï¼Ž (use dbi) (use util.relation) (defin conn (dbi-connect "dbi:sqlite3:/db/file/path.db"))dbiã¨util.relationã®2ã¤ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’useã—ã¦ï¼Œdbi-connectã§DBãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡å®šã—ã¦ã‚„ã‚‹ã ã‘ï¼ŽDBãƒ•ã‚¡ã‚¤ãƒ«ãŒãªã‹ã£ãŸã‚‰è‡ªå‹•çš„ã«ä½œã£ã¦ãã‚Œã‚‹ã¿ãŸã„ï¼Ž æ¬¡ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆï¼Ž (let* ((query (dbi-prepare conn "create table hoge (foo integer primary key, bar varchar(256))")))
sirocco634 2010/04/19
Gaucheã‹ã‚‰SQLiteã‚’ä½¿ã†ã‚ˆ

gauche

sqlite
ãƒªãƒ³ã‚¯
SQLiteå¯¾å¿œã‚¢ãƒ—ãƒªã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’CSVåŒ–ã™ã‚‹ï¼ˆ1ï¼‰ - builder by ZDNet Japan
å‰å›žã€SQLiteã‚’åˆ©ç”¨ã™ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«è“„ç©ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’é–²è¦§ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ãŸã€‚ä»Šå›žã¯ãã®ç¶šç·¨ã¨ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚’è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã§å†åˆ©ç”¨ã§ãã‚‹ã‚ˆã†å‡ºåŠ›ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹ã€‚ã“ã“ã§ã¯ã‚¢ãƒ‰ãƒ¬ã‚¹ãƒ–ãƒƒã‚¯ã®ãƒ‡ãƒ¼ã‚¿ï¼ˆ~/Library/Application Support/AddressBook/AddressBook-v22.abcddbï¼‰ã‚’ä½¿ç”¨ã™ã‚‹ãŒã€Mail.appãªã©ä»–ã®SQLiteä¾å˜ã‚¢ãƒ—ãƒªã«ç½®ãæ›ãˆã¦ã‚‚ã‹ã¾ã‚ãªã„ã€‚ ã»ã¼ã™ã¹ã¦ã®è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆãŒå¯¾å¿œã—ã¦ã„ã‚‹ã€Œã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã®ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã€ï¼ˆCSVãƒ•ã‚¡ã‚¤ãƒ«ï¼‰ã‚’ä¾‹ã«ã€èª¬æ˜Žã—ã¦ã¿ã‚ˆã†ã€‚ã¾ãšã¯ã€ã‚«ãƒ¬ãƒ³ãƒˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ã‚¢ãƒ‰ãƒ¬ã‚¹ãƒ–ãƒƒã‚¯ã®ä½œæ¥é ˜åŸŸã¸ç§»ã—ã€ãã“ã§sqlite3ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã„ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆAddressBook-v22.abcddbï¼‰ã‚’é–‹ãã€‚ãƒ—ãƒãƒ³ãƒ—ãƒˆãŒã€Œsqlite>ã€ã«å¤‰åŒ–ã—ã€å¯¾è©±ãƒ¢ãƒ¼ãƒ‰ãŒé–‹å§‹ã•ã‚Œã‚‹ã¯ãšã ã€‚ $ cd L
sirocco634 2010/02/21
Macã®Addressbookã‚‚sqliteã§é–‹ã‘ãŸã‚“ã ã€‚ç·¨é›†ã‚‚ã§ãã¡ã‚ƒã†ã®ã‹ãªï¼Ÿ

sqlite
ãƒªãƒ³ã‚¯
sqlite3ã®ä½¿ã„æ–¹ã¾ã¨ã‚ - /* Grid Thinking */
### ã‚·ã‚§ãƒ«ã‹ã‚‰ã‚³ãƒžãƒ³ãƒ‰ã®å®Ÿè¡Œ $ sqlite3 data.db ".tables" auth_group auth_user_groups auth_group_permissions auth_user_user_permissions auth_message django_content_type auth_permission django_session auth_user django_site-- ãƒãƒ¼ãƒ‰ã—ãŸDBãƒ•ã‚¡ã‚¤ãƒ« sqlite> .databases seq name file --- --------------- ---------------------------------------------------------- 0 main /home/roka/Dev/Django/tests/data.db -- ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ã®è¡¨ç¤º sqlite> .
sirocco634 2009/09/01
SQLiteã®ä½¿ã„æ–¹ã¾ã¨ã‚

sqlite

database

tutorial
ãƒªãƒ³ã‚¯
1