News for hackers. Stuff that matters.
Re:Building a full-text search engine in 150 lines of Python... by rakoo on Thursday March 25, 2021 @03:21PM (#26584281)
SQLite has a pretty good built-in fts engine: https://www.sqlite.org/fts5.html
Re:Building a full-text search engine in 150 lines of Python... by habibur on Thursday March 25, 2021 @04:18PM (#26584867)
Problem 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.
Re:Building a full-text search engine in 150 lines of Python... by rakoo on Thursday March 25, 2021 @05:24PM (#26585586)
I admit I only used sqlite through the go driver (https://github.com/mattn/go-sqlite3) where using fts5 amounts to one flag during the compile phase.
Re:Building a full-text search engine in 150 lines of Python... by edwinyzh on Thursday March 25, 2021 @10:07PM (#26588091)
But SQLite's FTS5 has no support for the `offsets` function...