Greetings, Which gems are good for searching textual data? I had a look into searchlogic but it appears to just dynamically create SQL LIKE statements, I''d like something that provides better/more relevant results to the user. Thanks, Russell -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Sep 20, 2011, at 8:47 AM, Russell Cole wrote:> Greetings, > > Which gems are good for searching textual data? I had a look into searchlogic but it appears to just dynamically create SQL LIKE statements, I’d like something that provides better/more relevant results to the user.For a quick search (find author by name), often that''s all that you need. But for more complex contextual searching, that''s going to depend a lot on the database you''re using. MySQL has a full-text search method, but it only works on MYISAM tables, so that means no transaction support. Other databases have similar systems, I''m sure. Usually you step a few layers above that and use something like Sphinx or Solr to index your content, and then ask those search services for the answers you need. There are plenty of gems around both of those search engines, too. Have a look here: http://www.ruby-toolbox.com/categories/rails_search.html Walter> > Thanks, > Russell > > -- > 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@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.-- 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@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Thanks, I''ll have a look into those. -----Original Message----- From: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org [mailto:rubyonrails-talk@googlegroups.com] On Behalf Of Walter Lee Davis Sent: 20 September 2011 16:26 To: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org Subject: Re: [Rails] Search Gems On Sep 20, 2011, at 8:47 AM, Russell Cole wrote:> Greetings, > > Which gems are good for searching textual data? I had a look into searchlogic but it appears to just dynamically create SQL LIKE statements, I''d like something that provides better/more relevant results to the user.For a quick search (find author by name), often that''s all that you need. But for more complex contextual searching, that''s going to depend a lot on the database you''re using. MySQL has a full-text search method, but it only works on MYISAM tables, so that means no transaction support. Other databases have similar systems, I''m sure. Usually you step a few layers above that and use something like Sphinx or Solr to index your content, and then ask those search services for the answers you need. There are plenty of gems around both of those search engines, too. Have a look here: http://www.ruby-toolbox.com/categories/rails_search.html Walter> > Thanks, > Russell > > -- > 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@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.-- 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@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en. -- 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@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Sep 20, 8:47 am, Russell Cole <russell.c...-LVvIjLR0h5w@public.gmane.org> wrote:> Greetings, > > Which gems are good for searching textual data? I had a look into searchlogic but it appears to just dynamically create SQL LIKE statements, I''d like something that provides better/more relevant results to the user.I highly recommend checking out Sunspot (http://outoftime.github.com/ sunspot/). Very easy to set up, fast searching and lots of ways to tweak the results you get for relevance. --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@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.