Looking for a gem that can do full-text-search of active-record tables

Rails
1

Hi All,

I have a table of 500! entries that needs to be used as a pick list,
or a selection list. 500 entries is way overkill for a selection
list, so I am looking for a gem/plugin that can search across
stipulated fields of an AR table or tables.

Any help is appreciated.

2

have a look at thinking_sphinx

http://freelancing-god.github.com/ts/en/

You will need sphinx installed and running but will easily wire up
your AR tables as a search index

Adam