Re: MySQL vs PostgreSQL

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