Excellent read. Was searching for a full text search engine but not finding any suitable one. Plan to implement one just this way.

SQLite has a pretty good built-in fts engine: https://www.sqlite.org/fts5.html

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.