Re: MySQL vs PostgreSQL - Mailing list pgsql-novice

From Gaetano Mendola
Subject Re: MySQL vs PostgreSQL
Date
Msg-id 412B2B44.1020006@bigfoot.com
Whole thread Raw
In response to MySQL vs PostgreSQL  (Kunal <kunaldua@yahoo.com>)
List pgsql-novice
Kunal wrote:

> I know I know, this topic is probably a cliche by now, but I am looking for real world developers'
> and DBAs' experiences from people who have managed/ developed for both.
>
> I've developed for MySQL before but never used PostgreSQL but am interested in doing so. I'll
> probably be giving it a shot myself anyways, but with the newer versions of MySQL offering
> features like views, SPs etc., what makes PostgreSQL worth the switch? I've gone through many
> articles on this topic, but most of them compare features and not experiences which is what I am
> looking for.
>
> Please do spare some time, if possible, to share this knowledge.

You can start to read mysql gotchas and postgresql gotchas:

http://sql-info.de/mysql/gotchas.html
http://sql-info.de/postgresql/postgres-gotchas.html


apparently sql-info.de is unreachable now but I hope will be in a while.


Regards
Gaetano Mendola





pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: authentication
Next
From: Tom Lane
Date:
Subject: Re: sharing temporary tables