Re: Is my MySQL Gaining ?

Hi all;

Regarding the questions of MySQL and PostgreSQL, I do expect PostgreSQL to
continue to grow more slowly than MySQL for some time. However MySQL has a
few problems in their approach that PostgreSQL lacks, and in time, there is
no doubt in my mind that, of the open source databases available today, that
PostgreSQL will be the winner.

The problems with MySQL's include:
1: Trying to make the database manager tolerant of user errors by avoiding
raising exceptions. PostgreSQL tries to make the database tolerant of user
errors by raising exceptions where appropriate!

2: Maintaining centralized corporate control over everything in the database
manager. This slows their rate of development and we will continue to move
faster than them.

Regarding PHP vs Perl as equivalent to MySQL vs. PostgreSQL, I disagree
completely. PHP has a number of design elements which make it idea for many
types of applications, while Perl's DIFFERENT design concepts make it ideal
for a different set of applications. Many of these are completely opposite
and irreconcilable. Perl and PHP are just to different to compare. I use
both and appreciate both.

MySQL and PostgreSQL are completely different. When I started learning
PostgreSQL, it was a real PITA (version 6.5). I started to learn MySQL
because it was far easier to manage than PostgreSQL was at the time. When I
would develop PostgreSQL apps, I would usually prototype them on MySQL!

But things have changed. PostgreSQL is every bit as easy to use now as MySQL
for most, possibly even all, environments. A Windows port would be nice
(hope it is out soon), but if not, that is what Firebird is for ;-)

Lastly on the need for introspection-- I think we do need introspection.
Not because of any imaginary gains that MySQL has made, but because we will
always do better if we are rethinking and questioning our methodology.
Introspection is always a good thing, and we should not wait for a
competitive need.

Best WIshes,
Chris Travers