Ask HN: Have you used SQLite as a primary database?

Re:Ask HN: Have you used SQLite as a primary database? by lep on Monday April 25, 2022 @08:18AM (#31153417)

I'm also using fts5 for some small projects but i haven't looked too deeply into it so i'm wondering if you have any interesting insights. Like what kind of index/options do you use? Maybe the trigram index? And your "across boundaries" mode is just word* in fts syntax?

[ Parent | on HN ]

Re:Ask HN: Have you used SQLite as a primary database? by ajani on Tuesday April 26, 2022 @04:30AM (#31165235)

Yes. Acute observation. It’s actually two separate indexes. A trigram index for sub word searching. Word* is exactly right and the other is a Unicode61 index with porter stemming (also remove diacritics). Trigram tends to work well with abbreviations and such. Whereas porter works well for general searches.

[ Parent | on HN ]

Re:Ask HN: Have you used SQLite as a primary database? by lep on Tuesday April 26, 2022 @05:30AM (#31165499)

Interesting. I might play around using two indexes and try to combine both search results. This could be nice for my less technical users.

[ Parent | on HN ]