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

joan9 id:joan9

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

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

iPhoneã§SQLite3ã‚’ä½¿ã†10(iPhoneã‚¢ãƒ—ãƒªãƒªãƒªãƒ¼ã‚¹å¾Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ§‹é€ å¤‰æ›´) - é»’è‰²æ§é¨Žå…µã®iPhoneã‚¢ãƒ—ãƒªé–‹ç™ºæ—¥è¨˜
iPhoneã‚¢ãƒ—ãƒªã‚’ãƒªãƒªãƒ¼ã‚¹å¾Œã«ã€æ©Ÿèƒ½è¿½åŠ ã§ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ§‹é€ ã‚’å¤‰æ›´ã™ã‚‹å¿…è¦ãŒç”Ÿã˜ã¾ã—ãŸã€‚sqlite3ã®DBãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€åˆå›žã®ã‚¢ãƒ—ãƒªã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«ä½œæˆã•ã‚Œã¦ã€ã‚¢ãƒ—ãƒªã‚’ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ãŸéš›ã§ã‚‚ä¸Šæ›¸ãã•ã‚Œã¾ã›ã‚“ã€‚ â€»ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€DBãƒ•ã‚¡ã‚¤ãƒ«ã‚‚æ¶ˆãˆã¾ã™ã€‚é€†ã«ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãªã‘ã‚Œã°å‰ã®ã¾ã¾ã§ã™ã€‚ã‚·ãƒŸãƒ¥ãƒ¬ãƒ¼ã‚¿ã‚‚åŒæ§˜ã®å‹•ããªã®ã§é–‹ç™ºä¸ã¯ã€æ§‹é€ ã‚’å¤‰ãˆãªãŒã‚‰é€²ã‚ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã®ã§æ³¨æ„ã—ã¦ãã ã•ã„ã€‚ FollowManã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ã¯æ¯Žå›žã‚¯ãƒªã‚¢ã™ã‚‹ã®ã§éŽåŽ»ã®ãƒ‡ãƒ¼ã‚¿ã¯ä¸è¦ã§ã™ã€‚ã‚¢ãƒ—ãƒªèµ·å‹•æ™‚ã«ã€ä¸‹è¨˜ã®ã‚ˆã†ã«ãƒ†ãƒ¼ãƒ–ãƒ«å‰Šé™¤ã—ã¦æ–°ã—ã„æ§‹é€ ã§ä½œã‚Šç›´ã™å‡¦ç†ã‚’ã€åˆå›žèµ·å‹•æ™‚ã«å…¥ã‚Œã‚‹ã“ã¨ã§å¯¾å¿œã—ã¾ã—ãŸã€‚ -(void)dbInitialize { int wasSucceeded; // ãƒ†ãƒ¼ãƒ–ãƒ«ã®å‰Šé™¤ wasSucceeded = sqlite3_exec(db_, "DROP TABLE user
joan9 2014/05/16
iOS

SQLite
ãƒªãƒ³ã‚¯
SQLiteã§TIMESTAMPåˆ—ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ã‚’JSTã«ã™ã‚‹
SQLite3ã§æ¬¡ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã£ãŸã€‚ CREATE TABLE sample_table ( id INTEGER NOT NULL PRIMARY KEY , value TEXT, , update_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); ã™ã‚‹ã¨ã€update_dateã«ã¯ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ãŒUTCã§æ—¥æ™‚ãŒã‚»ãƒƒãƒˆã•ã‚Œã¦ã—ã¾ã†ã€‚ èª¿ã¹ã¦ã¿ã‚‹ã¨ã€DATETIME('now','localtime')ã¨ã™ã‚‹ã¨ã€ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ãŒJSTã§æ—¥æ™‚ãŒå–ã‚Œã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ã‹ã£ãŸã€‚ ãã“ã§ã€æ—©é€Ÿä¸Šè¨˜SQLã‚’ CREATE TABLE sample_table ( id INTEGER NOT NULL PRIMARY KEY , value TEXT, , update_date TIMESTAMP DEFAULT DATETIME('now','local
joan9 2014/05/14
SQLite
ãƒªãƒ³ã‚¯
iOS ã§ SQLite - FMDB ã®ä½¿ã„æ–¹ - ã‚¢ã‚«ãƒ™ã‚³ãƒžã‚¤ãƒª
iOS ã§ SQLite ã‚’ç°¡å˜ã«æ‰±ã†ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒª FMDB ã«ã¤ã„ã¦ã¾ã¨ã‚ã‚‹ã€‚ 2017/1/22 æœ¬è¨˜äº‹ã®ã‚µãƒ³ãƒ—ãƒ«ã‚’æœ€æ–°ã® Objective-C ã¨ Swift ã§æ›¸ãç›´ã—ã¦è¨˜äº‹ã«ã¾ã¨ã‚ã¾ã—ãŸ iOS ã§ SQLite - FMDB ã®ä½¿ã„æ–¹ 2017 FMDB ã¨ã¯ï¼Ÿ FMDB ã¯ SQLite ã‚’ iOS ã® Objective-C ã§æ‰±ã„ã‚„ã™ãã™ã‚‹ãŸã‚ã® Wrapper ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€‚ GitHub ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã€‚ ccgus/fmdb ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã‚„ä½¿ç”¨æ„Ÿã¯ JDBC ã‚„ ADO.NET ã«è¿‘ã„ã€‚ã‚ˆã£ã¦ã“ã‚Œã‚‰ã‚’åˆ©ç”¨ã—ãŸã“ã¨ãŒã‚ã‚Œã°ã‚¹ãƒ ãƒ¼ã‚ºã«ç†è§£ã§ãã‚‹ã ã‚ã†ã€‚ FMDB ã®ä»•æ§˜æº–å‚™ ã¾ãš FMDB ã‚’åˆ©ç”¨ã—ãŸã„ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ SQLite ç”¨ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’æœ‰åŠ¹ã«ã™ã‚‹ã€‚æ‰‹é †ã¯ä»¥ä¸‹ã€‚ Xcode å·¦ãƒšã‚¤ãƒ³ã®ãƒŠãƒ“ã‚²ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’é¸æŠž å³ãƒšã‚¤ãƒ³ã« PROJECT
joan9 2013/12/05
FMDB

iOS

db

sqlite
ãƒªãƒ³ã‚¯
Selection 9: iOSã§SQLiteã‚’ä½¿ã†(FMDB)
SQLiteã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯Cè¨€èªžã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ã—ãŸãŒã£ã¦ã€SQLiteã®å„é–¢æ•°ã®å‘¼ã³å‡ºã—ã‚„å¼•æ•°ã®æŒ‡å®šæ–¹æ³•ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®åž‹ã¯Cè¨€èªžã®æ–‡æ³•ãƒ»åž‹ã«å¾“ã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ç‰¹ã«Cè¨€èªžã¸ã®åž‹å¤‰æ›ã«é–¢ã—ã¦ã€DBã®å ´åˆã¯æ•°å€¤(æ•´æ•°ã€æµ®å‹•å°æ•°ç‚¹æ•°)ã€æ–‡å—åˆ—ã€ãƒã‚¤ãƒŠãƒªã€æ—¥ä»˜ç‰æ§˜ã€…ãªåž‹ãŒã‚ã‚Šã€Cocoa Touchã‹ã‚‰Cè¨€èªžã¸ã®åž‹å¤‰æ›ã‚’SQLå®Ÿè¡Œæ™‚ã¨çµæžœå–å¾—æ™‚ã«è¡Œã†å¿…è¦ãŒã‚ã‚‹ãŸã‚ã€çµæ§‹é¢å€’ã ã£ãŸã‚Šã—ã¾ã™ã€‚ ãã‚“ãªã“ã¨ã‚‚ã‚ã£ã¦ã‹ã€iOSã®SQLiteãƒ©ãƒƒãƒ‘ãƒ¼ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦FMDBã¨ã„ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒã‚ã‚Šã€ã“ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯ã“ã®é¢å€’ãªåž‹å¤‰æ›ã‚’å…¨ã¦å—ã‘æŒã£ã¦ãã‚Œã‚‹ãŸã‚ã€ã“ã®ç‚¹ã ã‘ã§ã‚‚FMDBã‚’ä½¿ã†é…åŠ›ã¯å¤§ã„ã«ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ï¼ˆæ³¨ï¼šå¾Œè¿°ã—ã¾ã™ãŒã€FMDBã¯åž‹å¤‰æ›ã ã‘ã§ã¯ç„¡ã„ã§ã™ï¼‰ ã¾ãŸã€FMDBã¯ARCæœ‰åŠ¹/ç„¡åŠ¹ã©ã¡ã‚‰ã«ã‚‚å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ãƒ—ãƒªãƒ—ãƒã‚»ãƒƒã‚µã§ARCã®æœ‰åŠ¹çŠ¶æ…‹ã‚’åˆ¤å®šã—ã¦ã„ã‚‹ã¿ãŸã„ã§ã™ãã€‚
joan9 2013/12/05
FMDB

iOS

sqlite
ãƒªãƒ³ã‚¯
SQLiteã‚’æ‰‹è»½ã«ãƒ»ã‚»ã‚ãƒ¥ã‚¢ã«
16. FMDBã‚’ä½¿ã†ã«ã¯ ã€Œsrcã€ãƒ•ã‚©ãƒ«ãƒ€å†…ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«è¿½åŠ ã€Œlibsqlite3.0.dylibã€ã‚’ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«è¿½åŠ â– FMDatabase.h â– FMDatabase.h â– FMDatabaseAdditions.h â– FMDatabaseAdditions.m â– FMDatabasePool.h â– FMDatabasePool.m â– FMDatabaseQueue.h â– FMDatabaseQueue.m â– FMResultSet.h â– FMResultSet.m ã€Œfmdb.mã€ã¯ãƒ†ã‚¹ãƒˆç”¨ã‚³ãƒ¼ãƒ‰ ãªã®ã§è¿½åŠ ä¸è¦ 17. DBãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆ FBDMã‚’ä½¿ã†ã¨openæ™‚ã«ãƒ•ã‚¡ã‚¤ãƒ«ãŒç„¡ã„å ´åˆã¯ä½œæˆã—ã¦ãã‚Œã‚‹ï¼ FMDatabase *db = [FMDatabase databaseWithPath:@â€ãƒ•ã‚¡ã‚¤ãƒ«ã¾ã§ã®ãƒ‘ã‚¹â€]; //
joan9 2013/11/26
iphone

fmdb

sqlite
ãƒªãƒ³ã‚¯
SQLiteã§å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’ä½¿ãˆã‚‹ã‚ˆã†ã«ã™ã‚‹ - ..ãŸã‚Œã‚ã..
ã„ã¾ã•ã‚‰ã§ã™ãŒã€SQLiteã®3.6.19ã‹ã‚‰å¤–éƒ¨ã‚ãƒ¼ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸãã†ã§ã™ã€‚ ãŸã ã€äº’æ›æ€§ã®éƒ½åˆã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã¯ç„¡åŠ¹ã«ãªã£ã¦ã„ã‚‹ã®ã§ã€DBã«ã¤ãªãåº¦ã« PRAGMA foreign_keys = ON; ã‚’å®Ÿè¡Œã—ã¦ã‚„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ï¼ˆå°†æ¥çš„ã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ã™ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã‘ã‚Œã©ã€ãã‚Œã‚’å‰æã«ã™ã‚‹ãªã€ã ãã†ã§ã™ï¼‰ Windowsç”¨Ver3.7.3 ã§ãã®å‹•ä½œã‚’ç¢ºèªã—ã¦ã¿ã‚‹ã¨ã€ C:\>sqlite3 test.db SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> PRAGMA foreign_keys; 0 ã¨ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ç„¡åŠ¹ã§ã™ã€‚ ã“ã®çŠ¶æ…‹ã§ã€æ¬¡ã®å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã‚’ä½¿ã£ãŸSQLã‚’é£Ÿã‚ã›ã¦ã¿ã¾ã™ã€‚ BEGIN
joan9 2013/08/24
sqlite
ãƒªãƒ³ã‚¯
ã“ã“ã¾ã§ã‚„ã‚‹ã‹ã€‚SQLiteã‚’JavaScriptã«å¤‰æ›Â·SQL.js MOONGIFT
SQL.jsã¯SQLiteã‚’Emscriptenã‚’ä½¿ã£ã¦JavaScriptåŒ–ã—ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ SQL.jsã¯Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§ä½¿ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚Emscriptenã‚’ä½¿ã£ã¦SQLiteã‚’JavaScriptã«å¤‰æ›ã—ãŸé¢ç™½ã„ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ ãƒ‡ãƒ¢ã§ã™ã€‚ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒªã‚¢ã«æ›¸ã‹ã‚ŒãŸSQLã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚ å®Ÿè¡Œã—ãŸçµæžœã§ã™ã€‚æœ€çµ‚çš„ãªçµæžœã ã‘ãŒå‡ºåŠ›ã•ã‚Œã¦ã„ã¾ã™ã€‚SELECTã®çµæžœã¯JSONãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚‚ã¡ã‚ã‚“æ™®é€šã«SQLãŒä½¿ãˆã¾ã™ã€‚ æ—¥æœ¬èªžã¯å‡ºåŠ›æ™‚ã¯åŒ–ã‘ã¦ã—ã¾ã„ã¾ã—ãŸãŒãƒ‡ãƒ¼ã‚¿ä¸Šã¯å•é¡Œãªã„ã¨æ€ã‚ã‚Œã¾ã™ã€‚ SQL.jsã¯SQLiteãŒãã®ã¾ã¾JavaScriptã«ãªã£ã¦ã—ã¾ã£ãŸã‚ˆã†ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚æ…£ã‚ŒãŸä½¿ã„å‹æ‰‹ã§SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã§ãã¦ã—ã¾ã†ã®ã¯é¢ç™½ãã†ã§ã™ã€‚ãªãŠç¾çŠ¶Google Chromeã‚„Firefoxã«ã—ã‹æœ€é©åŒ–ã•ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ SQL.jsã¯
joan9 2012/04/01
websqlã§ã¯ã„ã‹ã‚“ã®ã‚“ã‹ã¨æ€ã‚ã‚“ã§ã‚‚ãªã„

JavaScript

sqlite
ãƒªãƒ³ã‚¯
Haskellã§SQLiteã‚’ä½¿ã† | a posse ad esse
Haskellã§DBã‚’æ“ä½œã™ã‚‹ãªã‚‰HDBCã‚’ä½¿ã†ã®ãŒå®šçŸ³ã ã¨ã¯æ€ã†ã‚“ã§ã™ãŒã€ã‚„ã‚ŠãŸã„ã“ã¨ãŒç°¡å˜ã§ã‹ã¤SQLiteã§ååˆ†ã ã£ãŸã®ã§ã€Database.SQLiteã‚’ä½¿ã£ã¦ã¿ã¾ã—ãŸã€‚ ä½¿ã„æ–¹ SQLæ–‡ã‚’ç™ºè¡Œã™ã‚‹ æœ€åˆã«sqlite3æœ¬ä½“ã¨ã€cabalã§sqliteãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ä½¿ã„æ–¹ã¯ç°¡å˜ã§ã€openConnectionã§æŽ¥ç¶šã§é–‹ãã€execStatementã§SQLæ–‡ã‚’ç™ºè¡Œã—ã¦ã€çµæžœã‚’å–å¾—ã—ã¾ã™ã€‚execStatementã®è¿”å€¤ã¯å¤šç›¸ã§ã€Either String [[Row String]] ã€Either String [[Row Value]]ã€Either String [[Row Value]]ã®ã„ãšã‚Œã‹ã‚’é¸ã¹ã¾ã™ã€‚ Either String [[Row String]] ãªã‚‰LeftãŒã‚¨ãƒ©ãƒ¼ã§ã€Rightãªã‚‰åˆ—åã¨å€¤ã®ã‚¿ãƒ—ãƒ«ã®ãƒªã‚¹ãƒˆã®ãƒªã‚¹ãƒˆã®ãƒªã‚¹
joan9 2011/07/29
Haskell

sqlite
ãƒªãƒ³ã‚¯
SQLiteã§å¦ã¶ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œã®åŸºç¤Ž - Perlå…¥é–€ã‚¼ãƒŸ
Perl â€º ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ â€º here Perlã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯åˆç´šè€…ãŒå¦ã¶ã«ã¯ä»Šã¾ã§ã¯å°‘ã—æ•·å±…ã®é«˜ã„ã‚‚ã®ã§ã—ãŸã€‚ã¾ãšSQLã®å®Ÿè¡Œç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã™ãã«å‹‰å¼·ã—ãŸã„ã¨ã„ã†éœ€è¦ã‚’æº€ãŸã™ã“ã¨ã¯ã§ãã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ ã§ã™ãŒç¾åœ¨ã¯ã“ã®çŠ¶æ³ã¯å¤‰ã‚ã‚Šã¾ã—ãŸã€‚ç¾åœ¨ã§ã¯ActivePerlã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã¨DBD::SQLiteã¨å‘¼ã°ã‚Œã‚‹SQLiteã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒ³ã‚°ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã¾ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã™ã‚‹ãŸã‚ã®ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰è¦‹ãŸã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹éƒ¨åˆ†ã«ã‚ãŸã‚‹DBIã¨ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚‚ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒ³ã‚°ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã§ã™ã®ã§ActivePerlã®æœ€æ–°ç‰ˆã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã ã‘ã§ä½•ã®ç’°å¢ƒæ§‹ç¯‰ã‚‚è¡Œã‚ãªã„ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ç¿’ã—å§‹ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ DBD::SQLiteã¨DBIãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’ç¢ºèªã™ã‚‹ ã¾ãšDBD::SQLiteã¨DBIãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã‹ã©
joan9 2010/12/12
perl

SQLite
ãƒªãƒ³ã‚¯
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))")))
joan9 2010/04/19
Gauche

SQLite
ãƒªãƒ³ã‚¯
ç´«ãƒã‚°:Gauche-dbd-sqlite3ã‚’OSXã§ï¼ˆã¾ãŸã¯portã¨pkg-configã®è©±ï¼‰ - livedoor Blogï¼ˆãƒ–ãƒã‚°ï¼‰
ã‚°ã‚°ã£ãŸã‚‰guyonã•ã‚“ãŒä»¥å‰ã« Leopardã«Gauche-dbd-sqlite3ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ä¸‹ã•ã£ã¦ã„ã‚‹ã®ã ã‘ã‚Œã©ã€0.1.3ã‚’è«¦ã‚ã¦0.1.1ã‚’å…¥ã‚Œã¦ã„ã‚‹ã®ã§å‹¿ä½“ãªã„ã®ã§ãªã‚“ã¨ã‹ã—ãŸã„ã€‚ å…ƒã€…å…¥ã£ã¦ã„ãŸsqlite3ãŒ 3.4 ãªã®ã§ >3.5 ã«ä¸Šã’ã‚‹ % sudo port install sqlite3 % gauche-package install -S root Gauche-dbd-sqlite3-0.1.3.tgz ã§ã‚‚ ... checking for pkg-config... /usr/local/bin/pkg-config checking pkg-config is at least version 0.9.0... yes checking for SQLITE3... configure: error: Package
joan9 2010/04/19
Gauche

SQLite
ãƒªãƒ³ã‚¯
SQLite Optimizer :: Add-ons for Firefox
Firefox ã§ã¯ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚„å±¥æ´ç‰ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ç®¡ç†ã—ã¦ã„ã¾ã™ãŒã€é•·ã„æœŸé–“ä½¿ç”¨ã—ã¦ã„ã‚‹ã†ã¡ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è‚¥å¤§åŒ–ã®ãŸã‚ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã®è¡¨ç¤ºã‚„ã€Firefoxãã®ã‚‚ã®ã®å‹•ä½œãŒé…ããªã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã‚Œã‚‰ã®ãƒ‡ãƒ¼ã‚¿ã®æœ€é©åŒ–ã‚’è¡Œã†ã“ã¨ã«ã‚ˆã‚Šã€ãƒ‡ãƒ¼ã‚¿ã®èªå‡ºã—ã‚„æ›´æ–°ã‚’ã‚¹ãƒ ãƒ¼ã‚ºã«è¡Œãˆã‚‹ã‚ˆã†ã«ã—ã¦ã€Firefox ã®é«˜é€ŸåŒ–ã‚’è©¦ã¿ã¾ã™ã€‚ ------------------------ æœ€é©åŒ–ã¯åˆæœŸçŠ¶æ…‹ã§ã¯ REINDEX ã®ã¿ã§ã™ãŒã€ ã€ŒVACUUMå¾Œã«REINDEXã‚’å®Ÿè¡Œã™ã‚‹ã€ã‚’é¸æŠžã™ã‚‹ã¨ VACCUM ã¨ REINDEX ã‚’è¡Œã†ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ â€»VACUUM å¾Œã« REINDEX ã‚’ã™ã‚‹è¨å®šã«ã—ã¦ã‚ã£ã¦ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½™åˆ†ãªéš™é–“ãŒ20%æœªæº€ã®å ´åˆã¯ REINDEX ã®ã¿è¡Œã„ã¾ã™ã€‚ æ‰‹å‹•å®Ÿè¡Œæ™‚ã®è¨˜å·ã®æ„å‘³ ä¸€ç•ªä¸Šã®å¤§æ–‡å—ã¯ãã‚Œãžã‚Œvacuum ã¨ reindex ã‚’è¡¨ã—ã¾ã™ã€‚ V(acuum
joan9 2009/05/05
firefox

sqlite
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
joan9 2009/05/04
firefox

sqlite
ãƒªãƒ³ã‚¯
deadbeaf.org
This domain may be for sale!
joan9 2009/04/15
iphone

sqlite
ãƒªãƒ³ã‚¯
SQLiteã‚’ä½¿ã£ãŸãƒ†ã‚¹ãƒˆã®tips
DBå‘¨ã‚Šã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’é–‹ç™ºã—ã¦ã„ã‚‹å ´åˆã€ãƒ†ã‚¹ãƒˆDBã«SQLiteã‚’ä½¿ã†äº‹ãŒè‰¯ãã‚ã‚Šã¾ã™ã€‚ ãã®éš›ã€æ™®é€šã§ã‚ã‚Œã°ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã¨æ€ã„ã¾ã™ use Test::More tests => 1; use DBI; do { # SQLiteã§ä½¿ã†ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡å®š my $dbh = DBI->connect('dbi:SQLite:./test.db','',''); $dbh->do(q{CREATE TABLE foo (id INT, name TEXT)}); $dbh->do(q{INSERT INTO foo (id, name) VALUES (10,'nekokak')}); my $sth = $dbh->prepare('SELECT * FROM foo'); $sth->execute; my $row = $sth->fetchrow_hashref();
joan9 2008/12/13
perl

db

test

sqlite
ãƒªãƒ³ã‚¯
SQLiteã®TIMESTAMPåž‹ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ç”¨ã«Perlã®DateTimeã€DateTime::Format::MySQLãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ç¾åœ¨æ™‚åˆ»æ–‡å—åˆ—ã‚’ç”Ÿæˆ
SQLiteã®TIMESTAMPåž‹ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ç”¨ã«Perlã®DateTimeã€DateTime::Format::MySQLãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ç¾åœ¨æ™‚åˆ»æ–‡å—åˆ—ã‚’ç”Ÿæˆ ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ Tweet SQLiteä½¿ã£ã¦ã„ã¦UPDATEã—ãŸçž¬é–“ã®æ™‚åˆ»ã‚’è¨˜éŒ²ã™ã‚‹ã¨ãã«ã€è‡ªå‰ã§æ—¥ä»˜æ–‡å—åˆ—ç”Ÿæˆã—ãªãã¦ã¯ãªã‚‰ãªã„ã®ã§ã€ã©ã†ã™ã‚‹ã‚“ã ã£ã‘ã‹ã¨ã©å¿˜ã‚Œã—ã¦ã—ã¾ã£ãŸã®ã§ã€ã“ã“ã«æ›¸ã„ã¦ãŠã“ã†ã€‚ã“ã“ã«æ›¸ã„ã¦ãŠãã¨ã€Googleã§æ¤œç´¢ã§ãã‚‹ã®ã§ä¾¿åˆ©ãªã‚“ã§ã™ã‚ˆãã€‚ use DateTime; use DateTime::Format::MySQL; my $dt = DateTime->now(); my $date = DateTime::Format::MySQL->format_datetime($dt); print "$date\n"; exit; __END__ å®Ÿè¡Œä¾‹ï¼ˆ2008-08-24 23:24ã«å®Ÿè¡Œï¼‰ï¼š
joan9 2008/08/25
sqlite

DateTime
ãƒªãƒ³ã‚¯
ã‚¢ãƒ‰ãƒ“ã€SQLite Consortiumã«å‚åŠ ã§é–‹ç™ºã‚’æ”¯æ´
Adobe Systemsã¯ç±³å›½æ™‚é–“2æœˆ25æ—¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã€ŒSQLiteã€ã¸ã®å‡ºè³‡æ”¯æ´ã‚’ç™ºè¡¨ã—ãŸã€‚Adobeã¯å°‘ãªãã¨ã‚‚ã€2ã¤ã®é‡è¦ãªãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§SQLiteã‚’æŽ¡ç”¨ã—ã¦ã„ã‚‹ã€‚ Adobeã§ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’çµ±æ‹¬ã™ã‚‹Dave McAllisteræ°ã¯24æ—¥ä»˜ã‘ã®ãƒ–ãƒã‚°ã§ã€AdobeãŒMozillaã¨Symbianãªã©ãŒå‚åŠ ã™ã‚‹ã€ŒSQLite Consortiumã€ã«åŠ ã‚ã£ãŸã“ã¨ã‚’æ˜Žã‚‰ã‹ã«ã—ãŸã€‚ ã€ŒSQLite Consortiumã§ã®ä½œæ¥ã‚’æ”¯æ´ã™ã‚‹ã“ã¨ã§ã€Adobeã¯SQLiteã®ä»Šå¾Œã®æˆé•·ç¶™ç¶šã¨å¼·åŒ–ã‚’æ”¯æ´ã™ã‚‹ã€ã¨McAllisteræ°ã¯è¨€ã†ã€‚ã€Œä»Šå›žã®Adobeã«ã‚ˆã‚‹SQLite Consortiumã®æ”¯æ´ã¯ã€AdobeãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«æ·±ãé–¢ä¸Žã™ã‚‹ã“ã¨ã€ãã—ã¦SQLiteãªã©ã®æŠ€è¡“ãŒã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã«ãƒ¡ãƒªãƒƒãƒˆã‚’ã‚‚ãŸã‚‰ã™ãŸã‚ã«ã¯è‡ªç”±ã§ç‹¬ç«‹ã—ã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨ã„ã†ã‚ã‚Œã‚ã‚Œã®ä¿¡å¿µã‚’ç¤º
joan9 2008/03/03
sqlite

adobe
ãƒªãƒ³ã‚¯
æœˆã«éŠã¶ Â» SQLiteã®ä½¿ã„ã‹ãŸ
joan9 2007/12/01
sqlite

db
ãƒªãƒ³ã‚¯
1