Rails Search Index: Sphinx or Solr?

We're on Rails hosted by Heroku. I'm not a great dev and haven't had experience with Solr or Sphinx. We have开发者_Go百科 a Postgres db and some documents, and want to add a fast, fuzzy-ish search against them (mostly just the db).

Any cons to either? Endorsements? Thanks!

Here are a few previous discussions on Stack Overflow:

• Choosing a stand-alone full-text search server: Sphinx or SOLR?
• solr or sphinx? which is better?

Solr is the larger and older project, and may have more/better support for advanced search features down the road, but for the case you describe, it's a tossup. It comes down to a choice between the Sunspot Solr client and the Thinking Sphinx client, both of which are excellent.

I can certainly put in an endorsement for the Websolr addon on Heroku, but it's a bit biased because I run it ;) In fact, ours was one of the first Heroku addons launched, back in the summer of 2009.

For a 'non-great developer' i'd suggest Sunspot. Then you don't need to care 1) about reindexing except the cases when you update your source code 2) about manual installing 3) you can use SQLite for testing