Ditto to postgres.
I agree with you. In my experience, the more complex the more compelling
reason to go with postgres. Agreed.. mySQL is faster for simple queries.
In my application I did comparisons in mySQL and postgres and to my
amazement overall postgres was faster. The reason was similar
I would go for postgresql.
Reasons?
triggers,procedures,a speed almost equal to mysql.
they say mysql is faster.
In my experience, only the simplest sites take advantage of this great
speed.
Once, in a web-page I had 2 sql queries to a Postgresql engine
and I had to re-write the code for Mysql: