Is MySQL better than PostgreSQL in something?
- by Massimiliano Torromeo
I know the question sounds provocative but it really isn't.
I'm lately finding MySQL limiting in a lot of areas and liking PostgreSQL more and more.
It scales a lot better and it respects the SQL standards a lot more than MySQL.
I'm still a newbie in the PostgreSQL world though and since I'm willing to move away from MySQL for all my future projects, what I want to know is:
is there any particular feature of MySQL that it is done better (as in more performant or more user friendly etc..) than in PostgreSQL?
I'm wondering what I'm gonna miss from MySQL.
I already found that the AUTO_INCREMENT fields in MySQL are more handy than SEQUENCES in PostgreSQL and the deployment in windows was problematic in the past (not a problem anymore. never a problem for me).
What else?
Thanks.