SQLite FTS support

[preetb123]

is there any way i can create FTS tables using squidb. If not then how can i achieve full text searching?

[jdkoren]

Absolutely! In the @TableModelSpec annotation, you can specify the module name for virtual tables (which include FTS):

@TableModelSpec(className="FtsModel", tableName="fts_models", moduleName="FTS4")
public class FtsModelSpec {
    // ...
}

When the annotation processor generates the model class, the static final TABLE field will be of type VirtualTable instead of Table.

For using the MATCH operation, you have StringProperty#match() for matching on the column, or you can use VirtualTable#match() for cases where you specify the table name instead of the column name before the MATCH operator.

[preetb123]

thanks @jdkoren.

[sbosley]

Seems like this has been answered, but feel free to reopen if you have any problems with it.