[Dbix-class] text search

[Devin Austin]

Postgres allows you to perform full text search using tsearch. That might be worth looking into.

Sent from my iPhone

On Feb 15, 2012, at 6:03 PM, Paolo Gianrossi <paolino.gianrossi at gmail.com> wrote:

> Hi List,
> 
> I have a Schema/Result class holding user stories. These user stories have various fields, most importantly an Owner (foreign key to another class, User), a body (Text) and a "reason" (more text).
> 
> What I need to do is enable my users to search for stories of an owner (typing the username/part of username they want) or for matching keywords inside body and/or reason. This sounds to me very close to fulltext search, but I was wondering if there is a standard/best practice way to manage this need, considering the possibility of changing DB backend (SQLite to MySQL or pgsql probably...)
> 
> Any clues or pointers?
> 
> Thanks a lot!
> 
> cheers
> paolino
> 
> --
> Paolo Gianrossi
> 
> (An unmatched left parenthesis
>  creates an unresolved tension
>  that will stay with you all day
>                                    -- xkcd
> 
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk