search engine

hello all
I am trying to develop a search functionality that performs searchin by user id, searching by name as part of my application in rails3 … could anybody suggest ?

You could just use SQL if your needs are very simple. It’s a straightforward solution, just do a query using LIKE and wildcards, but be careful not to open your app to SQL injection.

If that’s not enough, several databases have full text search, which may or may not be good.

The next step is to use something like Sphinx to index your data, but here it becomes quite complex.

use thinking-sphinx gem

Yes, of course, thinking-sphinx… well there are other gems but I haven’t tried them. Even then, you have to maintain Sphinx itself running, which sometimes can be a pain.