I like using Ferret and acts_as_ferret to add full-text search to my models in Rails in a database-independent way. I've had a very difficult time getting this to work smoothly with my deployment process because the ferret server needs to be run in a separate process.