I like both Postgresql and MySQL. But I have built applications using even
MySQL 3.23 (no transaction support). It is solid, robust and the
connectivity is great.
I think the transactional support is still a tryout in v4.x but MySQL is
widely used and it is gaining steam.
I like the engineering of Postgresql. It looks like the full-fledged
database to me. I bought a tome on it and loved reading about the
features.
I developed a student registration system using MySQL. Never once we had
problems.
David Boyes <[EMAIL PROTECTED]>
Sent by: Linux on 390 Port <[EMAIL PROTECTED]>
02/09/2004 05:33 PM
Please respond to Linux on 390 Port
To: [EMAIL PROTECTED]
cc:
Subject: Re: Newbee question
> We are about to set up our environment utilizing the
> Linux-399 environment.
> We currently are using Microsoft sql database on windows
> platforms. We would
> like to move off it and onto a Linux sql database. Does
> anyone have any
> experience using a Linux platform sql database other than
> interfacing with
> DB2 or Oracle? The database is used for meta-data and
> transaction processing
> is not a requirement.
We have successfully used both MySQL and Postgres for different projects.
MySQL is probably slightly faster but (as of MySQL 4.x) both have
transactional capabilities. I'm told by our apps guy that the MySQL
toolset
is easier to use; I find the Postgres tools more familiar if you're used
to
DB/2 or Oracle.
The industry seems to be leaning toward MySQL (cf LAMP --
Linux/Apache/MySQL/PHP). Both MySQL and Postgres have been reliable and
stable.
-- db
