Full-Text Search Extension

Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension. Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repository. If you would like to install and load it manually, run: INSTALL fts; LOAD fts; Usage The extension adds two PRAGMA statements to DuckDB: one to create, and one to drop an index. Additionally, a scalar macro stem is added, which is used internally by the extension. PRAGMA create_fts_index create_fts_index(input_table, input_id, *input_values, stemmer = 'porter', stopwords = 'english', ignore = '(\\.|[^a-z])+', strip_accents = 1,…