3 ms·
SQLite has a pretty good built-in fts engine: https://www.sqlite.org/fts5.html https://www.sqlite.org/fts5.html
by rakoo 6y ago
SQLite has a pretty good built-in fts engine: https://www.sqlite.org/fts5.html https://www.sqlite.org/fts5.html
- habibur 6y agoProblem is FTS5 isn't included in the most default installation through package managers [I use Fedora]. And recompiling from source breaks a lot of things, as sqlite libraries are generally linked with all apps that use it.
- rakoo 6y agoI admit I only used sqlite through the go driver (https://github.com/mattn/go-sqlite3 https://github.com/mattn/go-sqlite3) where using fts5 amounts to one flag during the compile phase.
- edwinyzh 6y agoBut SQLite's FTS5 has no support for the `offsets` function...