More SQLite and Swift

More SQLite and Swift


| August 3, 2022 | in

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.