Re: Cheap (or open source) RDB for Windows compatible with WO ...
"Dirk Olmes" <[email protected]> Wed, 25 Feb 2004 10:11:18 +0100 (MET)
| Newsgroups | gmane.comp.web.webobjects.eof,gmane.comp.web.webobjects.devel |
|---|---|
| Message-ID | <41713.62.225.152.1.1077700278.squirrel@localhost> |
> So far, I like MySQL, it's free, very fast, and its "shortcomings" may > indeed be features that you do not need when the sophisticated EOF in > WO is controlling it with standard ANSI SQL 92. Well, I can't second that opinion. Ever been bitten by the famous default-value-for-not-null-columns "feature"? I didn't invest any more energy in finding out why EOF leaves out columns on insert but moved all of my databases to PostgreSQL. Happy ever since :-) In terms of support, I like the MySQL Windows tools better but postgres tools seem to catch up. One thing that really sucks about PostgreSQL ist the need for VACUUMs, even if you can do it in parallel to normal operations now. -dirk