On 22.1.2008, at 23.46, Peter Vandenabeele wrote: > > Ericson Smith wrote: >> If you consider using Postgresql, then tsearch2 is awesome. Its built >> into the latest version of Postgresql. > > How would you do the integration into Rails 2 ? > > I tried the acts_as_tsearch plugin > > http://code.google.com/p/acts-as-tsearch/ > > and the first line of the example works, but it really > does not seem to be ready for prime time to me and at > this moment ...
I haven't used the plugin, but interfacing with tsearch2 is easy enough so you can write your own in a day: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ We did that back in early '06 and since talking with tsearch2 is basically normal SQL, all you have to do is to write a custom finder method. I have no idea how the performance compares to other engines but I find it pretty cool that everything happens transparently inside the database so you have one less process to monitor and keep fresh. So if you're using PostgreSQL, it should definitely be worth a shot. It's been around forever, so it should be void of most pediatric diseases. Cheers, //jarkko -- Jarkko Laine http://jlaine.net http://dotherightthing.com http://www.railsecommerce.com http://odesign.fi --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Deploying Rails" group. To post to this group, send email to rubyonrails-deployment@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-deployment?hl=en -~----------~----~----~----~------~----~------~--~---
