Sqlite comes with support for full text special tables. Is it possible to use these features from within R, e.g. from RSQLite
?
Can I use the FTS extension for sqlite from within R`?
91 Views Asked by Karsten W. At
1
Sqlite comes with support for full text special tables. Is it possible to use these features from within R, e.g. from RSQLite
?
Found the answer by try-and-error:
This shows "ENABLE_FTS3" and "ENABLE_FTS5". So it seems the extensions are activated by default.
Small test example:
The last query returns the rows 1 and 2.
Nice!