New to LAMP

[Aly S.P Dharshi]

I am not for a minute claiming that MySQL is not robust, all I am saying 
- clarifying - is that PostgreSQL has way more features than does MySQL, 
and its "Oracle like" to some extent as it is unique.

Some highlights in my opinion are:

 	- Very nice licensing (BSD)
 	- Ability to write store procedures in Perl, Python, Java, PHP etc
 	- Runs natively on Windows, and *nix (so does MySQL)
 	- Tablespaces support
 	- Upcoming version 8.1 has roles
 	- A procedural language PL/pgSQL
 	- Triggers
 	- Very ACID compliant
 	- ODBC and JDBC support
 	- .NET drivers

All of these features are available now in PostgreSQL and are not quite 
readily available - some or most of them - in MySQL. Also check out:

http://www.postgresql.org/about/

Which prolly is more accurate.

Cheers,

Aly.

On Tue, 4 Oct 2005, Andrew B. Young wrote:

> I am very interested in other's opinions on MySQL v. PostgreSQL.
> Four years ago I brought up an app on PostgresSQL and have be quite satisfied 
> by it.
> However it seems that MySQL has much more market share and so is presumably 
> just as robust.
> By googling for the answer just yields fluff articles.
> tx,andyy
>
> Aly S.P Dharshi wrote:
>
>> I would suggest PostgreSQL over MySQL for "LAMP" projects, its a way more 
>> mature database then MySQL. And its what RedHat will support you on readily. 
>> Other's may have varying opinions on this.
>> Cheers,
>> Aly.
>
>
>

-- 
Aly S.P Dharshi
aly.dharshi at telus.net

 	 "A good speech is like a good dress
 	  that's short enough to be interesting
 	  and long enough to cover the subject"