[GRLUG] DBMAIL

Adam Tauno Williams awilliam at whitemice.org
Fri Jul 17 07:38:07 EDT 2009


On Thu, 2009-07-16 at 22:19 -0400, Ben DeMott wrote:
> I've implemented FAST full text search quite a few times.
> Postgre's is great at it, and it's built in and simple to use.

Agree.  And as a plug for Python's SQLalchemy - using PostgreSQL it
automatically generates text-search syntax for 'match' operations.

session.query(Contact).filter(Contact.firstName.match('Adam'))

- generates -  

 WHERE person.name @@ to_tsquery(%(name_1)s)



More information about the grlug mailing list