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

pmakino id:pmakino

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

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

ã‚½ãƒ•ãƒˆ
ãƒªãƒ³ã‚¯
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ç®¡ç†Â·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

ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«
ãƒªãƒ³ã‚¯
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

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
Perl DBI: MySQL ã‹ã‚‰ SQLite ã¸ã®ç§»è¡Œ - DeNA æŠ€å¸«ã®ãƒ¡ãƒ¢
åœ°å‘³ãªã‚“ã ã‘ã©ã€åŒã˜ Perl DBI ãªã®ã« MySQL ã¨ SQLite ã§æŒ™å‹•ãŒé•ã£ã¦ã„ã¦ãƒãƒžã£ãŸç‚¹:MySQL ã§ SELECT ã—ãŸå¾Œã€SELECT ã®å–å¾—çµæžœãŒã‚ã‚‹ã‹ã©ã†ã‹ã‚’ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆãƒãƒ³ãƒ‰ãƒ«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã® rows ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã„ã€Œif ($sth->rows)ã€ãªã©ã§ãƒã‚§ãƒƒã‚¯ã—ã¦ã„ãŸãŒã€SQLite ã ã¨ã“ã‚ŒãŒåŠ¹ã‹ãšã€SELECT ã§ããŸå ´åˆã§ã‚‚ 0 ãŒè¿”ã‚‹ã€‚ã€Žå…¥é–€ Perl DBIã€ã«ã‚ˆã‚‹ã¨SELECT æ–‡ã«å¯¾ã—ã¦ã¯ã€ã™ã¹ã¦ã‚’ãƒ•ã‚§ãƒƒãƒã™ã‚‹ã“ã¨ã‚’é™¤ã„ã¦ã€è¿”ã•ã‚Œã‚‹è¡Œæ•°ã‚’çŸ¥ã‚‹ã“ã¨ã¯ã§ããªã„ã€‚(ä¸ç•¥) ã—ãŸãŒã£ã¦ã€SELECT æ–‡ã« rows ãƒ¡ã‚½ãƒƒãƒ‰ã‚„ DBI::rows ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã¯å‹§ã‚ã‚‰ã‚Œãªã„ã€‚ã¨ã®ã“ã¨ã€‚MySQL ã®æ™‚ã¯ãŸã¾ãŸã¾ä½¿ãˆã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã‹ã€‚SQLite ã®å ´åˆã€$dbh->commit ã‚„ $dbh->disconnect ã™ã‚‹å‰ã«ã€SELECT ã«ä½¿
pmakino 2008/06/25
Perl

DB

SQLite
ãƒªãƒ³ã‚¯
https://net-newbie.com/sqlite/lang.html
pmakino 2007/09/17
DB

SQLite

è³‡æ–™
ãƒªãƒ³ã‚¯
AIRã¨SQLiteã§å¦ã¶ ãƒãƒ¼ã‚«ãƒ«DBæ“ä½œã®åŸºæœ¬ ï¼ˆ1/3ï¼‰ â”€ ï¼ IT
Apolloæ”¹ã‚AIRãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ï¼ˆ2ï¼‰ AIRã¨SQLiteã§å¦ã¶ ãƒãƒ¼ã‚«ãƒ«DBæ“ä½œã®åŸºæœ¬ ã‚¯ãƒ©ã‚¹ãƒ¡ã‚½ãƒƒãƒ‰ æ‰æµ¦ç¯¤å² 2007/8/17 ç·¨é›†éƒ¨æ³¨ï¼šå‰å›žã‚ˆã‚Šã€é€£è¼‰ã€ŒApolloãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ã€ã¯æœ¬é€£è¼‰ã€ŒApolloæ”¹ã‚AIRãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ã€ã«ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã—ã¾ã—ãŸã€‚ã“ã®é€£è¼‰ã‚’ã‚ˆã‚Šæ·±ãç†è§£ã™ã‚‹ãŸã‚ã«ã¯ã€é€£è¼‰ã€ŒApolloãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å…¥é–€ã€ã‚‚ä½µã›ã¦ã”è¦§ãã ã•ã„ã€‚ ã„ã¾ã•ã‚‰èžã‘ãªã„ã€SQLiteã¨ã¯ï¼Ÿ å‰å›žã¯AIRï¼ˆAdobe Integrated Runtimeï¼‰ãƒ™ãƒ¼ã‚¿ç‰ˆã®æ–°æ©Ÿèƒ½ã¨ã—ã¦ã€ãƒ‰ãƒ©ãƒƒã‚°ï¼†ãƒ‰ãƒãƒƒãƒ—ã«æ³¨ç›®ã—ã¦2ã¤ã®ã‚µãƒ³ãƒ—ãƒ«ã‚’ä½œæˆã—ã¾ã—ãŸã€‚ ä»Šå›žã¯AIRãƒ™ãƒ¼ã‚¿ç‰ˆã‹ã‚‰åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸãƒãƒ¼ã‚«ãƒ«DBã¨ã®é€£æºã«ã¤ã„ã¦ã§ã™ã€‚AIRã«ã¯ã€DBã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦SQLiteãŒå®Ÿè£…ã•ã‚Œã€ActionScriptã‹ã‚‰SQLiteå½¢å¼ã®DBãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ‰±ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ SQLiteã¯M
pmakino 2007/08/18
AIR

