
MySQL (or Postgres) does a fine job when querying specific rows, but it’s not so great when it comes to searching on large text fields. Sphinx is a search service that makes full text searching quite easy and throws in extra features like boolean search (“rails OR merb”), word proximity, and custom filtering.
Pat Allan is the author of the popular Thinking Sphinx plugin for Rails (and Merb apps that use ActiveRecord!). He also wrote the Riddle gem for lower level interaction with Sphinx. Pat starts out by introducing the basic features of Sphinx, then dives straight into installation on popular platforms.
In this 60-page PDF you’ll learn to build an address book with Thinking Sphinx starting with simple searches then progressing onto filtered, sorted, and delta-based searches. You’ll learn about the geo-searching features of Sphinx, including integration with Google Maps.
He closes out the book with a 20-page reference that you’ll want to keep close as you use the more advanced features of Sphinx.
If you use MySQL or Postgres databases with text fields, this book will teach all you’ll need to know to work confidently with Sphinx.
Included for all PeepCode Unlimited subscribers or available as a single purchase for only US$9!


Assumes a basic knowledge of the ActiveRecord Ruby gem with either Ruby on Rails or Merb.
Revision 1 (Notes) · Updated: Oct 24, 2008 · Length: 61 pages · 100 MB
“PeepCode is awesome!” Tim O'Reilly, O'Reilly Media
“I suspect there are a lot of smart DF readers out there who know nothing about the Unix-y aspects of Mac OS X, would like to, but never found a good way to get started. This screencast is it.” John Gruber, Daring Fireball
“These things are fantastic and the price is a steal. I strongly urge you to support this effort and buy the episodes. What a terrific way to learn!” Scott Barron, Rails Core Committer
“All the PeepCode screencasts are nothing short of awesome. Reading is one thing, but learning from [your screencasts] is enabling me to learn new things and advance like never before.” Todd Boteler
“I wanted to catch up with functional programming, watched PeepCode's screencast on Clojure, best one so far (and I have seen them all)” wearecloud
Login or signup and enter the code on your account page. If it is still valid you will be able to browse the list of products and redeem an episode.