[B! db.sqlite] asipã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

asip id:asip

db.sqliteã«é–¢ã™ã‚‹asipã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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ã®SQLæ–‡ï¼ˆãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’é–‹å§‹ã™ã‚‹ï¼‰ | SQLiteå…¥é–€
BEGINæ–‡ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’é–‹å§‹ã—ã¾ã™ã€‚æ˜Žç¤ºçš„ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’é–‹å§‹ã—ãªã‹ã£ãŸå ´åˆã€é€æ¬¡ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒã‚³ãƒŸãƒƒãƒˆã•ã‚Œã‚‹ã€Œã‚ªãƒ¼ãƒˆã‚³ãƒŸãƒƒãƒˆã€ã§å‡¦ç†ãŒå®Ÿè¡Œã•ã‚Œã¾ã™ã€‚ã¤ã¾ã‚Šã€ãƒ‡ãƒ¼ã‚¿ã®è¿½åŠ ãŠã‚ˆã³å¤‰æ›´æ™‚ã¯1ä»¶ã”ã¨ã«ã‚³ãƒŸãƒƒãƒˆã•ã‚Œã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ä½Žä¸‹ã®åŽŸå› ã«ãªã‚Šã¾ã™ã€‚ã—ãŸãŒã£ã¦ã€å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†å ´åˆã¯BEGINæ–‡ã§æ˜Žç¤ºçš„ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®£è¨€ã—ãŸæ–¹ãŒè‰¯ã„ã§ã—ã‚‡ã†ã€‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ç¨®é¡žã«ã¯ã€ŒDEFERREDã€ã€ã€ŒIMMEDIATEã€ã€ã€ŒEXCLUSIVEã€ãŒã‚ã‚Šã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³2.8ä»¥å‰ã§ã¯å¸¸ã«ã€ŒEXCLUSIVEã€ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³3.0.0ã‹ã‚‰3.0.7ã¯ã€ŒIMMEDIATEã€ã§ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³3.0.8ã‹ã‚‰ã¯ã€ã€ŒBEGINã€ã«ç¶šã‘ã¦ã€ŒDEFERREDï¼ˆæ—¢å®šï¼‰ã€ã¾ãŸã¯ã€ŒIMMEDIATEã€ã€ã€ŒEXCLUSIVEã€ã‚’æŒ‡å®šå¯èƒ½ã§ã™ã€‚ã€ŒBEGIN DEFERREDã€ã§é–‹å§‹ã•ã‚ŒãŸãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯ã€ãƒ‡ãƒ¼
asip 2013/09/10
db.sqlite
ãƒªãƒ³ã‚¯
SQLiteã®ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¯4567ä¸‡8000è¡Œï¼ æœ¬ä½“ã®ã‚³ãƒ¼ãƒ‰ã¯6ä¸‡7000è¡Œ
è»½é‡ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦äººæ°—ã®SQLiteã€‚ãã®Webã‚µã‚¤ãƒˆã«æŽ²è¼‰ã•ã‚Œã¦ã„ã‚‹ã€ŒHow SQLite Is Testedã€ã®å†…å®¹ãŒã€æµ·å¤–ã®ãƒ—ãƒã‚°ãƒ©ãƒžãªã©ã®ã‚ã„ã ã§è©±é¡Œã«ãªã£ã¦ã„ã¾ã™ã€‚ 3æœˆã«å…¬é–‹ã•ã‚ŒãŸæœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®SQLite 3.6.23ã€‚æœ¬ä½“ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ç´„6ä¸‡7200è¡Œï¼ˆ67.2KSLOCã€Kilo Source Lines of Codeï¼šç©ºè¡Œã‚„ã‚³ãƒ¡ãƒ³ãƒˆã‚’é™¤ã„ãŸè¡Œæ•°ï¼‰ãªã®ã«å¯¾ã—ã€ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¯ãªã‚“ã¨4567ä¸‡8300è¡Œï¼ˆ45678.3KSLOCï¼‰ã ã¨ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã®ã§ã™ï¼ ã“ã‚Œã¯ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ãŒæœ¬ä½“ã®ç´„679å€ã‚‚ã®å¤§ãã•ã ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ 100ï¼…ã®ãƒ–ãƒ©ãƒ³ãƒã‚«ãƒãƒ¬ãƒƒã‚¸ SQLiteã‚³ã‚¢ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ãƒ†ã‚¹ãƒˆã™ã‚‹ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¨ã—ã¦ã€ä»¥ä¸‹ã®3ã¤ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ TCL Tests TCL Testsã¯ã‚‚ã£ã¨ã‚‚å¤ã„ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã§ã€TCL scripting lang
asip 2010/04/22
db.sqlite
ãƒªãƒ³ã‚¯
Adobe AIRè£½ã®SQLiteç®¡ç†Â·The SQLite Sorcerer MOONGIFT
The SQLite Sorcererã¯Adobe AIRè£½ã®ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã€‚SQLiteã‚’ä½¿ãˆã°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨æ„ã™ã‚‹æ‰‹é–“ã‚‚ãªãã™ãã«ãƒ‡ãƒ¼ã‚¿ç®¡ç†ãŒã¯ã˜ã‚ã‚‰ã‚Œã‚‹ã€‚SQLã‚‚ãã¡ã‚“ã¨ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã§ãƒ‡ãƒ¼ã‚¿ãŒå¤§é‡ã«ãªã£ãŸã‚‰æœ¬æ ¼çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç§»è¡Œã™ã‚‹ã“ã¨ã‚‚å®¹æ˜“ã ã€‚ Adobe AIRã§SQLiteã‚’ç®¡ç† ãã‚“ãªSQLiteã‚’ç®¡ç†ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã¯å¤šã€…ã‚ã‚‹ãŒã€ãƒãƒ¼ã‚«ãƒ«ã«ã‚ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç®¡ç†ã—ãŸã‘ã‚Œã°Adobe AIRã§ä½œã‚‰ã‚ŒãŸThe SQLite SorcererãŒé¢ç™½ã„ãã†ã ã€‚ä¸€é€šã‚Šã®ãƒ‡ãƒ¼ã‚¿æ“ä½œã«åŠ ãˆã€ãƒˆãƒªã‚¬ãƒ¼ãªã©ã‚‚The SQLite Sorcererä¸Šã§ä½œæˆã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚ The SQLite Sorcererã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆã€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®è¿½åŠ /ç·¨é›†ã€ãƒ‡ãƒ¼ã‚¿ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã¾ã§ã“ãªã™ã“ã¨ãŒã§ãã‚‹ã€‚ã•ã‚‰ã«ãƒ“ãƒ¥ãƒ¼ã‚’ä½œã£ãŸã‚Šã€ãƒˆãƒªã‚¬ãƒ¼ã®ä½œæˆã‚‚å¯èƒ½ã ã€‚æš—å·åŒ–ã«ã‚‚å¯¾å¿œã—ã€è§£æžã‚’è¡Œã†æ©Ÿèƒ½ã‚‚ã‚ã‚‹ã€‚ã»ã¨
asip 2010/01/26
db.sqlite
ãƒªãƒ³ã‚¯
ãƒžãƒ«ãƒãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§å‹•ä½œã™ã‚‹SQLiteç®¡ç†Â·SpatiaLite MOONGIFT
SpatiaLiteã¯Windows/Linux/Mac OSXå‘ã‘ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚MySQLã‚„PostgreSQLã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨æ„ã™ã‚‹ã¾ã§ã‚‚ãªã„ãŒã€ãƒ‡ãƒ¼ã‚¿ã®ç®¡ç†ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒã‚ã‚‹ã¨ä¾¿åˆ©ã ã¨æ„Ÿã˜ã‚‹ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã«ãŠã„ã¦SQLiteã¯ã¨ã¦ã‚‚ä¾¿åˆ©ãªå˜åœ¨ã ã€‚ SQLiteã®ç®¡ç†ã«ã©ã†ãž ãƒ•ã‚¡ã‚¤ãƒ«ä¸€ã¤ã§åˆ©ç”¨ã§ãã‚‹ã—ã€ãã‚Œã§ã„ã¦SQLãŒä½¿ãˆã‚‹ã®ã§å¾Œã€…æœ¬æ ¼çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç§»è¡Œã™ã‚‹ã®ã‚‚å®¹æ˜“ã«ãªã‚‹ã€‚ãã‚“ãªSQLiteã‚’CUIã¾ãŸã¯GUIã§ç®¡ç†ã§ãã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒSpatiaLiteã ã€‚é–‹ç™ºè€…ã®æ‰‹å…ƒã«ã‚ã‚‹ã¨ä¾¿åˆ©ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«ãªã‚Šãã†ã ã€‚ æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ã®ã¯ã‚‚ã¡ã‚ã‚“ã€æ—¢å˜ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãã“ã¨ã‚‚ã§ãã‚‹ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã€ãƒ‡ãƒ¼ã‚¿ã®è¿½åŠ /ç·¨é›†ã‚‚ç°¡å˜ã ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¿½åŠ ã‚„ã‚«ãƒ©ãƒ ã®è¿½åŠ ã‚„å‰Šé™¤ã€ãƒˆãƒªã‚¬ãƒ¼ã‚„ãƒ“ãƒ¥ãƒ¼ã®ä½œæˆã¨è¨€ã£ãŸæ“ä½œã¯SQLã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒè¡¨ç¤ºã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãŠã‚Šã€ãã‚Œ
asip 2009/12/31
db.sqlite
ãƒªãƒ³ã‚¯
é¢¨ä¿—æœªçµŒé¨“ã®40ä»£ãŒã‚½ãƒ¼ãƒ—ã§ç¨¼ãã«ã¯ï¼Ÿ
ä»Šå›žã®ãƒ†ãƒ¼ãƒžã¯é¢¨ä¿—æœªçµŒé¨“ã®ï¼”ï¼ä»£ã§ã™ã€ã‚½ãƒ¼ãƒ—ã§ç¨¼ãŽãŸã„ã§ã™ã¨è¨€ã†äº‹ã«ã¤ã„ã¦ã§ã™ã€‚å¹´é½¢ã¯ã‚¢ãƒ©ãƒ•ã‚©ãƒ¼ã‚’éŽãŽãŸï¼”ï¼ä»£ã€ãã—ã¦æ¥ç¨®ã¯ã‚½ãƒ¼ãƒ—ã€ä»•äº‹ãŒã§ããã—ã¦ç¨¼ã’ã‚‹ã®ã‹ã¨ã„ã†ã¨ã“ã‚ã‚’ãƒ¡ã‚¤ãƒ³ã«ã“ã‚Œã‹ã‚‰è‰²ã€…ã¨æ›¸ã„ã¦è¡ŒããŸã„ã¨æ€ã„ã¾ã™ã€‚ ç›®çš„æ„è˜ã¨ç¾å®Ÿ é¢¨ä¿—æœªçµŒé¨“ã®ï¼”ï¼ä»£ã§ã™ã€ã‚½ãƒ¼ãƒ—ã§ç¨¼ãŽãŸã„ã§ã™ã€ã¨è¨€ã†ã®ãŒä»Šå›žã®ãƒ†ãƒ¼ãƒžã«ãªã‚Šã¾ã™ã€‚40ä»£ã§ã‚½ãƒ¼ãƒ—æœªçµŒé¨“ã€ãã—ã¦ãªãŠã‹ã¤ç¨¼ãŽãŸã„ã€ã“ã®çŠ¶æ³ã‚’å®¢è¦³çš„ã«è¦‹ãŸã¨ãæ£ç›´åŽ³ã—ã„ã¨è¨€ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚ã‚‚ã¡ã‚ã‚“40ä»£ã¨è¨€ã£ã¦ã‚‚è‰²ã€…ãªå¥³æ€§ãŒã„ã¾ã™ã€å®¹å§¿ã‚‚é•ãˆã°ç”Ÿãã¦ããŸéŽç¨‹ã‚‚äººãã‚Œãžã‚Œé•ã£ã¦ãã‚‹ã§ã—ã‚‡ã†ã‹ã‚‰ä¸€æ¦‚ã«åŽ³ã—ã„ã€ãã—ã¦çµ¶å¯¾ã«ç¨¼ã’ãªã„ã¨ã¾ã§ã¯è¨€ã„ã¾ã›ã‚“ã€‚ã—ã‹ã—ã€åŽ³ã—ã„ç¾å®ŸãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã¨è¨€ã†ã“ã¨ã¯è¦šæ‚Ÿã—ã¦ãŠãã“ã¨ãŒå¤§åˆ‡ã ã¨æ€ã„ã¾ã™ã€‚ä½•ã‚Œã«ã—ã¦ã‚‚ã€40ä»£ã§ã‚½ãƒ¼ãƒ—æœªçµŒé¨“ã€ã“ã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã§é›‡ã£ã¦ã‚‚ã‚‰ãˆã‚‹ã‚½ãƒ¼ãƒ—åº—ãŒã‚ã‚‹ã®ã‹ï¼Ÿãã—ã¦è‡ªåˆ†ã‚’é›‡ã£ã¦ã‚‚ã‚‰ãˆã‚‹ãŠåº—ã‚’æŽ¢ã™ã¨ã“ã‚ã‹ã‚‰å§‹ã‚ãª
asip 2009/02/16
flash.air