DB

SQLite

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
SQLiteã§çµ„ã¿è¾¼ã¿DBä½“é¨“ï¼ˆ2007å¹´ç‰ˆï¼‰ï¼šCodeZine
ã¯ã˜ã‚ã«ã€€1å¹´å‰ã€é•·ä¹… å‹ã•ã‚“ã®ã‚¢ãƒ¼ãƒ†ã‚£ã‚¯ãƒ«:ã€ŒSQLiteã§çµ„ã¿è¾¼ã¿DBä½“é¨“ã€ãŒæŽ²è¼‰ã•ã‚Œã¾ã—ãŸã€‚ãã“ã§ã¯SQLite3.3.5ã‚’ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ãƒ“ãƒ«ãƒ‰ã—ã€ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ç”Ÿæˆã™ã‚‹æ–¹æ³•ãŒè§£èª¬ã•ã‚Œã¦ã„ã¾ã™ã€‚ã€€ä»Šã‚„SQLiteã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯3.3.16ï¼ˆ2007å¹´4æœˆ20æ—¥ç¾åœ¨ï¼‰ã¾ã§ä¸ŠãŒã£ã¦ã„ã¾ã™ã€‚ã“ã®æœ€æ–°ç‰ˆSQLiteã‚’Visual C++ 2005 Express Editionï¼ˆä»¥ä¸‹ã€VC8EEï¼‰ã®IDEä¸Šã§ãƒ“ãƒ«ãƒ‰ã™ã‚‹æ‰‹é †ã‚’è§£èª¬ã—ã¾ã™ã€‚å¯¾è±¡èªè€…æœ¬æ ¼çš„ãªDBã‚’ä½¿ã†ã¾ã§ã‚‚ãªã„ã€å°ã•ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãŠæ‰‹è»½ã«DBã‚’ä½¿ã£ã¦ã¿ãŸã„ã‚“ã ã‘ã©â€¦â€¦ãªãƒ—ãƒã‚°ãƒ©ãƒž å¿…è¦ç’°å¢ƒ Visual C++ 2005 Express Editionã‚‚ã—ãã¯Visual Studio 2005 SQLite version 3.3.16 step-1ï¼šãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€ã¨ã‚‚ã‹ããƒ“ãƒ«ãƒ‰ã€€ã¾ãšã¯ã‚½ãƒ¼ã‚¹ã‚’å…¥æ‰‹ã—ã¾ã—ã‚‡ã†ã€‚SQL it
pmakino 2007/05/07
Windows

SQLite

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

