Ask HN: Are Lucene/Solr/ES Still Used for Search?

Re:Ask HN: Are Lucene/Solr/ES Still Used for Search? by porker on Friday July 19, 2019 @03:35PM (#20481769)

This has been a great thread, and there's some heavyweight indexes here. But what about at the other end of the scale?

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?

[ Parent | on HN ]

Re:Ask HN: Are Lucene/Solr/ES Still Used for Search? by noir_lord on Friday July 19, 2019 @03:39PM (#20481798)

Postgres does lexemes and all that jazz natively.

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.

[ Parent | on HN ]

Re:Ask HN: Are Lucene/Solr/ES Still Used for Search? by karterk on Saturday July 20, 2019 @09:38AM (#20485677)

Yes! Please take a look at an open source search engine I am working on. You will definitely like it:

https://github.com/typesense/typesense

Would love to hear your feedback :)

[ Parent | on HN ]

Re:Ask HN: Are Lucene/Solr/ES Still Used for Search? by rpedela on Friday July 19, 2019 @10:14PM (#20483780)

What's wrong with running Solr/ES? It is trivial to run either in standalone mode, and it is a lot easier to set up autocomplete with misspelling support than messing with PG. Algolia is a good option if you have the budget.

[ Parent | on HN ]

Re:Ask HN: Are Lucene/Solr/ES Still Used for Search? by porker on Saturday July 20, 2019 @03:10AM (#20484554)

> What's wrong with running Solr/ES?

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.

[ Parent | on HN ]

Re:Ask HN: Are Lucene/Solr/ES Still Used for Search? by mohaine on Friday July 19, 2019 @03:42PM (#20481815)

Lucene should work great for this use case. It has been awhile but I have successfully used it for this exact use case.

[ Parent | on HN ]

Re:Ask HN: Are Lucene/Solr/ES Still Used for Search? by samsk on Friday July 19, 2019 @03:47PM (#20481855)

With Postgresql you can use pg_trgm, might be not as powerful as what SOLR/ES provides, but easier to run.

[ Parent | on HN ]

Re:Ask HN: Are Lucene/Solr/ES Still Used for Search? by peterdm on Saturday July 20, 2019 @11:19PM (#20489778)

Upvoted. This is how Postgres supports "fuzzy searching" which helps with misspellings. https://www.rdegges.com/2013/easy-fuzzy-text-searching-with-...

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.

[ Parent | on HN ]

Re:Ask HN: Are Lucene/Solr/ES Still Used for Search? by softwaredoug on Friday July 19, 2019 @03:42PM (#20481820)

This is a great niche for Algolia, instant fuzzy 'autocomplete' style search of short strings

[ Parent | on HN ]