[Rails] Re: Full-text search

[Gleb Arshinov]

>>>>> "Scott" == Scott Barron <scott at elitists.net> writes:

    Scott> However, I would be interested in hearing about a more
    Scott> generic solution that can work the same on boty MySQL and
    Scott> PostgreSQL.  I'd like to add full text search to both of my
    Scott> "public" rails projects but I don't want to have to hack
    Scott> around different methods for pg vs mysql.  I haven't
    Scott> checked out OTFS, but I'll give that a look over.  Any
    Scott> other ideas?  Just usign LIKE is OK, but, at least with
    Scott> tsearch2, you can get sexier with rankings and
    Scott> relativeness, etc.  I want sexification.


Hmm, I coded a simple LIKE solution for MySQL a while back:
http://rubyonrails.org/show/FullTextSearch (go back one revision,
latest one is screwed up).  I really should generalize it to
PostgreSQL/SQL92 (different LIKE semantics and escaping) and submit it
as a patch.

Not really what you are looking for, I know, but maybe still useful.

Gleb