#120 Thinking Sphinx (revised)

Dec 09, 2011 | 10 minutes | Active Record, Plugins, Search

Sphinx is a full-text search engine for use with MySQL or PostgreSQL. Learn how to add Thinking Sphinx by defining an index on your model and searching with various options.

Click to Play Video ▶

Download:
source codeProject Files in Zip (85.3 KB)
mp4Full Size H.264 Video (19.7 MB)
m4vSmaller H.264 Video (11.3 MB)
webmFull Size VP8 Video (13.4 MB)
ogvFull Size Theora Video (25.1 MB)

Browse Source Code

Resources

          bash
        
rake ts:index
rake ts:start
rake ts:rebuild
rake ts:reindex

          Gemfile
        
gem 'thinking-sphinx'

          models/article.rb
        
define_index do
  indexes content
  indexes :name, sortable: true
  indexes comments.content, as: :comment_content
  indexes [author.first_name, author.last_name], as: :author_name
  
  has author_id, published_at
end

          articles_controller.rb
        
def index
  @articles = Article.search(params[:search])
  # Search options:
  #   order: :name
  #   page: 1, per_page: 20
  #   conditions: {name: "Batman"}
  #   with: {author_id: 2}
  #   with: {created_at: 3.weeks.ago..Time.zone.now}
  #   field_weights: {name: 20, content: 10, author_name: 5}
  #   match_mode: :boolean
end

          articles/index.html.erb
        
<%= form_tag articles_path, method: :get do %>
  <div class="field">
    <%= text_field_tag :search, params[:search] %>
    <%= submit_tag "Search", name: nil %>
  </div>
<% end %>