Archives Oct. 3, 2009

PostgreSQL/SQLAlchemy/TurboGears search

PostgreSQL 8.3+ has integrated the old tsearch2 plugin into the distribution.  This lets you do very formal "stemmed" textual queries on a body of text (set of columns in a table).  For instance, imagine we have a table "version_text" that stores all of the text in our version control system in the "text" column ...

Continue reading

Previous day

Sept. 27, 2009

Next day

Oct. 4, 2009

Archives