DB
ãƒªãƒ³ã‚¯
yumi-ii: 2007-01-04 SQLiteã§é›†ç´„é–¢æ•°ã‚’è¿½åŠ ã™ã‚‹
2007-01-04Â Â SQLiteã§é›†ç´„é–¢æ•°ã‚’è¿½åŠ ã™ã‚‹ Perlã®DBD::SQLiteãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ç’°å¢ƒã§ï¼Œä¸å¤®å€¤ï¼ˆãƒ¡ãƒ‡ã‚£ã‚¢ãƒ³ï¼œè‹±ï¼žMedianï¼‰é–¢æ•°ã‚’ä½¿ãˆã‚‹ã‚ˆã†ã«ã—ã¦ã¿ã¾ã™ã€‚ã€ŒSQLiteã®ãƒ˜ãƒ«ãƒ—ã‚’èªã‚“ã ã‚‰ï¼Œé–¢æ•°ã¯è¿½åŠ ã§ãã‚‹ã£ã¦æ›¸ã„ã¦ã‚ã£ãŸã‚ˆã†ãªã€ã¨è¨˜æ†¶ã«æ®‹ã£ã¦ã„ã‚‹äººã‚‚ã„ã‚‹ã¯ãšã€‚ã©ã†ã™ã‚Œã°é–¢æ•°ã‚’è¿½åŠ ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€‚ é›†ç´„é–¢æ•°ã¨ã¯ SQLiteã§ä½¿ãˆã‚‹é–¢æ•°ã®ç¨®é¡žã«ã¯ï¼Œå˜ç´”é–¢æ•°ã¨é›†ç´„é–¢æ•°ã®äºŒç¨®é¡žãŒã‚ã‚Šã¾ã™ã€‚ä»Šå›žï¼Œå®Ÿè£…ã™ã‚‹ã®ã¯é›†ç´„é–¢æ•°ï¼ˆavgï¼Œsumã®ã‚ˆã†ã«SELECTã§æŠ½å‡ºã—ãŸè¦ç´ ã«å¯¾ã—ã¦ä½œç”¨ã™ã‚‹é–¢æ•°ï¼‰ã§ã™ã€‚å˜ç´”é–¢æ•°ã®å®Ÿè£…æ–¹æ³•ã¯èª¬æ˜Žã—ã¾ã›ã‚“ã®ã§æ³¨æ„ã—ã¦ãã ã•ã„ã€‚ ä¸å¤®å€¤ã¨ã¯ å¿µã®ãŸã‚ã€Œä¸å¤®å€¤ã€ã¨ã¯ä½•ã‹ï¼Œæ•´ç†ã—ã¦ãŠãã¾ã™ã€‚ ï¼œæ¡ä»¶ï¼žè¦ç´ ã¯æ˜‡é †ï¼ˆå°ã‹ã‚‰å¤§ï¼‰ã«ä¸¦ã‚“ã§ã„ã‚‹ã‚‚ã®ã¨ã™ã‚‹ã€‚ ï¼œå®šç¾©ï¼žè¦ç´ ã®å€‹æ•°ã‚’nã¨ã™ã‚‹ã€‚ nãŒå¥‡æ•°ã®ã¨ãï¼Œã¡ã‚‡ã†ã©çœŸã‚“ä¸ã®å€¤ nãŒå¶æ•°ã®ã¨ãï¼ŒçœŸã‚“ä¸ã®ãµãŸã¤ã®æ•°ã®å¹³å‡å€¤
pmakino 2007/05/05
Perl

SQLite

DB
ãƒªãƒ³ã‚¯
TkSQLite - mynote
Downloadâ€ Old versions Tcl script http://reddog.s35.xrea.com/software/tksqlite-0.3.2.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.1.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.2.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.3.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.4.zip http://reddog.s35.xrea.com/software/tksqlite-0.4.5.zip http://reddog.s35.xrea.com/software/
pmakino 2007/02/11
DB

