Depending on your needs, you can do full text searching using ferret
(http://ferret.davebalmain.com/trac), which is a Ruby port of Lucene
[1]. This removes the dependency on the MySQL full text indexing
facility. N.b., MySQL only (AFAIK) supports FULLTEXT on MYISAM
tables. The same tables that don''t support transactions.
HTH
[1] http://lucene.apache.org/
On May 8, 2007, at 1:34 PM, Paul E. G. Lynch wrote:
>
> What''s the best way to create a fulltext index on a table column?
I
> was looking at the source of the add_index method, and it looks like:
> add_index(table, column, "FULLTEXT")
> will work (at least for MySQL), but according to the comments in the
> source, that relies on a "legacy support" branch of the code. Is
> there a better way?
>
> Thanks,
> --Paul
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---