I would agree with Adam. Postgres is much more mature when it comes to database transactions and it's what is underneath my OpenSource Point of Sale system. If you application requires absolute data integrity you'll want PostgreSQL for peace of mind.
Jeff Leinen -----Original Message----- From: Adam Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:54 AM To: [EMAIL PROTECTED] Subject: Re: [sclug-general] SQL Database Servers? I have used MySQL and Postgres. MySQL is alright, though if you want "advanced" features such as unions you have to use the "unstable" release of MySQL as the current stable release does not offer this. It can be worked around.. but it is kind of a pain. Postgres seems much more refined than MySQL, very similar though. I haven't tested either in a high volume environment, but I would go with postgres out of the choice of those two. Also, it is very easy to develop applications that integrate with either of these. I am sure it is the same with the other dbs, but just thought I would mention that. Adam Johnson ----- Original Message ----- From: "Matthew K. Lee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 22, 2003 11:35 PM Subject: [sclug-general] SQL Database Servers? Does anyone know a good website that lists the pros & cons of the different database servers? Ideally, I am looking for a site which compares features, reliability, speed, and cost of Microsoft SQL Server, MySQL, Postgres, Oracle, and possibly Sybase. Any experience and/or recommendations would also be welcome. Thanks, Matthew Lee [EMAIL PROTECTED] (507) 532-2488
