FTS5
say it: “EF-TEE-ESS-FYVE” /ˌɛfˌtiˌɛsˈfaɪv/
SQLite's full-text search extension.
What is FTS5?
FTS5 is SQLite's full-text search extension, adding fast word search to a virtual table.
CREATE VIRTUAL TABLE notes USING fts5(title, body);
SELECT title FROM notes WHERE notes MATCH 'chocolate';
Level: Freelancer · More SQLite terms at this level
Updated