4 ms·
Found recently Tantivy inside of ParadeDB (Postgres extension aiming to replace Elastic) https://github.com/paradedb/paradedb/blob/dev/pg_search/Cargo.toml#L44
by adeptima 2y ago
Found recently Tantivy inside of ParadeDB (Postgres extension aiming to replace Elastic)
https://github.com/paradedb/paradedb/blob/dev/pg_search/Cargo.toml#L44C48-L44C55 https://github.com/paradedb/paradedb/blob/dev/pg_search/Carg...
after listening
Extending Postgres for High Performance Analytics (with Philippe Noël)
https://www.youtube.com/watch?v=NbOAEJrsbaM https://www.youtube.com/watch?v=NbOAEJrsbaM
And inside of the main thing - Quickwit(logs, traces, and soon metrics)
https://github.com/quickwit-oss/quickwit https://github.com/quickwit-oss/quickwit
Had a surprisingly good experience with combined power of Quickwit and Clickhouse for multilingual search pet project. Finally something usable for Chinese, Japanese, Korean
https://quickwit.io/docs/guides/add-full-text-search-to-your-olap-db https://quickwit.io/docs/guides/add-full-text-search-to-your...
to_tsvector in PG never worked well for my use cases
SELECT * FROM dump WHERE to_tsvector('english'::regconfig, hh_fullname) @@ to_tsquery('english'::regconfig, 'query');
Wish them to succeed. Will automatically upvote any post with Tantivy as keyword
- fulmicoton 2y agoThank you so much for sharing!!!
- tarasglek 2y agoThat's a cool design pattern combining url/rest based index and doing the search query entirely within sql. Can do same thing in postgres fdw