Rails - Oct 2012 - 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

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

On Thu, Oct 11, 2012 at 12:44 PM, Erwin
<yves_dufour-ee4meeAH724@public.gmane.org> 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/

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

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...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> On Thu, Oct 11, 2012 at 12:44 PM, Erwin
<yves_duf...-ee4meeAH724@public.gmane.org> 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_searchhttp://tenderlove.github.com/texticle/
-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

On Fri, Oct 12, 2012 at 3:44 AM, Erwin
<yves_dufour-ee4meeAH724@public.gmane.org> 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.

>
> 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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> To unsubscribe from this group, send email to
>
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

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

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

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:

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


--Matt Jones 

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/gvulhcVGBrEJ.
For more options, visit https://groups.google.com/groups/opt_out.

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.

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/c3s0O3DlVXUJ.
For more options, visit https://groups.google.com/groups/opt_out.

On Fri, Oct 12, 2012 at 8:24 AM, Jordon Bedwell
<envygeeks-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
http://about.me/hassanschroeder
twitter: @hassan

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

On Fri, Oct 12, 2012 at 4:40 PM, Hassan Schroeder
<hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
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.

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

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

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

On Fri, Oct 12, 2012 at 7:12 PM, Jordon Bedwell
<envygeeks-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 Schroeder ------------------------
hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
http://about.me/hassanschroeder
twitter: @hassan

-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

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 Schroeder"
<hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>:
> On Fri, Oct 12, 2012 at 7:12 PM, Jordon Bedwell
<envygeeks-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
> 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 Schroeder ------------------------
hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
> http://about.me/hassanschroeder
> twitter: @hassan
>
> --
> 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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> To unsubscribe from this group, send email to
>
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
-- 
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.