Re: [PHP] MySQL vs PostgreSQL

[Sean Burlington]

Youy are unlikely to egt balanced asvice on this in the MySQL or Postgress lists -after all those people have already made thier decision.

I haven't used Postgress much - but basically...


Mysql - available on loads of hosting packages, very large user base.

PostgreSQL - better adherance to ANSII standards, resulting in more portable code.
Implements VIEWS, subselects and foriegn keys.

Mysql is faster (as long as you don't need the missing features)
It is better established, and things like subselects are being worked on, foriegn keys are already partially implemented.

The docs for both projects have sections on camparing to the other (I think they both cheat a bit and compare thier newest version to a slighlty older version of the other project)

Sean


Rick Emery wrote:

You accidentally published this to the wrong email list.  I assume you meant to send this
to the MySQL email list.

----- Original Message -----
From: "Miro Kralovic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 23, 2002 9:10 AM
Subject: [PHP] MySQL vs PostgreSQL

Hi,

I'm just deciding which DB to use for my projects and I'm not clear with one
thing... When considering a database for web, is MySQL good enough? I read
it only supports table locking, which is not very satisfying in such a
multiuser environment as the internet..

Based on your experience, what are pros and cons of MySQL and why most of
you prefer to use MySQL to PostgreSQL, which is aparently more powerful..

Thanks for your opinions..
Miro..



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php