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