Forum: Ruby on Rails Fulltext index?

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
7b74ccf93dde7dd2ac5d2980d14fdc7b?d=identicon&s=25 Paul Lynch (plynchnlm)
on 2007-05-08 22:35
(Received via mailing list)
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?

Ef0db53920b243d6758c2f6b1306df0d?d=identicon&s=25 Steve Ross (cwd)
on 2007-05-09 00:30
(Received via mailing list)
Depending on your needs, you can do full text searching using ferret
(, 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.


This topic is locked and can not be replied to.