db.sqlite
ãƒªãƒ³ã‚¯
Adobe AIRè£½ã®SQLiteãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰Â·Lita MOONGIFT
SQLiteã¯Webã‚·ã‚¹ãƒ†ãƒ ã«é™ã‚‰ãšã€iPhoneã€Google Gearsã€Adobe AIRã€Safariãªã©æ§˜ã€…ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚å„ç¨®è¨€èªžå‘ã‘ã«ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã ã‘ã§ãªãã€æ‰‹è»½ã«åˆ©ç”¨ã§ãã¦å‹•ä½œã‚‚é€Ÿã„ã¨ç°¡æ˜“çš„ã«ä½¿ã†ã«ã¯ååˆ†ãªæ©Ÿèƒ½ãŒã‚ã‚‹ã®ãŒé…åŠ›ã ã€‚ SQLiteã‚’é–‹ç™ºã«åˆ©ç”¨ã—ã¦ã„ã‚‹ãªã‚‰è¦ãƒã‚§ãƒƒã‚¯ï¼ ãã‚“ãªåˆ©ç”¨å ´é¢ã®å¤šã„SQLiteã®ãƒ‡ãƒ¼ã‚¿ã‚’é–²è¦§ã€ç®¡ç†ã™ã‚‹Adobe AIRã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒLitaã ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã¯Litaã€Adobe AIRè£½ã®SQLite ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã ã€‚ Litaã¯DBãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡å®šã—ã¦é–‹ãã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ãŒè¡¨ç¤ºã•ã‚Œã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’é¸æŠžã™ã‚‹ã¨æ§‹é€ ãŒä¸€è¦§ã•ã‚Œã‚‹ã€‚ã•ã‚‰ã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¸€è¦§ã—ãŸã‚Šã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ç¢ºèªã™ã‚‹ã“ã¨ãŒå¯èƒ½ã ã€‚ã¾ãŸã€ä»»æ„ã®SQLã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ã®ç¢ºèªï¼ˆUTF-8ãªã‚‰ã°æ—¥æœ¬èªžã‚‚è¡¨ç¤ºã•ã‚Œã‚‹ï¼‰ ã‚‚ã¡ã‚ã‚“ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—
asip 2009/02/16
flash.air

db.sqlite
ãƒªãƒ³ã‚¯
1