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

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

On Fri, Oct 12, 2012 at 3:44 AM, Erwin [email protected] wrote:

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.

On Thursday, 11 October 2012 13:45:02 UTC-4, Erwin wrote:

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 ?

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:

–Matt J.

On Thu, Oct 11, 2012 at 12:44 PM, Erwin [email protected] wrote:

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, …)

http://tenderlove.github.com/texticle/

On Fri, Oct 12, 2012 at 8:24 AM, Jordon B. [email protected]
wrote:

Depending on what you’re looking for, Sunspot may be useful

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

What does that last sentence mean? Solr is FOSS.


Hassan S. ------------------------ [email protected]

twitter: @hassan

On Friday, 12 October 2012 09:12:45 UTC-5, Matt J. wrote:

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:

#278 Search with Sunspot - RailsCasts

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.

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:

Full text search on Heroku -- for FREE!

-Dave


Dave A., T. Rex of Codosaurus, LLC… aka
Available Secret-Cleared Ruby/Rails Freelancer
(NoVa/DC/Remote); see http://www.Codosaur.us/.

On Fri, Oct 12, 2012 at 7:12 PM, Jordon B. [email protected]
wrote:

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 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.

Hassan S. ------------------------ [email protected]

twitter: @hassan

On Fri, Oct 12, 2012 at 4:40 PM, Hassan S.
[email protected] wrote:

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.

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.
Am 13.10.2012 14:01 schrieb “Hassan S.”
[email protected]: