News for hackers. Stuff that matters.

A comment on Ask HN: Have you used SQLite as a primary database?. Parent comment

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 ]