FTS4TableDefinition

The virtual table tokenizer

try db.create(virtualTable: "document", using: FTS4()) { t in
    t.tokenizer = .porter
}

See https://www.sqlite.org/fts3.html#creating_and_destroying_fts_tables

The FTS4 content option

When you want the full-text table to be synchronized with the content of an external table, prefer the synchronize(withTable:) method.

Setting this property invalidates any synchronization previously established with the synchronize(withTable:) method.

See https://www.sqlite.org/fts3.html#the_content_option_

The FTS4 compress option

See https://www.sqlite.org/fts3.html#the_compress_and_uncompress_options

The FTS4 uncompress option

See https://www.sqlite.org/fts3.html#the_compress_and_uncompress_options

The FTS4 matchinfo option

See https://www.sqlite.org/fts3.html#the_matchinfo_option

Support for the FTS5 prefix option

// CREATE VIRTUAL TABLE document USING FTS4(content, prefix='2 4');
db.create(virtualTable: "document", using:FTS4()) { t in
    t.prefixes = [2, 4]
    t.column("content")
}

See https://www.sqlite.org/fts3.html#the_prefix_option

Appends a table column.

try db.create(virtualTable: "document", using: FTS4()) { t in
    t.column("content")
}

Synchronizes the full-text table with the content of an external table.

The full-text table is initially populated with the existing content in the external table. SQL triggers make sure that the full-text table is kept up to date with the external table.

See https://sqlite.org/fts5.html#external_content_tables