SQLite
ãƒªãƒ³ã‚¯
SQLiteã“ã¨ã¯ã˜ã‚ - Devel::Bayside
ä¸–é–“ã§ã¯ã‚ˆãä½¿ã‚ã‚Œã¦ã„ã‚‹ SQLite ã§ã™ãŒã€è‡ªåˆ†ã¯ä½¿ã†æ©Ÿä¼šãŒãªã‹ã£ãŸã®ã§ã€å‹‰å¼·ã—ã¦ã¿ã¾ã—ãŸã€‚ãŠæ‰‹è»½ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã¯éžå¸¸ã«ã‚ˆã•ãã†ã§ã™ã€‚ æ–‡å—ã‚³ãƒ¼ãƒ‰ VineLinux ã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒ EUC ã§ã™ã€‚Template::Toolkit ã‚„ SQLite ã‚„ subversion ã‚„ Trac ã‚’ä½¿ã†ã«ã¯ UTF-8 ã®ã»ã†ãŒä¾¿åˆ©ãªã®ã§ã€ã€Œ/etc/sysconfig/i18nã€ã‚’ä¿®æ£ã—ã¾ã™ã€‚ä»–ã« Poderosa ã‚„ Teraterm æ”¹ã®ã‚ˆã†ã« UTF-8 ã‚’æ‰±ãˆã‚‹ã‚¿ãƒ¼ãƒŸãƒŠãƒ«ãŒå¿…è¦ã§ã™ã€‚ LANG="ja_JP.UTF-8" SUPPORTED="ja_JP.UTF-8:ja_JP.eucJP:ja_JP:ja" SYSFONT="lat0-sun16" SYSFONTACM="8859-15" ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« sqlite æœ¬ä½“ã¨ Perl ç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‰ãƒ©ã‚¤ãƒ
pmakino 2007/01/07
Perl

DB

SQLite
ãƒªãƒ³ã‚¯
SQLiteJDBC
SQLiteJDBC is a Java JDBC driver for SQLite. It runs using either a native code library 100% Pure Java driver based on NestedVM emulation. Both the pure driver and the native binaries for Windows, Mac OS X, and Linux x86 have been combined into a single jar file.
pmakino 2006/12/27
SQLite

DB
ãƒªãƒ³ã‚¯
Fulltext index on SQLite
ã‚‚ã†ã™ã SQLite ã«å…¨æ–‡æ¤œç´¢ãŒã¤ã. Wiki ã‚’è¦‹ã¦ã„ã¦æ°—ä»˜ã„ãŸ. (Full-text Search for SQLite) ãªã‹ãªã‹é ‘å¼µã£ã¦ã‚‹ã¿ãŸã„. ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯æ—¢ã«å…¨æ–‡æ¤œç´¢ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹. å•†ç”¨ã®ã‚‚ã®ã¯ã‚‚ã¡ã‚ã‚“, PostgreSQL ã‚„ MySQL ã‚‚ å¯¾å¿œæ¸ˆ. ä¸€æ–¹ã§, Java è£½ã‚¤ãƒ³ãƒ—ãƒã‚»ã‚¹ RDB ã® HSQL ã‚„ Derbyy ã¯å¯¾å¿œã—ã¦ã„ãªã„. (Wiki ã‚’è¦‹ã‚‹ã¨ææ¡ˆã•ã‚Œã¦ã¯ã„ã‚‹ã‚ˆã†ã™.) å¤§ç‰© DB ã«ã¯è¿½ã„ã¤ã‹ãªã„ã«ã›ã‚ˆ, ä»–ã®è»½é‡ DB ã‚ˆã‚Šã¯ä¸€è¶³å…ˆã‚’è¡Œãã‹ã‚“ã˜. æ•°ã‚ã‚‹ DB ã®è¦ä»¶ã‹ã‚‰å…¨æ–‡æ¤œç´¢ã‚’ãˆã‚‰ã¶ã‚ãŸã‚ŠãŒãƒ”ãƒ³ãƒã‚¤ãƒ³ãƒˆã§ã„ã„. å°ã•ãªè¦æ¨¡ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚‚æ¤œç´¢ãŒä½¿ãˆãŸã‚‰å¬‰ã—ã„ã‚ˆã. ã‚³ãƒ¼ãƒ‰ã¯ CVS ã«å…¥ã£ã¦ã„ã‚‹. ã“ã®ã¸ã‚“. ã¨ã‚Šã‚ãˆãšãƒã‚§ãƒƒã‚¯ã‚¢ã‚¦ãƒˆã—ã¦è©¦ãã†ã¨æ€ã„ãƒ¬ãƒã‚¸ãƒˆãƒªã‚’è¦—ã„ã¦ã¿ã‚‹ã¨, ã‚³ãƒ¼ãƒ‰ã¯ã‚ã‚‹ã‘ã© Makefile ãŒ
pmakino 2006/11/10
SQLite

DB

Senna

æ¤œç´¢
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