I agree with you on every step and every point except the LM. Your entire argument hinges on FTS requiring a fat RDBMS. This is not the case.
Postgres is what I have experience with, but I just looked up SQLite and indeed it has FTS5[1]. This is not an LM-grade problem, this is a solved problem.
I agree with you on every step and every point except the LM. Your entire argument hinges on FTS requiring a fat RDBMS. This is not the case.
Postgres is what I have experience with, but I just looked up SQLite and indeed it has FTS5[1]. This is not an LM-grade problem, this is a solved problem.
[1]: https://www.sqlite.org/fts5.html