Thanks for that! A couple of days ago I used meilisearch for a quick proof of concept, but I'll check out tantivy again via your repo.
I basically just need a fulltext search.
I basically just need a fulltext search.
https://www.postgresql.org/docs/current/textsearch.html
https://www.crunchydata.com/blog/postgres-full-text-search-a...
I'm not saying PostgreSQL's functionality is useless, but if you need ranking based on the relative frequency of a term in a corpus, then I don't believe PostgreSQL can handle that unless something has changed in the last few years. Usually the reason to use something like Lucene or Tantivy is precisely for its ranking support that incorporates inverse document frequency.