Say when you've got 10k-50k contact details (name, email, phone) and you want to provide a quick, autocomplete lookup. I've used basic SQL string matching for this, but it doesn't catch mis-spellings and the rest.
Running SOLR or ES is overkill for this. Is there a tool that fits this niche?
You want to be looking for tsvector related stuff.
I used it a few years ago to do full text search on a smallish website and it was great, I gather it has improved further since.
https://github.com/typesense/typesense
Would love to hear your feedback :)
With this small quantity of data, usually the app's running on a small VM. I'm wary of running anything Java, having had it require large amounts of RAM before.
That said, I haven't touched JVM stuff for 5+ years.
Completion response-time will be slower than Solr, Elasticsearch, Algolia, etc... but if you're already running Postgres, this may be the fastest to deliver for you.