Skip to Main Content
Professional Ruby on Rails™
book

Professional Ruby on Rails™

by Noel Rappin
February 2008
Intermediate to advanced content levelIntermediate to advanced
479 pages
14h
English
Wrox
Content preview from Professional Ruby on Rails™

5.3. Searching

If the success of Google proves anything about how to structure information, it's that it doesn't matter how you structure information if your search algorithm is good enough. The difficulty is to create a search system that will catch all the results relevant to the search request without overwhelming the user with irrelevant matches. You also need to present the results to users in such a way that they can tell which results are relevant and which are spurious.

Within Rails, the goal is to search the ActiveRecord objects based on text input that might match one or more fields of the record. For the main text box, you want an unstructured match against multiple fields. You can then provide an advanced search form to specify particular fields to use for the match. This section describes two useful methods for handling a search. One method uses SQL queries. It's simple, and requires nothing beyond the existing ActiveRecord find mechanism. However, it doesn't easily distinguish the importance of the match, and it's hard to add support for Boolean logic in the search.

The second, more complex method uses the Ferret text-indexing tool to support a full-text search. Ferret scores each match based on importance, plus it allows a rich language for logic within the query. However, it requires a Ruby gem, a Rails plugin, and some additional files to support the indexes.

Both methods may have performance issues in high-traffic production sites.

5.3.1. Searching with SQL ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Ruby on Rails® Bible

Ruby on Rails® Bible

Timothy Fisher
Rails 4 in Action

Rails 4 in Action

Yehuda Katz, Rebecca Skinner, Stephen Klabnik, Ryan Bigg

Publisher Resources

ISBN: 9780470223888Purchase book