[B! SQLite] pmakinoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

pmakino id:pmakino

SQLiteã«é–¢ã™ã‚‹pmakinoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (40)

${{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ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è„†å¼±æ€§--ã€ŒChromiumã€ãƒ™ãƒ¼ã‚¹ã®ãƒ–ãƒ©ã‚¦ã‚¶ã«ã‚‚å½±éŸ¿ - ZDNet Japan
å°åˆ·ã™ã‚‹ ãƒ¡ãƒ¼ãƒ«ã§é€ã‚‹ ãƒ†ã‚ã‚¹ãƒˆ HTML é›»åæ›¸ç± PDF ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ ãƒ†ã‚ã‚¹ãƒˆ é›»åæ›¸ç± PDF ã‚¯ãƒªãƒƒãƒ—ã—ãŸè¨˜äº‹ã‚’Myãƒšãƒ¼ã‚¸ã‹ã‚‰èªã‚€ã“ã¨ãŒã§ãã¾ã™ åºƒãæ™®åŠã—ã¦ã„ã‚‹ã€ŒSQLiteã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ä¸Šã®è„†å¼±æ€§ãŒç™ºè¦‹ã•ã‚ŒãŸã€‚ã“ã®è„†å¼±æ€§ã«ã‚ˆã‚Šã€è†¨å¤§ãªæ•°ã®ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã‚¢ãƒ—ãƒªã‚„ãƒ¢ãƒã‚¤ãƒ«ã‚¢ãƒ—ãƒªãŒãƒªã‚¹ã‚¯ã«ã•ã‚‰ã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†ã€‚ Tencentã®Bladeã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒãƒ¼ãƒ ã«ã‚ˆã£ã¦ç™ºè¦‹ã•ã‚ŒãŸã“ã®è„†å¼±æ€§ãŒæ‚ªç”¨ã•ã‚ŒãŸå ´åˆã€è¢«å®³è€…ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ä¸Šã«ãŠã„ã¦æ‚ªæ„ã®ã‚ã‚‹ã‚³ãƒ¼ãƒ‰ã®å®Ÿè¡ŒãŒå¯èƒ½ã«ãªã‚‹ã¨ã¨ã‚‚ã«ã€ãã‚Œã»ã©æ·±åˆ»ã§ã¯ãªã„ã‚±ãƒ¼ã‚¹ã§ã‚‚ãƒ—ãƒã‚°ãƒ©ãƒ ãƒ¡ãƒ¢ãƒªã®ãƒªãƒ¼ã‚¯ã‚„ãƒ—ãƒã‚°ãƒ©ãƒ ã®ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãŒå¼•ãèµ·ã“ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ SQLiteã¯è†¨å¤§ãªæ•°ã®ã‚¢ãƒ—ãƒªã«çµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã‚‹ãŸã‚ã€ã“ã®è„†å¼±æ€§ã¯IoTãƒ‡ãƒã‚¤ã‚¹ã‹ã‚‰ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€ã‚¦ã‚§ãƒ–ãƒ–ãƒ©ã‚¦ã‚¶ã€ã€ŒAndroidã€ã‚¢ãƒ—ãƒªã€ã€ŒiOSã€ã‚¢ãƒ—ãƒªã«è‡³ã‚‹ã¾ã§ã®åºƒç¯„
pmakino 2018/12/20
DB

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

è„†å¼±æ€§

SQLite
ãƒªãƒ³ã‚¯
ã‚¢ãƒ—ãƒªã¨ã‚µãƒ¼ãƒãƒ¼ã®é€šä¿¡ã«JSONã§ã¯ãªãSQLiteã‚’ä½¿ã†ã¨å¹¸ã›ã«ãªã‚Œã‚‹ã‹ã‚‚çŸ¥ã‚Œãªã„æ¡ä»¶ã¾ã¨ã‚ - ã‚¢ãƒ‹ãƒžãƒé–‹ç™ºæ—¥èªŒ
è»½ã„æ°—æŒã¡ã§æŠ•ç¨¿ã—ãŸã‚‰ã€æ€ã‚ã¬åéŸ¿ã‚’é ‚ã„ãŸã“ã®è©±ã€‚ è³›å¦ä¸¡è«–ã§è‰²ã€…ãªæ„è¦‹ã‚’é ‚ãã¾ã—ãŸã€‚ å•é¡Œç‚¹ã‚‚å«ã‚ã¦ã‚ã‚‹ç¨‹åº¦ãƒ¡ãƒªãƒƒãƒˆãƒ»ãƒ‡ãƒ¡ãƒªãƒƒãƒˆãŒè¦‹ãˆã¦ããŸã®ã§ã€æœ€å¾Œã«ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ãƒ–ã‚³ãƒ¡ã€Twitterã§è‰²ã€…ã¨æ„è¦‹ã‚’é ‚ã„ãŸæ–¹ã€…ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ã“ã®å ´ã‚’å€Ÿã‚Šã¦ãŠç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ å‰å›žã¾ã§ã®ãŠã•ã‚‰ã„ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨ã‚µãƒ¼ãƒãƒ¼é–“ã§ä½•ã‚‰ã‹ã®ãƒ‡ãƒ¼ã‚¿ã®å—ã‘æ¸¡ã—ã‚’ã™ã‚‹æ™‚ã«ã€ ã‚ˆãä½¿ã‚ã‚Œã‚‹ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¨ã—ã¦JSONã‚„XMLãŒã‚ã‚Šã¾ã™ã€‚ æ§‹é€ ãŒã‚·ãƒ³ãƒ—ãƒ«ãªãƒ†ã‚ã‚¹ãƒˆã§æ±Žç”¨æ€§ãŒé«˜ã„ãŸã‚ã€ã‚ã‚‰ã‚†ã‚‹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ é–“ã®å·®ç•°ã‚’å¸åŽã™ã‚‹ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¨ã—ã¦ãƒ¡ã‚¸ãƒ£ãƒ¼ãªå˜åœ¨ã§ã™ã€‚ ãƒ¢ãƒã‚¤ãƒ«ã‚¢ãƒ—ãƒªã‚‚ä¾‹å¤–ã§ã¯ãªã„ã®ã§ã™ãŒã€JSONãªã©ã‚’ä½¿ã‚ãšã«SQLiteã®DBãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç›´æŽ¥æ¸¡ã—ã¦ã‚„ã‚Šã¨ã‚Šã™ã‚‹ã¨ã„ã†ã®ãŒå…ˆæ—¥æ›¸ã„ãŸè¨˜äº‹ã§ã™ã€‚ SQLiteã¯ã‚¯ãƒã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ãªä¸Šã«1ãƒ•ã‚¡ã‚¤ãƒ«ã§å®Œçµã™ã‚‹ã®ã§ã€1ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã§æ§˜ã€…ãªãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‹ã‚‰
pmakino 2015/11/23
DB

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

SQLite
ãƒªãƒ³ã‚¯
SqlitemanÂ·ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã‹ã‚‰ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã¾ã§ã€‚ä½•ã§ã‚‚ã“ãªã›ã‚‹GUIã®SQLiteç®¡ç† MOONGIFT
SQLiteã¯ã¡ã‚‡ã£ã¨ã—ãŸå°ã•ãªã‚·ã‚¹ãƒ†ãƒ ã§ã‚ã‚Œã°ï¼ˆã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’æ°—ã«ã—ãªãã¨ã‚‚è‰¯ã‘ã‚Œã°ï¼‰ãã®ã¾ã¾ä½¿ãˆã¾ã™ã—ã€ãã†ã§ãªãã¨ã‚‚é–‹ç™ºç’°å¢ƒä¸‹ã§ã¯MySQLã‚„PostgreSQLã®ã‚ˆã†ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ‰‹é–“ã‚‚ãªãä½¿ãˆã‚‹ä¾¿åˆ©ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ ãƒãƒ¼ã‚«ãƒ«ã§ä½¿ã†ã“ã¨ãŒå¤šã„ã‹ã‚‰ã“ãã€ãã®ç®¡ç†ãƒ„ãƒ¼ãƒ«ã‚‚ãƒãƒ¼ã‚«ãƒ«ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§æä¾›ã•ã‚Œã‚‹ã¨ä¾¿åˆ©ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ä»Šå›žã¯Windowsã‚„Linuxã§ä½¿ãˆã‚‹GUIã®SQLiteç®¡ç†Sqlitemanã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒ¡ã‚¤ãƒ³ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã§ã™ã€‚ã“ã‚Œã¯æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ãŸå¾Œã®ç”»é¢ã§ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆç”»é¢ã€‚ã‚°ãƒ©ãƒ•ã‚£ã‚«ãƒ«ã«åˆ†ã‹ã‚Šã‚„ã™ã„å½¢ã§è¨å®šã§ãã¾ã™ã€‚ ãƒ‡ã‚¶ã‚¤ãƒ³ã‚’ä½¿ã†ã“ã¨ã‚‚ã€SQLã‚’ç›´æŽ¥æ›¸ã„ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã¨ã‚«ãƒ©ãƒ ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æƒ…å ±ãŒè¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ã‚·ã‚¹ãƒ†ãƒ ã®è¨å®šå€¤ä¸€è¦§ã€‚ ãƒ“ãƒ¥ãƒ¼ã®ä½œæˆç”»é¢ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒã‚ãƒ¥ãƒ¼ãƒ ãªã©
pmakino 2014/02/16
DB

SQLite

ã‚½ãƒ•ãƒˆ
ãƒªãƒ³ã‚¯
æš—å·åŒ–å¯¾å¿œã®æ‰‹è»½ãªä»®æƒ³ãƒ‰ãƒ©ã‚¤ãƒ–ä½œæˆã‚½ãƒ•ãƒˆã€ŒVirtual Disk Utilityã€NOT SUPPORTED
pmakino 2011/02/07
Windows

ã‚½ãƒ•ãƒˆ

HDD

æš—å·

SQLite
ãƒªãƒ³ã‚¯
WEBãƒ™ãƒ¼ã‚¹ã§æ¥½ã€…SQLiteç®¡ç†ã€ŒSQLiteManagerã€:phpspoté–‹ç™ºæ—¥èªŒ
SQLiteManager - Web-based SQLite administration WEBãƒ™ãƒ¼ã‚¹ã§æ¥½ã€…SQLiteç®¡ç†ã€ŒSQLiteManagerã€ SQLiteã¯ä¾¿åˆ©ã§ã™ãŒã€ã‚ã¾ã‚Šæ…£ã‚Œã¦ã„ãªã„ã¨ãƒ†ãƒ¼ãƒ–ãƒ«å†…ã‚’æ“ä½œã™ã‚‹ã®ã¯å¾®å¦™ã«é¢å€’ã ã£ãŸã‚Šã—ã¾ã™ã€‚ ã“ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’ä½¿ãˆã°WEBãƒ™ãƒ¼ã‚¹ã®GUIã§ç°¡å˜ç®¡ç†ãŒå‡ºæ¥ã¾ã™ã€‚ è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚„ã€ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ“ä½œã€åŸºæœ¬ã®ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œï¼ˆInsert , Update, Delete, Select)ã‚„ã€ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¯èƒ½ã€‚ ã‚¹ã‚ãƒ³ã«ã‚ˆã‚‹ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã®è¦‹ãŸç›®ã‚’å¤‰æ›´ã™ã‚‹ã“ã¨ã‚‚å‡ºæ¥ã¾ã™ã€‚ ã“ã‚Œã¯ã„ã„ã§ã™ãã€‚ é–¢é€£ã‚¨ãƒ³ãƒˆãƒª SQLiteã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£è³‡æ–™ php SQLiteAdmin
pmakino 2010/11/14
SQLite

ã‚½ãƒ•ãƒˆ

Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

DB
ãƒªãƒ³ã‚¯
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
pmakino 2010/05/16
SQLite

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

é–‹ç™º
ãƒªãƒ³ã‚¯
ãƒžãƒ«ãƒãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§å‹•ä½œã™ã‚‹SQLiteç®¡ç†Â·SpatiaLite MOONGIFT
SpatiaLiteã¯Windows/Linux/Mac OSXå‘ã‘ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚MySQLã‚„PostgreSQLã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨æ„ã™ã‚‹ã¾ã§ã‚‚ãªã„ãŒã€ãƒ‡ãƒ¼ã‚¿ã®ç®¡ç†ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒã‚ã‚‹ã¨ä¾¿åˆ©ã ã¨æ„Ÿã˜ã‚‹ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã«ãŠã„ã¦SQLiteã¯ã¨ã¦ã‚‚ä¾¿åˆ©ãªå˜åœ¨ã ã€‚ SQLiteã®ç®¡ç†ã«ã©ã†ãž ãƒ•ã‚¡ã‚¤ãƒ«ä¸€ã¤ã§åˆ©ç”¨ã§ãã‚‹ã—ã€ãã‚Œã§ã„ã¦SQLãŒä½¿ãˆã‚‹ã®ã§å¾Œã€…æœ¬æ ¼çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç§»è¡Œã™ã‚‹ã®ã‚‚å®¹æ˜“ã«ãªã‚‹ã€‚ãã‚“ãªSQLiteã‚’CUIã¾ãŸã¯GUIã§ç®¡ç†ã§ãã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒSpatiaLiteã ã€‚é–‹ç™ºè€…ã®æ‰‹å…ƒã«ã‚ã‚‹ã¨ä¾¿åˆ©ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«ãªã‚Šãã†ã ã€‚ æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ã®ã¯ã‚‚ã¡ã‚ã‚“ã€æ—¢å˜ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãã“ã¨ã‚‚ã§ãã‚‹ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã€ãƒ‡ãƒ¼ã‚¿ã®è¿½åŠ /ç·¨é›†ã‚‚ç°¡å˜ã ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¿½åŠ ã‚„ã‚«ãƒ©ãƒ ã®è¿½åŠ ã‚„å‰Šé™¤ã€ãƒˆãƒªã‚¬ãƒ¼ã‚„ãƒ“ãƒ¥ãƒ¼ã®ä½œæˆã¨è¨€ã£ãŸæ“ä½œã¯SQLã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãŒè¡¨ç¤ºã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãŠã‚Šã€ãã‚Œ
pmakino 2009/12/27
SQLite

ã‚½ãƒ•ãƒˆ

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

DB

SQLite

ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«
ãƒªãƒ³ã‚¯
Remedie: Building a desktop app with HTTP::Engine, SQLite and jQuery
7. Acme-DateTime-Duration-Numeric Acme-Module-Authors Acme-Sneeze Acme-Sneeze-JP Apache-ACEProxy Apache- AntiSpam Apache-Clickable Apache-CustomKeywords Apache-DefaultCharset Apache-GuessCharset Apache-JavaScript- DocumentWrite Apache-No404Proxy Apache-Proï¬ler Apache-Session-CacheAny Apache-Session-Generate-ModUniqueId Apache-Session-Generate-ModUsertrack Apache-Session-PHP Apache-Session-Serializ
pmakino 2009/09/11
Perl

YAPC

yapcasia2009

ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³

è³‡æ–™

SQLite

jQuery
ãƒªãƒ³ã‚¯
è‚¥å¤§åŒ–ã—ãŸã€ŒFirefoxã€ã®å†…éƒ¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒœã‚¿ãƒ³ä¸€ç™ºã§æœ€é©åŒ–ã€ŒVacuum Placesã€NOT SUPPORTED
pmakino 2009/09/05
Firefox

é«˜é€ŸåŒ–

SQLite

ã‚½ãƒ•ãƒˆ
ãƒªãƒ³ã‚¯
Firefoxã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã€Œãƒã‚ãƒ¥ãƒ¼ãƒ ã€ã—ã¦é«˜é€ŸåŒ–ã™ã‚‹Tips | ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚«ãƒ¼ãƒ»ã‚¸ãƒ£ãƒ‘ãƒ³
ç‰¹ç¨®ç”¨é€”è‡ªå‹•è»Šã§ã™ï¼ çœŸç©ºãƒãƒ³ãƒ—ã§ã™ï¼ å·¥æ¥ç”¨ã‚¢ã‚¤ãƒãƒ³å°ã§ã™ï¼ 3äººåˆã‚ã›ã¦ã€ãƒã‚ãƒ¥ãƒ¼ãƒ ã§ã™ï¼ ã¨æ›¸ã„ãŸå¾Œã§ã€ã™ã§ã«å…ˆé”ãŒã„ãŸã“ã¨ã«æ°—ã¥ã„ãŸã‚ã‘ã§ã™ãŒã€Firefoxã‚’ã€Œãƒã‚ãƒ¥ãƒ¼ãƒ ã€ã™ã‚‹ã¨ã€å‹•ä½œãŒæ©Ÿæ•ã«ãªã‚‹ã€ã¨ã„ã†TipsãŒãƒ–ãƒã‚°ãƒ»Mozilla Linksã§ç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ æ—¥ã€…ãƒ–ãƒ©ã‚¦ã‚¸ãƒ³ã‚°ã«ã„ãã—ã‚“ã§ã„ã‚‹ã¨ã€å±¥æ´ã¨ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚’æ ¼ç´ã™ã‚‹ã€Œplaces.sqliteã€ã«ã€å±¥æ´ãªã©ãŒæ¾±ã®ã‚ˆã†ã«æºœã¾ã£ã¦ã—ã¾ã£ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒæ–ç‰‡åŒ–ã—ãŸã‚Šã™ã‚‹ã“ã¨ã§ã€Firefoxã®å‹•ä½œãŒé…ããªã£ã¦ãã‚‹ã€ã¨ã„ã†å•é¡Œã«ç›´é¢ã—ã¾ã™ã€‚ãã“ã§ã€Œplaces.sqliteã€ã‚’æœ€é©åŒ–ã™ã‚‹ã“ã¨ã§ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã¦ã®ã¾ã£ã•ã‚‰ã ã£ãŸã“ã‚ã®Firefoxã®ã€ã‚ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã‚’å–ã‚Šæˆ»ã™ã®ãŒã€Œãƒã‚ãƒ¥ãƒ¼ãƒ ã€ã¨ã„ã†ã‚ã‘ã§ã™ã€‚ æ‰‹é †ã¯ã‚ãšã‹3ã‚¹ãƒ†ãƒƒãƒ—ã€‚ ã€Œãƒ„ãƒ¼ãƒ«ã€â†’ã€Œã‚¨ãƒ©ãƒ¼ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ä»¥ä¸‹ã®ãƒ†ã‚ã‚¹ãƒˆã‚’ã‚³ãƒ”ãƒ¼ï¼†ãƒšãƒ¼ã‚¹ãƒˆ Co
pmakino 2009/08/27
Firefox

é«˜é€ŸåŒ–

SQLite

DB
ãƒªãƒ³ã‚¯
Firefoxã®SQLiteDBã®å†ç·¨æˆã«ã¤ã„ã¦ï¼ˆã™ã“ã—è©³ç´°ã«ï¼‰ - hogehoge @teramako
http://www.sio.no-ip.com/mt/shio/archives/2008/10/firefox-3-sql it.html ç‰©å‡„ã„äººæ°—ã§ã™ãã€‚ ã“ã‚Œã«ã¤ã„ã¦ã¡ã‚‡ã£ã¨è©³ã—ãæ›¸ã„ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ DBãƒ•ã‚¡ã‚¤ãƒ«ã®æ–ç‰‡åŒ– Windowsã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã‚’ãƒ‡ãƒ•ãƒ©ã‚°ã—ã¾ã—ã‚‡ã£ã¦ã‚„ã¤ã¯DBãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚‚è¨€ãˆã‚‹ã“ã¨ã ã€‚ ä»•çµ„ã¿ã‚’Leo's Chronicle: ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ å…¥é–€ï¼šã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ä½“è‚²ä¼šç³»å›³æ›¸é¤¨ï¼Ÿã€ã«ç¿’ã£ã¦ã€Œå›³æ›¸é¤¨ã€ã«ä¾‹ãˆã¦ã¿ã‚‹ã€‚ å›³æ›¸é¤¨ DBãƒ•ã‚¡ã‚¤ãƒ« æœ¬ ä¸èº«ã®ãƒ‡ãƒ¼ã‚¿ä¸€è¡Œ ã¨ã„ãˆã‚‹ã ã‚ã†ã€‚ å˜ç´”ã«ãƒ‡ãƒ¼ã‚¿ãŒè¿½åŠ ã•ã‚Œã¦ã„ãã ã‘ãªã‚‰ã€æœ¬ã‚’æœ¬æ£šã®æœ«å°¾ã«è¿½åŠ ã™ã‚‹ã ã‘ãªã®ã§ãƒ‡ãƒ¼ã‚¿ã¯è©°ã¾ã£ãŸã¾ã¾ã ã—æ¥½ãƒãƒ³ã *1ã€‚ é€”ä¸ãƒ‡ãƒ¼ã‚¿ã®å‰Šé™¤(æœ¬ã‚’æŠœãå–ã‚‹)ã‚’è€ƒãˆã¦ã¿ã‚‹ã€‚æŠœãå–ã£ãŸå¾Œæœ¬ã‚’è©°ã‚ãªã„ã¨ç©ºç™½ãŒã§ãã‚‹ã€‚ ã¾ãŸã€ãƒ‡ãƒ¼ã‚¿æ›´æ–°ï¼ˆæœ¬ã®äº¤æ›ï¼‰ã‚’è€ƒãˆã¦ã¿ã‚‹ã€‚åŒã˜å¤§ãã•ãªã‚‰è‰¯ã„ãŒã€‚å¤§ãã‹ã£ãŸã‚Šã€
pmakino 2009/05/30
Firefox

SQLite

DB

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
firefox 3ãŒé…ããªã£ãŸâ†’ SQLite reindexã§è§£æ±ºï¼†é«˜é€ŸåŒ– - ã—ãŠãã‚‹ã¨
Firefox 3ã‚’ä½¿ã£ã¦ã„ã¦ã€èµ·å‹•ãŒç•°æ§˜ã«é…ããªã£ã¦ã„ã¦å›°ã£ã¦ã„ã¾ã—ãŸã€‚ ä»Šå›žã€ã©ã†ã‚„ã‚‰è§£æ±ºã—ãŸæ¨¡æ§˜ãªã®ã§å‚™å¿˜éŒ²ã¾ã§ã«è¨˜è¼‰ã—ã¾ã™ã€‚ Firefox 3ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ã¦ã‹ã‚‰ã€ãƒ¡ã‚¤ãƒ³ã§åˆ©ç”¨ã—ã¦ã„ã‚‹PCã§ Firefox ã®èµ·å‹•ãŒé…ãã¦ä»•æ–¹ãŒãªã„ã€ipv6æ¤œç´¢ã‚’ç„¡åŠ¹ã«ã™ã‚‹ã¨ã‹è©¦ã—ã¦ã¿ãŸã‘ã©ã‚‚ã‹ã‚ãšã€ã¨ã„ã†çŠ¶æ…‹ã§ã—ãŸã€‚ ã ã„ãŸã„åŒã˜Add-onã‚’ ä»–ã®PCã«ã‚‚å…¥ã‚Œã¦åˆ©ç”¨ã—ã¦ã„ã¾ã™ãŒã€ãã¡ã‚‰ã¯ã¯ãã†é…ãã¯ãªã„ã®ã§ã€ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ç³»ã‹ã‚ã€ã¾ã§ã¯åˆ‡ã‚Šåˆ†ã‘ã—ã¦ãã®ã¾ã¾åˆ©ç”¨ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«å†ä½œæˆã€é¢å€’ã§ã™ã—ãã€‚ ã§ã€ãµã¨æ€ã„ç«‹ã£ã¦ Firefox 3 ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ã€SQLite ãƒ‡ãƒ¼ã‚¿ç¾¤ã‚’ã‹ãŸã£ã±ã—ã‹ã‚‰ Reindex ã—ãŸã‚‰ã€ æ˜”ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ãŒå†ç¾ã—ã¾ã—ãŸã€‚ã¯ã‚„ã„ï¼ æ”¹å–„ï¼šï¼’ã¤ ï¼‘ï¼‰èµ·å‹•ãŒé€Ÿããªã£ãŸï¼ˆèµ·å‹•ã«1-2åˆ†ã‹ã‹ã‚‹â†’ã™ãèµ·å‹•ã€‚åŠ‡çš„ã«æ”¹å–„ã€‚ï¼‰ ï¼’ï¼‰ã‚µã‚¤ãƒˆè¡¨ç¤ºã‚‚ã¯ã‚„ã„ã€‚ cookie
pmakino 2009/05/12
Firefox

é«˜é€ŸåŒ–

SQLite
ãƒªãƒ³ã‚¯
Mozilla Re-Mix: Firefoxã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æœ€é©åŒ–ã—ã¦é«˜é€ŸåŒ–ã‚’å›³ã‚‹ã‚¢ãƒ‰ã‚ªãƒ³ã€ŒSQLite Optimizerã€
Firefox 3ã§ã¯ã€å±¥æ´ã‚„ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã€ã‚¯ãƒƒã‚ãƒ¼ãªã©ã®ä»–ã€ä¸€éƒ¨ã‚¢ãƒ‰ã‚ªãƒ³ã®åˆ©ç”¨ãƒ‡ãƒ¼ã‚¿ã‚‚SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ç®¡ç†ã—ã¦ã„ã¾ã™ã€‚ æ—¥ã€…ã®åˆ©ç”¨ã«ã‚ˆã‚Šã€ã“ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå¤§ãããªã£ã¦ãã‚‹ã¨ã€Firefoxã®èµ·å‹•ã«æ™‚é–“ãŒã‹ã‹ã£ãŸã‚Šã€å‹•ä½œãŒç·©æ…¢ã«ãªã£ã¦ãã‚‹ã¨ã„ã†ã“ã¨ãªã©ãŒè€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªã¨ãã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æœ€é©åŒ–ã‚’ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã€Firefoxã®å‹•ä½œã‚’è»½ãã™ã‚‹ã¨ã„ã†æ–¹æ³•ãŒãƒ–ãƒã‚°ãªã©ã«ã‚‚ã‚ˆãæ›¸ã‹ã‚Œã¦ã„ã¾ã™ãŒã€ã“ã‚Œã‚’å®Ÿè¡Œã™ã‚‹ã«ã¯ã€ŒSQLite Managerã€ã¨ã„ã†ã‚¢ãƒ‰ã‚ªãƒ³ã‚’Firefoxã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦èµ·å‹•ã—ã€ãŠä½¿ã„ã®ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ãƒ•ã‚©ãƒ«ãƒ€ã‹ã‚‰è©²å½“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æŽ¢ã—ã¦[Reindex]ã‚’è¡Œã†ã¨ã„ã†ä½œæ¥ãŒå¿…è¦ã¨ãªã‚Šã€åˆå¿ƒè€…ã«ã¯ã¡ã‚‡ã£ã¨å®Ÿè¡Œã—ã«ãã„ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ ï¼œå‚è€ƒè¨˜äº‹ï¼ž firefox 3ãŒé…ããªã£ãŸâ†’ SQLite reindexã§è§£æ±ºï¼†é«˜é€ŸåŒ– via ã—ãŠãã‚‹ã¨ Firefo
pmakino 2009/05/08
Firefox

é«˜é€ŸåŒ–

ã‚½ãƒ•ãƒˆ

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

SQLite

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
tokuhirom blog
Blog Search when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: ${entry.path} [in template "__entry.ftlh" at line 3, column 25] - Reached through: #include "__entry.ftlh" [in template "entry.ftlh" at
pmakino 2009/04/21
Perl

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ãªã‚‰ã°æ—¥æœ¬èªžã‚‚è¡¨ç¤ºã•ã‚Œã‚‹ï¼‰ ã‚‚ã¡ã‚ã‚“ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—
pmakino 2009/02/22
SQLite

AIR
ãƒªãƒ³ã‚¯
DBMã«ã‚ˆã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãã®å¼ - mixi engineer blog
ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ã§ä¼‘ã‚“ã å½±éŸ¿ã§ä»•äº‹ãŒé¬¼ã®ã‚ˆã†ã«æºœã¾ã£ã¦æ¶ˆåŒ–ä¸è‰¯ã®mikioã§ã™ï¼ˆã“ã‚“ãªè¨˜äº‹ã‚’æ›¸ã„ã¦ã„ã‚‹å ´åˆã˜ã‚ƒãªã„ï¼‰ã€‚ã•ã¦ä»Šå›žã¯ã€Tokyo Cabinetã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«é¢¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆTCTDBï¼‰ã®å®Ÿè£…ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ SQLiteã¨ã®é•ã„ã¯ï¼Ÿ SQLiteã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³çµ„ã¿è¾¼ã¿åž‹ã®SQLå¯¾å¿œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚TCã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ˆã‚Šã‚‚ã¯ã‚‹ã‹ã«é«˜æ©Ÿèƒ½ã§ã€ãã‚Œã§ã„ã¦æ€§èƒ½ã‚‚å¤§å¤‰å„ªã‚Œã¦ã„ã¾ã™ã€‚ã„ã‚ã‚†ã‚‹ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«çµ„ã¿è¾¼ã‚€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãŠæŽ¢ã—ã§ã‚ã‚Œã°ã€TCãªã‚“ã‹ã§ã¯ãªãã€æ–ç„¶SQLiteãŒãŠã™ã™ã‚ã§ã™ã€‚ ä¸€æ–¹ã§ã€TCãªã©ã®DBMã¯ã€ã‚ˆã‚Šå˜ç´”ãªãƒ‡ãƒ¼ã‚¿æ“ä½œã‚’ã‚ˆã‚Šé«˜é€Ÿã«å®Ÿè¡Œã§ãã‚‹ã‚ˆã†ã«è¨è¨ˆãŠã‚ˆã³å®Ÿè£…ã•ã‚Œã¦ã„ã¾ã™ã€‚å…¸åž‹çš„ãªãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ã¨ã—ã¦ã€å¤§è¦æ¨¡Webã‚µã‚¤ãƒˆã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆç®¡ç†ã‚„ã€ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã«ä¼´ã†é›†è¨ˆæ“ä½œãŒæŒ™ã’ã‚‰
pmakino 2009/01/31
mixi

DB

SQLite

ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€REVIEWã€‘ã€ŒSQLiteã€ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’GUIã§æ“ä½œã§ãã‚‹é«˜æ©Ÿèƒ½ç®¡ç†ã‚½ãƒ•ãƒˆã€ŒPupSQLiteã€
ã€ŒPupSQLiteã€ã¯ã€ãƒ•ãƒªãƒ¼ã§åˆ©ç”¨ã§ãã‚‹è»½é‡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSQLiteã€ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’GUIã§ç®¡ç†ã§ãã‚‹ã‚½ãƒ•ãƒˆã€‚Windows XP/Vistaã«å¯¾å¿œã™ã‚‹å¯„ä»˜æ“è¿Žã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã§ã€ä½œè€…ã®Webã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ãªãŠã€å‹•ä½œã«ã¯.NET Framework 2.0ä»¥é™ãŒå¿…è¦ã€‚ æœ¬ã‚½ãƒ•ãƒˆã«ã¯ã€ŒSQLiteã€ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªâ€œsqlite3.dllâ€ãŒåŒæ¢±ã•ã‚Œã¦ãŠã‚Šã€ç’°å¢ƒã®æ§‹ç¯‰ä½œæ¥ãªã©ãŒå¿…è¦ãªããã®ã¾ã¾åˆ©ç”¨å¯èƒ½ã€‚ç”»é¢ã¯MDIæ–¹å¼ã«ãªã£ã¦ãŠã‚Šã€è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãã‚Œãžã‚ŒåŒæ™‚ã«åã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã¨ã—ã¦é–‹ãã“ã¨ãŒã§ãã‚‹ã€‚å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦å†…ã«ã‚¿ãƒ–åˆ‡ã‚Šæ›¿ãˆåž‹ã®ã‚°ãƒªãƒƒãƒ‰ãƒ“ãƒ¥ãƒ¼ã¨ã—ã¦è¡¨ç¤ºã•ã‚Œã‚‹ä»•çµ„ã¿ã€‚ æ©Ÿèƒ½ã‚‚å……å®Ÿã—ã¦ãŠã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«å†…ãƒ‡ãƒ¼ã‚¿ã®é–²è¦§ãƒ»ç·¨é›†ã¯ã‚‚ã¡ã‚ã‚“ã€SQLæ–‡ã‚’ç™ºè¡Œã—ã¦çµæžœã‚’è¡¨å½¢å¼ã§é–²è¦§ã§ãã‚‹æ©Ÿèƒ½ã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ–‡ã‚’å‡ºåŠ›ã™ã‚‹æ©Ÿèƒ½ã€2ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ¯”
pmakino 2008/09/09
tksqlite ã‚ãƒ©ãƒ¼? ãã‚Œã«ã—ã¦ã‚‚ã“ã†ã„ã†è¨˜äº‹ãŒãƒ›ãƒƒãƒ†ãƒ³ãƒˆãƒªã«ä¸ŠãŒã‚‹ã£ã¦ã®ãŒã¯ã¦ãƒ–ã‚‰ã—ã„ãªâ€¦

Windows

SQLite

DB

ã‚½ãƒ•ãƒˆ
ãƒªãƒ³ã‚¯
tokuhirom blog
Blog Search when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: ${entry.path} [in template "__entry.ftlh" at line 3, column 25] - Reached through: #include "__entry.ftlh" [in template "entry.ftlh" at
pmakino 2008/07/28
Perl

DB

SQLite
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