Just Try To Be a Blogrammer

What’s Ultrasphinx ? Ultrasphinx is ruby on rails plugin that utilize Sphinx, the open source Full text search engine, why we need another 3rd party library to query our database ?, it’s because Ultrasphinx fairly fast and easy to use, last week i’ve tried to install it on My lovely Werewolf, then here it is :

Install mysql server and mysql devel

sudo yum install mysql-server mysql-devel

some note : sphinx use mysql-devel to interfacing with mysql databases, for first time, i am very frustrating to compile it on my werewolf and people got the same problem like me too, so after hours + cofeemix and searching on the internet, fortunately i got the saviour, … mysql-devel of course

download sphinx

wget http://www.sphinxsearch.com/downloads/sphinx-0.9.8-rc2.tar.gz

configure and install it

tar -xzf sphinx-0.9.8-rc2.tar.gz
cd sphinx-0.9.8-rc2
./configure
make
make install

create log folder

mkdir -p /var/db/sphinx/log
chmod -R 777 /var/db/

install chronic gem

gem install chronic

go to your RAILS_ROOT directory and install ultrasphinx plugin

ruby script/plugin install svn://rubyforge.org/var/svn/fauna/ultrasphinx/trunk

congratz, ultrasphinx already installed on your rails application, then after this i will show you a little example how to implement that

say you have User model and you want the app be able to search name, email and address easily

class User< ActiveRecord::Base
  is_indexed :fields => [’name’, ‘email’,'address’]
end

configure and start ultrasphinx daemon

rake ultrasphinx:bootstrap

or

rake ultrasphinx:configure
rake ultrasphinx:daemon:start

run the indexer

rake ultrasphinx:index

note : Sphinx is a asynchronous search engine, so it is necessary to reindex your data periodically, so perhaps you need to re-index that 10-20 minutes a time, you can make cronjob for this

execute rails console and ultrasphinx on user model

ruby script/console

@search_user = Ultrasphinx::Search.new(:query => “aditya”)
@search_user.run
@search_user.results

DONE and for your reference, here i put rake command that related to ultrasphinx

rake ultrasphinx:bootstrap = Bootstrap a full Sphinx environment
rake ultrasphinx:configure = Rebuild the configuration file for the first time
rake ultrasphinx:daemon:restart = Restart the search daemon
rake ultrasphinx:daemon:start = Start the search daemon
rake ultrasphinx:daemon:status = Check if the search daemon is running
rake ultrasphinx:daemon:stop = Stop the search daemon
rake ultrasphinx:index = Reindex and rotate all indexes.
rake ultrasphinx:index:delta = Reindex and rotate the delta index.
rake ultrasphinx:index:main = Reindex and rotate the main index.
rake ultrasphinx:index:merge = Merge the delta index into the main index.
rake ultrasphinx:spelling:build # Rebuild the custom spelling dictionary.

Credit :
thank’s to Nikada team for the help