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 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!


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

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 4 | next ›
Discussion Overview
groupdbix-class @
categoriesperl, catalyst
postedFeb 16, '12 at 1:03a
activeFeb 16, '12 at 8:08p



site design / logo © 2021 Grokbase