In my previous blog post, I mentioned using SQLite with an iOS application. In this post, we will extend that example to support text searching.
While SQLite is a single file database that is pretty straightforward to work, it contains a powerful full-text search feature.
To use this full-text feature of SQLite, you will need to create a new virtual table in SQLite.
Then insert data into this table.
After you get data into the table, it is very easy to do a “match” query against this data and do a fuzzy search for data.
While SQLite is a pretty basic database, you must be impressed with its power and ease of performing a full-text search against an SQLite database. Pretty simple for something this powerful.