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
On Sep 20, 2011, at 8:47 AM, Russell C. 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, Id 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:
Walter
Thanks, I’ll have a look into those.
On Sep 20, 8:47am, Russell C. [email protected] 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 J.