{"id":621,"date":"2009-05-14T12:23:31","date_gmt":"2009-05-14T03:23:31","guid":{"rendered":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/?p=621"},"modified":"2009-05-14T12:26:19","modified_gmt":"2009-05-14T03:26:19","slug":"sqlite%e3%83%90%e3%83%bc%e3%82%b8%e3%83%a7%e3%83%b3%e5%85%b1%e5%ad%98","status":"publish","type":"post","link":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/2009\/05\/14\/621\/","title":{"rendered":"SQLite\u30d0\u30fc\u30b8\u30e7\u30f3\u5171\u5b58"},"content":{"rendered":"<p>\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30d9\u30fc\u30b9\u3067\u4f7f\u3048\u308b\u306e\u306fsqlite3\u306b\u306a\u3063\u3066\u308b\u3093\u3060\u304c\u3001php5-sqlite\u306fsqlite2\u3067php\u304b\u3089\u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u304c\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089\u4f7f\u7528\u3067\u304d\u306a\u3044\u3002\u898b\u3066\u3044\u308b\u3068php5-sqlite3\u3068\u3044\u3046\u30d1\u30c3\u30b1\u30fc\u30b8\u3082\u3042\u308b\u3089\u3057\u304f\u3001\u3053\u308c\u3092\u4f7f\u3048\u308b\u3068\u3044\u3044\u306e\u3060\u304c\u3001\u3053\u306e\u30b5\u30fc\u30d0\u306eVine4.2\u3067\u306f\u3001\u898b\u3064\u304b\u3089\u306a\u3044\u307f\u305f\u3044\uff1f<\/p>\n<p>\u3067\u3001apt-get\u3067\u65e7\u7248\u306e\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u306esqlite\u3082\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u308c\u3070\u307e\u3060\u3044\u3044\u306e\u3060\u304c\u3001\u3053\u3061\u3089\u3082\u30d1\u30c3\u30b1\u30fc\u30b8\u304c\u5b58\u5728\u3057\u306a\u3044\u3088\u3046\u3067\u3001\u30ea\u30f3\u30af\u5148\u3092\u53c2\u8003\u306b\u624b\u52d5\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3002g++\u304c\u306a\u304b\u3063\u305f\u306e\u3067\u3001\u305d\u3061\u3089\u3082\u5148\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304a\u3044\u305f\u3002<\/p>\n<div class=\"hl-surround\" ><div class=\"hl-main\"><pre>$ apt-get install gcc-c++\r\n$ cvs -d :pserver:anonymous@www.sqlite.org:\/sqlite login (\u30d1\u30b9\u30ef\u30fc\u30c9 anonymous)\r\n$ cvs -d :pserver:anonymous@www.sqlite.org:\/sqlite checkout -r version_2 -d sqlite2 sqlite\r\n$ cd sqlite2; .\/configure; make; make install<\/pre><\/div><\/div>\n<p>\u3053\u308c\u3067\u30d0\u30fc\u30b8\u30e7\u30f3\uff12\u306esqlite\u304c\u4f7f\u3048\u308b\u3088\u3046\u306b\u306a\u308b\u3002<br \/>\n<!--more--><br \/>\n\u4f5c\u6210\u3055\u308c\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u306f\u4e21\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u4e92\u63db\u6027\u304c\u306a\u3044\u306e\u3067\u3001\u30c0\u30f3\u30d7\u3055\u305b\u3066\u79fb\u884c\u3059\u308b\uff08\u9006\u306b\u9069\u7528\u3059\u308c\u3070\u30d0\u30fc\u30b8\u30e7\u30f3\uff13\u2192\uff12\u3082\u53ef\u80fd\uff09\u3002\u53d7\u3051\u6e21\u3055\u308c\u308b\u30c0\u30f3\u30d7\u6642\u306e\u30c7\u30fc\u30bf\u306f\u901a\u5e38\u306eSQL\u6587\u306b\u306a\u3063\u3066\u3044\u308b\u3002<\/p>\n<div class=\"hl-surround\" style=\"height:16.8px;\"><div class=\"hl-main\"><pre>$ sqlite foo.db .dump | sqlite3 foo-v3.db<\/pre><\/div><\/div>\n<p>\u30c7\u30fc\u30bf\u306e\u6f22\u5b57\u30b3\u30fc\u30c9\u306e\u5909\u63db\u304c\u5fc5\u8981\u306a\u5834\u5408\u306f\u9014\u4e2d\u3067nkf\u3092\u304b\u307e\u3059\uff08\u4ee5\u4e0b\u306fEUC\u2192UTF8\u306e\u4f8b\uff09\u3002<\/p>\n<div class=\"hl-surround\" style=\"height:16.8px;\"><div class=\"hl-main\"><pre>$ sqlite foo.db .dump | nkf -Ew | sqlite3 foo-v3.db<\/pre><\/div><\/div>\n<p>\u3053\u308c\u307e\u3067\u30d5\u30a1\u30a4\u30eb\u306e\u62e1\u5f35\u5b50\u3092.db\u306b\u3057\u3066\u3044\u308b\u304c\u3001SQLite\u306e\u5834\u5408\u306f.sqlite\u306b\u3059\u308b\u306e\u304c\u6163\u7fd2\u306a\u306e\u304b\uff1f\uff08\u30d0\u30fc\u30b8\u30e7\u30f3\u4e92\u63db\u6027\u304c\u306a\u3044\u306a\u3089\u3001.sqlite3\u306a\u3069\u3068\u3082\u3057\u306a\u3044\u3068\u6df7\u4e71\u3057\u305d\u3046\u3067\u3059\u304c\u2026\uff09\u3002<\/p>\n<p>\u305d\u3082\u305d\u3082\u3001sqlite3\u306b\u30c7\u30fc\u30bf\u306e\u79fb\u884c\u30c4\u30fc\u30eb\u3092\u3064\u3051\u3068\u3044\u3066\u6b32\u3057\u3044\u3068\u3053\u308d\u3060\u3051\u3069\u3001\u30c7\u30fc\u30bf\u79fb\u884c\u3059\u308b\u306b\u306f\u7d50\u5c40sqlite2\u304c\u5fc5\u8981\u306b\u306a\u308b\u304f\u3089\u3044\u5927\u4ef0\u306b\u306a\u308b\u3063\u3066\u3053\u3068\u306a\u306e\u304b\u3082\u3002<\/p>\n<p><b>\u30ea\u30f3\u30af<\/b><\/p>\n<ul>\n<li><a href=\"http:\/\/d.hatena.ne.jp\/maru_cc\/20080420\/1208634913\">sqlite3\u3068sqlite2\u3092\u540c\u5c45\u3055\u305b\u308b &#8211; sqlite2\u306e\u30bd\u30fc\u30b9\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb &#8211; maru.cc@\u306f\u3066\u306a<br \/>\n<\/a><\/p>\n<li><a href=\"http:\/\/jsgt.org\/mt\/archives\/01\/001684.html\">JavaScript++\u304b\u3082\u65e5\u8a18: \u3010SQLite\u3011SQLite2 \u2192 SQLite3<br \/>\n<\/a><\/p>\n<hr align=\"left\" width=\"300\">\n<li><a href=\"https:\/\/addons.mozilla.org\/ja\/firefox\/addon\/5817\">SQLite Manager :: Firefox Add-ons<br \/>\n<\/a><\/p>\n<li><a href=\"http:\/\/www5.plala.or.jp\/Pup\/index.html\">PupSQLite &#8211; \u3077\u3063\u3077\u306e\u3042\u3068\u308a\u3048<br \/>\n<\/a>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30d9\u30fc\u30b9\u3067\u4f7f\u3048\u308b\u306e\u306fsqlite3\u306b\u306a\u3063\u3066\u308b\u3093\u3060\u304c\u3001php5-sqlite\u306fsqlite2\u3067php\u304b\u3089\u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u304c\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089\u4f7f\u7528\u3067\u304d\u306a\u3044\u3002\u898b\u3066\u3044\u308b\u3068php5-sqlite3\u3068\u3044\u3046\u30d1\u30c3 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/wp-json\/wp\/v2\/posts\/621"}],"collection":[{"href":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/wp-json\/wp\/v2\/comments?post=621"}],"version-history":[{"count":3,"href":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/wp-json\/wp\/v2\/posts\/621\/revisions"}],"predecessor-version":[{"id":624,"href":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/wp-json\/wp\/v2\/posts\/621\/revisions\/624"}],"wp:attachment":[{"href":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/wp-json\/wp\/v2\/media?parent=621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/wp-json\/wp\/v2\/categories?post=621"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/mechsys.tec.u-ryukyu.ac.jp\/~oshiro\/SiteList\/wp-json\/wp\/v2\/tags?post=621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}