News for hackers. Stuff that matters.
Re:Thoughts on Algolia vs. Solr and Elasticsearch by mozumder on Saturday June 11, 2016 @11:01PM (#11886415)
Why would one use Algolia over Postgres's built in text search features? Ex: http://rachbelaid.com/postgres-full-text-search-is-good-enou...

I already have Postgres search queries running on the order of 1-3ms for large queries, basically faster than Algolia, with seemingly the same feature sets.

I don't understand the value proposition over something like Postgres, for sites that already have Postgres databases. (And I'm sure other databases might offer similar built-in search capabilities, I just don't know those other RDBMSs)

Re:Thoughts on Algolia vs. Solr and Elasticsearch by forgotpwtomain on Sunday June 12, 2016 @01:33AM (#11886792)
> Why would one use Algolia over Postgres's built in text search features? Ex: http://rachbelaid.com/postgres-full-text-search-is-good-enou....

Postgres built-in search features are really for large document searching -- we've tried using it for indexing e.g. an array of tags for auto-complete and the search times were in the ~500ms+ range, as a matter of fact the non-indexed regex search was only slightly slower. I thought the later was rather surprising - but asking on the mailing-lists, I was told that this was basically working as intended.

edit: I don't fully understand the value-proposition of Algolia either, most of the trouble with going outside of your production database for search - is the problem of keeping your data in sync and current with the production database; compared to that setting up an Elasticsearch cluster really isn't such a big deal, there are also half-way solutions, for example Amazon has an Elasticsearch-service.

Re:Thoughts on Algolia vs. Solr and Elasticsearch by jlemoine on Sunday June 12, 2016 @04:23AM (#11887213)
I would recommend to read this post to have an idea: https://blog.algolia.com/inside-the-algolia-engine-part-3-qu...

Textual relevance is a very complex domain and the Postgres's built in text search features is a simple keyword matching engine compared to Algolia engine that contains a lot of alternative matching. The mesure of textual relevance is also very different of what you have in the Postgres text search.

At the end, this is not only about speed but mainly about relevance

Re:Thoughts on Algolia vs. Solr and Elasticsearch by rpedela on Sunday June 12, 2016 @04:21AM (#11887209)
If Postgres works for you then great, but it doesn't really compare to Solr/Elasticsearch. I haven't used Algolia so I cannot comment on it. Postgres is hard to use beyond very basic keyword searching and it doesn't support many standard features such as phrase search.
Re:Thoughts on Algolia vs. Solr and Elasticsearch by IndianAstronaut on Sunday June 12, 2016 @11:36AM (#11888533)
Interestingly, Solr also can do a lot of database type work. It can store not just documents for text searches, but also for numeric fields, aggregations, pivoting, etc. A nice tool for a data analysis back end. Even the Hue project uses it for its dashboard maker.