{"id":4593,"date":"2013-07-24T09:52:59","date_gmt":"2013-07-24T00:52:59","guid":{"rendered":""},"modified":"2019-02-20T16:52:01","modified_gmt":"2019-02-20T07:52:01","slug":"sqlite%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6%e9%9b%bb%e5%ad%90%e6%9b%b8%e7%b1%8d%e3%83%93%e3%83%a5%e3%83%bc%e3%83%af%e3%81%ab%e5%85%a8%e6%96%87%e6%a4%9c%e7%b4%a2%e6%a9%9f%e8%83%bd%e3%82%92%e8%bf%bd","status":"publish","type":"post","link":"https:\/\/hon.jp\/news\/1.0\/0\/4593","title":{"rendered":"SQLite\u3092\u4f7f\u3063\u3066\u96fb\u5b50\u66f8\u7c4d\u30d3\u30e5\u30fc\u30ef\u306b\u5168\u6587\u691c\u7d22\u6a5f\u80fd\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:36046,&quot;href&quot;:&quot;http:\\\/\\\/commonsware.com\\\/blog\\\/2013\\\/07\\\/23\\\/full-text-searching-book-you.html&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251110123920\\\/https:\\\/\\\/commonsware.com\\\/blog\\\/2013\\\/07\\\/23\\\/full-text-searching-book-you.html&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2026-02-12 17:01:42&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-13 00:59:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-26 06:06:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-11 04:39:50&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-04-11 04:39:50&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p>\u3010\u7de8\u96c6\u90e8\u8a18\u4e8b\u3011\u3061\u3087\u3063\u3068\u3057\u305f\u8868\u30c7\u30fc\u30bf\u51e6\u7406\u306a\u3069\u306e\u3068\u304d\u306b\u30d7\u30ed\u30b0\u30e9\u30de\u30fc\u305f\u3061\u306b\u611b\u7528\u3055\u308c\u3066\u3044\u308b\u7c21\u6613SQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300cSQLite\u300d\u3067\u3001Android\u96fb\u5b50\u66f8\u7c4d\u30d3\u30e5\u30fc\u30ef\u306b\u5168\u6587\u691c\u7d22\u6a5f\u80fd\u3092\u8ffd\u52a0\u3057\u305f\u30c7\u30d9\u30ed\u30c3\u30d1\u30fc\u304c\u3044\u308b\u3002<\/p>\n<p>\u3000\u958b\u767a\u8005\u306fMark Murphy\u3068\u3044\u3046\u4eba\u7269\u3067\u3001Android\u5411\u3051\u306b\u8ca9\u58f2\u3057\u3066\u3044\u308b\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u96fb\u5b50\u66f8\u7c4d\u300cThe Busy Coder&#8217;s Guide to Android Development\u300d\u3067\u305d\u306e\u30ef\u30b6\u3092\u6d3b\u7528\u3002Murphy\u6c0f\u306b\u3088\u308b\u3068\u3001SQLite\u306b\u306f\u5168\u6587\u691c\u7d22\u30cb\u30fc\u30ba\u306e\u305f\u3081\u306bFTS3\/FTS4 Table\u6a5f\u80fd\u3068\u3044\u3046\u306e\u304c\u3042\u308a\u3001\u305d\u308c\u306bHTML\u30c7\u30fc\u30bf\u3092\u6d41\u3057\u8fbc\u3093\u3067\u3044\u308b\u3068\u3044\u3046\u3002\u691c\u7d22\u901f\u5ea6\u306f\u3068\u3066\u3082\u901f\u304f\u30011\u79d2\u4ee5\u5185\u306b\u691c\u7d22\u7d50\u679c\u3092\u8fd4\u3057\u3066\u304f\u308b\u3068\u306e\u3053\u3068\u3002<\/p>\n<p>\u3000SQLite\u306f\u4e3b\u8981\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u3060\u3051\u3067\u306a\u304f\u3001Web\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3068\u3082\u76f8\u6027\u304c\u3044\u3044\u306e\u3067\u3001\u81ea\u4f5c\u30d3\u30e5\u30fc\u30ef\u306b\u5168\u6587\u691c\u7d22\u6a5f\u80fd\u3092\u4ed8\u3051\u305f\u3044\u3068\u8003\u3048\u3066\u3044\u305f\u958b\u767a\u8005\u306f\u4e00\u5ea6\u8a66\u3057\u3066\u307f\u308b\u4fa1\u5024\u304c\u3042\u308b\u3060\u308d\u3046\u3002\u3010hon.jp\u3011<\/p>\n<div align=\"right\"><img decoding=\"async\" src=\"\/image\/qr_honjp.png\"><\/div>\n<p>\u554f\u5408\u305b\u5148\uff1aThe CommonsBlog\u306e\u8a18\u4e8b\uff08 <a href=\"http:\/\/commonsware.com\/blog\/2013\/07\/23\/full-text-searching-book-you.html\" target=\"_blank\">http:\/\/commonsware.com\/blog\/2013\/07\/23\/full-text-searching-book-you.html<\/a> \uff09<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\u3010\u7de8\u96c6\u90e8\u8a18\u4e8b\u3011\u3061\u3087\u3063\u3068\u3057\u305f\u8868\u30c7\u30fc\u30bf\u51e6\u7406\u306a\u3069\u306e\u3068\u304d\u306b\u30d7\u30ed\u30b0\u30e9\u30de\u30fc\u305f\u3061\u306b\u611b\u7528\u3055\u308c\u3066\u3044\u308b\u7c21\u6613SQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300cSQLite\u300d\u3067\u3001Android\u96fb\u5b50\u66f8\u7c4d\u30d3\u30e5\u30fc\u30ef\u306b\u5168\u6587\u691c\u7d22\u6a5f\u80fd\u3092\u8ffd\u52a0\u3057\u305f\u30c7\u30d9\u30ed\u30c3\u30d1\u30fc\u304c\u3044\u308b\u3002 \u3000\u958b\u767a\u8005\u306fMark Murphy\u3068\u3044\u3046\u4eba\u7269\u3067\u3001Android\u5411\u3051\u306b\u8ca9\u58f2\u3057\u3066\u3044\u308b\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u96fb\u5b50\u66f8\u7c4d\u300cThe Busy Coder&#8217;s Guide to Android Developme <a class=\"mh-excerpt-more\" href=\"https:\/\/hon.jp\/news\/1.0\/0\/4593\" title=\"SQLite\u3092\u4f7f\u3063\u3066\u96fb\u5b50\u66f8\u7c4d\u30d3\u30e5\u30fc\u30ef\u306b\u5168\u6587\u691c\u7d22\u6a5f\u80fd\u3092\u8ffd\u52a0\u3059\u308b\u65b9\u6cd5\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAoiEM2xMfscec3m5-RpsRDKVy0:productID":"","_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11],"tags":[],"class_list":{"0":"post-4593","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-publishing"},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p71Ph0-1c5","jetpack_sharing_enabled":true,"brizy_media":[],"_links":{"self":[{"href":"https:\/\/hon.jp\/news\/wp-json\/wp\/v2\/posts\/4593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hon.jp\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hon.jp\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hon.jp\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hon.jp\/news\/wp-json\/wp\/v2\/comments?post=4593"}],"version-history":[{"count":1,"href":"https:\/\/hon.jp\/news\/wp-json\/wp\/v2\/posts\/4593\/revisions"}],"predecessor-version":[{"id":18067,"href":"https:\/\/hon.jp\/news\/wp-json\/wp\/v2\/posts\/4593\/revisions\/18067"}],"wp:attachment":[{"href":"https:\/\/hon.jp\/news\/wp-json\/wp\/v2\/media?parent=4593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hon.jp\/news\/wp-json\/wp\/v2\/categories?post=4593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hon.jp\/news\/wp-json\/wp\/v2\/tags?post=4593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}