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

[Erwin]

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

[Jordon Bedwell]

On Thu, Oct 11, 2012 at 12:44 PM, Erwin <yves_...@mac.com> 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, ..)

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

[Erwin]

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

On 11 oct, 19:51, Jordon Bedwell <envyge...@gmail.com> wrote:

[Jim Ruther Nill]

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

 

thanks for feedback

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonra...@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
-------------------------------------------------------------
visit my blog at http://jimlabs.heroku.com

[Matt Jones]

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 

[Jordon Bedwell]

On Friday, 12 October 2012 09:12:45 UTC-5, Matt Jones 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:

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

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.

[Hassan Schroeder]

On Fri, Oct 12, 2012 at 8:24 AM, Jordon Bedwell <envy...@gmail.com> 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 Schroeder ------------------------ hassan.s...@gmail.com
http://about.me/hassanschroeder
twitter: @hassan

[Jordon Bedwell]

On Fri, Oct 12, 2012 at 4:40 PM, Hassan Schroeder
<hassan.s...@gmail.com> 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.

[Dave Aronson]

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

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

[Hassan Schroeder]

On Fri, Oct 12, 2012 at 7:12 PM, Jordon Bedwell <envy...@gmail.com> 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.

[Norbert Melzer]

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.