Skip to content

SQLite Full Text Search with FTS5

Xojo 2016 Release 3 adds support for SQLite’s latest full text search engine: FTS5.

FTS5 has several improvements over SQLite’s previous FTS3 and FTS4 engines (that are still available), but it does slightly break compatibility with FTS4/3. In particular you cannot include a column type in the CREATE VIRTUAL TABLE command and SELECT with MATCH must use the table name, not the column name.

These two features are also notable:

  • Sort results by relevance
  • Highlight results within text

Check out the updated Dev Center page to see some sample code or you can download an example project for Xojo 2016r3.

For information about all the FTS5 changes, refer to the official SQLite docs.