4 ms·
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
by FooBarWidget 6mo 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.
- nikisweeting 6mo agoI 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 https://github.com/tinysearch/tinysearch but haven't tried it yet.
- yomismoaqui 6mo agoDoesn't this work ok? https://www.sqlite.org/fts5.html#fts5_prefix_queries https://www.sqlite.org/fts5.html#fts5_prefix_queries
- ers35 6mo agoUse the trigram tokenizer: https://www.sqlite.org/fts5.html#the_trigram_tokenizer https://www.sqlite.org/fts5.html#the_trigram_tokenizer