Remix.run Logo
FooBarWidget 4 hours ago

I've found FTSE5 not useful for serious fuzzy or subword full text search. For example I have documents saying "DaemonSet". But if the user searches for "Daemon" then there will be no results.

ers35 an hour ago | parent | next [-]

Use the trigram tokenizer: https://www.sqlite.org/fts5.html#the_trigram_tokenizer

nikisweeting 3 hours ago | parent | prev | next [-]

I have found this as well, FTSE5 is convenient to have as an option, but it's not as versatile as postgres or sonic or other full-text search solutions.

Does anyone have any other favorite modern bloom-filter-based search solutions that dont need to store copies of all the documents in the search db? Ideally something that can run in WASM too so we can ship a tiny search index to the browser. I found https://github.com/tinysearch/tinysearch but haven't tried it yet.

yomismoaqui 3 hours ago | parent | prev [-]

Doesn't this work ok?

https://www.sqlite.org/fts5.html#fts5_prefix_queries