Re: Best database for web backend on Linux?

In comp.databases.informix Andrew Gideon <werdnaandrew@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@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