[melbourne-pug] Web App Architecture

[Ben Dyer]

Adam,

On 18/03/2012, at 21:40 , Adam MacLeod wrote:

> As a side note, I'd be interested to hear your thoughts about MySQL
> and Postgres? I previously favored MySQL but have been increasingly
> supportive of Postgres and would certainly use it these days.

For us the key benefits of Postgres were the vastly more intelligent query planner and higher level of standards compliance. We use a number of fairly complex queries and MySQL's inability to optimise subqueries, limitations in terms of using multiple indexes, and lack of support for partial indexes were causing major performance problems. It'd be possible to denormalise, of course, but then what's the point of using an SQL database at all?

I don't really see any reason to use MySQL for any new projects these days: if you want an SQL database then Postgres is superior in basically every way (even replication, since 9.0); if you just want "a datastore" then the various NoSQL solutions are generally no less reliable, and often more performant.

Cheers,
Ben