News for hackers. Stuff that matters.

A comment on Postgres full text search is good enough.

Re:Postgres full text search is good enough by bshimmin on Monday September 29, 2014 @04:02AM (#8382018)
It's awesome what you can do with Postgres, undeniably, but it seems to me that if you're building a Rails app, for instance, it's an absolute no-brainer to use the brilliant Sunspot gem with Solr. Yes, you have the moderate unpleasantness of setting up Solr and fiddling about with Java and XML files, but it's all pretty painless after that.

I don't know if similarly nice things exist for other web frameworks.

As others have said, what's described in the OP may well be "good enough" for many purposes but it seems like quite a lot of effort to get there.

[ Parent | on HN ]
Re:Postgres full text search is good enough by mctx on Monday September 29, 2014 @05:25AM (#8382165)
Django has haystack[0], which I've used with an elasticsearch backend on a few projects and is generally pretty easy to set up and get good results with. I haven't had to do anything more advanced than autocomplete/boost/spelling suggestions, but from what I've read it seems pretty powerful.

[0]: http://haystacksearch.org/

[ Parent | on HN ]
Re:Postgres full text search is good enough by rorydh on Monday September 29, 2014 @11:58AM (#8383470)
Check this out for your app: https://github.com/Casecommons/pg_search

It's basically all that stuff minus the complexity of configuring it up for a rails app.

[ Parent | on HN ]