{"id":9629,"date":"2014-09-16T14:03:16","date_gmt":"2014-09-16T18:03:16","guid":{"rendered":"http:\/\/mjtsai.com\/blog\/?p=9629"},"modified":"2014-09-16T14:03:16","modified_gmt":"2014-09-16T18:03:16","slug":"full-text-search-on-ios-with-fmdb","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2014\/09\/16\/full-text-search-on-ios-with-fmdb\/","title":{"rendered":"Full-Text Search on iOS with FMDB"},"content":{"rendered":"<p><a href=\"http:\/\/newyankeecodeshop.tumblr.com\/post\/97617794988\/full-text-search-on-ios-with-fmdb\">Andrew Goodale<\/a> (via <a href=\"http:\/\/shapeof.com\/archives\/2014\/9\/full-text_search_with_fmdb.html\">Gus Mueller<\/a>):<\/p>\n<blockquote cite=\"http:\/\/newyankeecodeshop.tumblr.com\/post\/97617794988\/full-text-search-on-ios-with-fmdb\"><p>When I started working on an iPhone app to play music from the phone&rsquo;s library based on GPS location, I needed a way to index the song metadata and other textual content. SQLite is built into iOS, and I wanted to use its full-text module support (FTS3\/4). Apple provides no full-text search index functionality for iOS, and other options, such as Lucene, are focused on Java-based environments.<\/p>\n<p>Since I was working with SQLite, I knew the best approach was to work with the excellent FMDB library, which provides an Objective-C wrapper to the SQLite C API. My effort extends that library with additional Objective-C interfaces and protocols to simplify working with the FTS3 module.<\/p><\/blockquote>","protected":false},"excerpt":{"rendered":"<p>Andrew Goodale (via Gus Mueller): When I started working on an iPhone app to play music from the phone&rsquo;s library based on GPS location, I needed a way to index the song metadata and other textual content. SQLite is built into iOS, and I wanted to use its full-text module support (FTS3\/4). Apple provides no [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"","apple_news_api_id":"","apple_news_api_modified_at":"","apple_news_api_revision":"","apple_news_api_share_url":"","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[4],"tags":[594,978,31,30,54,74,71,425],"class_list":["post-9629","post","type-post","status-publish","format-standard","hentry","category-programming-category","tag-fmdb","tag-full-text-search","tag-ios","tag-mac","tag-objective-c","tag-opensource","tag-programming","tag-sqlite"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/9629","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=9629"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/9629\/revisions"}],"predecessor-version":[{"id":9630,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/9629\/revisions\/9630"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=9629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=9629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=9629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}