Rails 3.2 what are the best gems for full-text search in sql db ?

there are a lot of solutions , some gems requiring a separate server
setup...

I need to search for occurrences of some 'text in multiple columns
( :name; :email, :description, ..)

Should I actually setup a SOLr server ?

thanks for feedback

https://github.com/Casecommons/pg_search
http://tenderlove.github.com/texticle/

Thanks , seems to be only for Postgres... I'm using MySQL.. Testicle
seems to be inetresting Oh sorry .. Texticle

there are a lot of solutions , some gems requiring a separate server

setup…

I need to search for occurrences of some 'text in multiple columns

( :name; :email, :description, …)

Should I actually setup a SOLr server ?

I find sphinx easier to setup than Solr. If you’re going to try sphinx, you can use thinking sphinx to setup your indexes.

Depending on what you’re looking for, Sunspot may be useful - I’ve used it for a number of projects that needed full-text seach + filtering etc. There’s a Railscast that should help you get started:

http://railscasts.com/episodes/278-search-with-sunspot

–Matt Jones

I’m gonna definitely second this suggestion if you don’t have PG. I still somewhat like PG to save some money but I love working with solr when I have the chance and I would definitely choose it for a project with sunspot.

What does that last sentence mean? Solr is FOSS.

It means what it means. Obviously you think that Solr runs on Unicorn
farts and not on servers, that or you think that servers are free.

I've been using pg_search, so I could do full text search on Heroku
*for free* (vs. paying for their WebSolr or other full text search
add-ons). However, that has some serious problems, but I've figured
out some workarounds, and made slides for a lightning talk. They're
available at:

  https://www.slideshare.net/dare2xl/full-text-search-on-heroku-for-free/

-Dave

I think that Solr runs on a server, and from my experience, runs just
fine on the *same* server on which the web server stack is running --
hence my confusion why using it should mean extra expense.

YMMV.

Because not everyone has access to his own full featured server. Some have to rent every tiny component from services like heroku. So that’s where the extra expenses come from.