#120 Thinking Sphinx

Jul 28, 2008 | 12 minutes | Active Record, Plugins, Search

If you need a full text search engine, Thinking Sphinx is a great solution. See why in this episode.

Click to Play Video ▶

Download:
source codeProject Files in Zip (94.8 KB)
mp4Full Size H.264 Video (19.5 MB)
m4vSmaller H.264 Video (13.3 MB)
webmFull Size VP8 Video (34.2 MB)
ogvFull Size Theora Video (28 MB)

Browse Source Code

There is a newer version of this episode, see the revised episode.

Resources

          bash
        
script/plugin install git://github.com/freelancing-god/thinking-sphinx.git
rake thinking_sphinx:index
rake thinking_sphinx:start

          models/author.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, created_at
end

          articles_controller.rb
        
@articles = Article.search params[:search]
# :include => :author 
# :conditions => { :created_at => 1.week.ago.to_i..Time.now.to_i }
# :order => :name
# :field_weights => { :name => 20, :content => 10, :author_name => 5 }
# :match_mode => :boolean
# :page => 1, :per_page => 20

Full Source Code