3 ms·
I'm a big fan of FTS5 as a cheap/easy way of adding full text search to datasets. Recently I've been storing these datasets in S3 and been querying them direct
by psanford 3y ago
I'm a big fan of FTS5 as a cheap/easy way of adding full text search to datasets.
Recently I've been storing these datasets in S3 and been querying them directly via a VFS[0]. Its a simple way to have FTS available to lambda functions without the cost of using an online database.
[0]: https://github.com/psanford/sqlite3vfshttp https://github.com/psanford/sqlite3vfshttp
- fmajid 3y agoI use it for my blog's search function: https://github.com/fazalmajid/fts5index https://github.com/fazalmajid/fts5index Their default syntax is not great, so I wrote a converter from Google syntax to theirs.