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

hdw id:hdw

sqliteã«é–¢ã™ã‚‹hdwã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

Tonny Xu - SQLiteã‚’ç”¨ã„ã¦ã€iOSã§é«˜é€Ÿå…¨æ–‡æ¤œç´¢ã‚’ã—ã‚ˆã†
ã¾ãˆãŒã ã‚ã‚‹æ—¥çªç„¶Twitterã§@TeamMOSA2ã•ã‚“ãŒ@glassonion1ã•ã‚“ã®ã¤ã¶ã‚„ãã‚’ãƒªãƒ„ã‚¤ãƒƒãƒˆã—ã¦ãã‚Œã¾ã—ãŸã€‚ãªã‚“ã‹é¢ç™½ãã†ãªã‚¤ãƒ™ãƒ³ãƒˆã ãªã¨æ€ã£ã¦ã€ ã™ãã«ATNDã«å‚åŠ ã—ã¾ã—ãŸã€‚æ™‚æœŸãŒæ—©ã‹ã£ãŸï¼6äººç›®ã«ãªã£ã¦ã€è‡ªå‹•çš„ã«12æœˆ6æ—¥ã®æ‹…å½“ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ã—ã‹ã—ã€è£½ä½œä¸ã®tuneTVã®æ–°ã—ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒã‚µãƒ–ãƒŸãƒƒãƒˆäºˆå®šæ—¥è¾ºã‚Šãªã®ã§ã€ç„¡ç†ã‚„ã‚Šã«@glassonion1ã«ãŠé¡˜ã„ã—ã¦ã€12æœˆ12æ—¥ã«ãƒªã‚¹ã‚±ã—ã¦é ‚ãã¾ã—ãŸã€‚æœ¬å½“ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ å‰å›žã¯@happy_ryoã•ã‚“ã®è¨˜äº‹ï¼šXCodeã‹ã‚‰appCodeã¸ä¹—ã‚Šæ›ãˆã‚‹8ã¤ã®ç†ç”±ã§ã—ãŸã€‚é¢ç™½ã„è¨˜äº‹ã®ã§ã€ãœã²ã”è¦§ãã ã•ã„ã€‚ ã•ã¦ã€ä»Šå›žåƒ•ã®è¨˜äº‹ã¯SQLiteã‚’ä½¿ã£ã¦ã€å…¨æ–‡æ¤œç´¢ã‚’ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã£ã¦ã„ã¾ã™ã€‚çš†ã•ã‚“ã«å°‘ã—å½¹ã«ç«‹ã¦ã°ã¨æ€ã„ã¾ã™ã€‚ ãˆã‡ï¼ŸSQLiteã‚’ä½¿ã£ã¦å…¨æ–‡æ¤œç´¢ãŒã§ãã‚‹ã®ï¼Ÿ SQLiteãŒFTSã‚’ã‚µãƒãƒ¼ãƒˆ
hdw 2011/12/17
iOS

SQLite

Programming

å…¨æ–‡æ¤œç´¢
ãƒªãƒ³ã‚¯
FreeBSDä¸Šã§Redmineã‚’è©¦ã—ã¦ã¿ã‚‹ - FileMakerã¨PHPã®ãƒ¡ãƒ¢
2ãƒ¶æœˆã»ã©Tracã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸãŒã€1ã¤ã®ã‚µã‚¤ãƒˆã§1ã¤ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã—ã‹åŸºæœ¬çš„ã«ç®¡ç†ã§ããªã„ã¨ã„ã†ã¨ã“ã‚ãŒã©ã†ã—ã¦ã‚‚ä½¿ã„ã¥ã‚‰ã‹ã£ãŸã§ã™ã€‚ä»£ã‚ã‚Šã«ãªã‚‹ã‚‚ã®ã‚’æŽ¢ã—ã¦ã„ãŸã¨ã“ã‚ã€Redmineã¨ã„ã†ã®ãŒè¤‡æ•°ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ç®¡ç†ã§ãã‚‹ã¨ã„ã†ãã†ãªã®ã§è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ Redmineã¯Jean-Philippe Langæ°ã«ã‚ˆã£ã¦é–‹ç™ºãƒ»å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚RoRã§æ§‹ç¯‰ã•ã‚Œã¦ãŠã‚Šã€è¤‡æ•°ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ç®¡ç†ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ãŒç‰¹å¾´ã§ã™ã€‚ç¾åœ¨ã®Redmineã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯4æœˆ28æ—¥(ãƒ•ãƒ©ãƒ³ã‚¹æ™‚é–“)ã«å…¬é–‹ã•ã‚ŒãŸv0.7.0ã§ã€GNU GENERAL PUBLIC LICENSE Version 2ã®ã‚‚ã¨ã§å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ å®Ÿè¡Œç’°å¢ƒã¯æ¬¡ã®ã¨ãŠã‚Šã§ã™ã€‚ FreeBSD 8.0-CURRENT : Fri Apr 21 11:55:00 JST 2008 (i386) Apache-2
hdw 2011/11/19
Redmine

sqlite
ãƒªãƒ³ã‚¯
SQLite Copyright
hdw 2007/12/12
"SQLite is in the Public Domain"

