Re: Best database for web backend on Linux?

In comp.databases.informix Andrew Gideon <werdnaandrew_at_tagsys.commoc.sysgat> wrote:
: If you're using VARCHAR/TEXT, though, you may be missing a factor.
: That is the "searchability" of these textual fields. I don't mean
: whether or not it is possible (of course it is), but how efficiently
: it can be done. In other words, is there a mechanism for doing fuzzy
: or partial matches (ie. like a glimpse db) that exploits indexing?
 

: There are engines (ie. excite or glimpse) that are good at full
: text searching. But these are tough to combine with the structure
: available in a relational database. Yet that is exactly what we need
: in many situations (and I doubt that we're alone).

PostgreSQL 6.4, to be released on November 1, adds this search ability to text/varchar fields. It is in /contrib/fulltextindex, and it in the current beta on ftp.postgresql.org.

Because we are an Object/Relational database, it was not that hard to do.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  root_at_candle.pha.pa.us                |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026