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.

Looking For More?

Sign up to receive useful software development tips and news from the Don't Panic Labs team.

You have successfully subscribed!

Share This