SQLite

Copyright
ãƒªãƒ³ã‚¯
ã¤ã‚†ã ãã®SQLite
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ SQLiteã‚’ã¯ã˜ã‚ã‚ˆã† ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« http://www.sqlite.org/ã®downloadã®ãƒªãƒ³ã‚¯ã‹ã‚‰æœ€æ–°ç‰ˆã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚ãƒã‚¤ãƒŠãƒªãƒ¼ç‰ˆã¯Linux ã¨Windowsç”¨ãŒã‚ã‚Šã¾ã™ã€‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã®æ–¹ã¯ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã ã‘ã§å¤§ä¸ˆå¤«ã§ã™ã€‚ $ ./configure; make; make install DBä½œæˆ sqlite3ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ã§ä½œæˆã€‚ä½œã‚ŠãŸã„DBã‚’å¼•æ•°ã«æŒ‡å®šã™ã‚‹ã ã‘ã§ä½œæˆãŒã§ãã‚‹ã€‚ã¾ãŸã€ã™ã§ã«å˜åœ¨ã™ã‚‹DBåã‚’æŒ‡å®šã—ãŸå ´åˆã¯ãã®DBã«æŽ¥ç¶šã‚’ã™ã‚‹ã€‚ $ sqlite3 test.db # "test.db"ã¨ã„ã†DBã‚’ä½œæˆ SQLite version 3.3.6 Enter ".help" for instructions sqlite> create table t1(i int, t text); sqlite> insert int
hdw 2007/11/17
sqlite

db
ãƒªãƒ³ã‚¯
sqlite: SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ä¼šè©±ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ
sqlite: SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ (This page was last modified on 2003/06/29 16:11:13 UTC) SQLite ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ã¯ sqlite ã¨ã„ã†ã‚·ãƒ³ãƒ—ãƒ«ãªã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ãŒå«ã¾ã‚Œã¾ã™ã€‚ã“ã‚Œã‚’ä½¿ã†ã¨ã€ãƒ¦ãƒ¼ã‚¶ã¯æ‰‹ä½œæ¥ã§ SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ã¦ SQL ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚ã“ã®æ–‡æ›¸ã§ã¯ sqlite ã®ä½¿ã„æ–¹ã«é–¢ã™ã‚‹æ¦‚ç•¥ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ èµ·å‹•ã™ã‚‹ sqlite ã‚’èµ·å‹•ã™ã‚‹ã«ã¯å˜ã« "sqlite" ã¨ã‚¿ã‚¤ãƒ—ã—ã€ãã®å¾Œã‚ã« SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¿æŒã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«åã‚’ä»˜ã‘ã¾ã™ã€‚ãƒ•ã‚¡ã‚¤ãƒ«ãŒå˜åœ¨ ã—ãªã„å ´åˆã¯ã€è‡ªå‹•çš„ã«æ–°ã—ãä½œã‚‰ã‚Œã¾ã™ã€‚èµ·å‹•å¾Œ sqlite ãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã€SQL ã‚’ã‚¿ã‚¤ãƒ—ã™ã‚‹ãŸã‚ã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆï¼ˆçµ‚äº†ã¯ã‚»ãƒŸã‚³ãƒãƒ³ï¼‰ã‚’ã‚¿ã‚¤ãƒ—ã—ã€ "E
hdw 2007/11/17
sqlite

DB
ãƒªãƒ³ã‚¯
https://net-newbie.com/sqlite/lang.html
hdw 2007/11/17
sqlite
ãƒªãƒ³ã‚¯
Perlã§SQLiteã‚’æ“ä½œã™ã‚‹ - Pumpkin Moonshine
Perlã‹ã‚‰SQLiteã‚’æ“ä½œã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ DBIx::Simpleãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æŽ¥ç¶š ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–å¾—ï¼ˆSELECTï¼‰ã™ã‚‹ ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿½åŠ ï¼ˆINSERTï¼‰ã™ã‚‹ ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ›´æ–°ï¼ˆUPDATEï¼‰ã™ã‚‹ ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å‰Šé™¤ï¼ˆDELETEï¼‰ã™ã‚‹ ä»–å‚è€ƒã«ãªã‚‹ã‚µã‚¤ãƒˆ DBIx::Simpleãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã€‚ ä»Šå›žã¯å¤šæ©Ÿèƒ½ã‚’æ±‚ã‚ã¦ã„ãªã„ã®ã§ã€DBã«æŽ¥ç¶šã™ã‚‹ãƒ©ãƒƒãƒ‘ãƒ¼ã¯DBIx::Simpleã‚’åˆ©ç”¨ã—ã¾ã™ã€‚ % perl -MCPAN -e 'install DBIx::Simple' ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ BEGIN TRANSACTION; CREATE TABLE spell (id integer primary key, name text, message text); INSERT INTO spell VALUES(1,'ãƒ›ã‚¤ãƒŸ','HPã‚’å°‘ã—å›ž
hdw 2007/11/17
Perl

SQLite

Programming
ãƒªãƒ³ã‚¯
1