3 ms·
Thanks for doing this work! Postgres is amazing and this area is the one place where eg. MySQL has a clear lead. > Postgres is an open source project. It's use
by Diggsey 6y ago
Thanks for doing this work! Postgres is amazing and this area is the one place where eg. MySQL has a clear lead.
> Postgres is an open source project. It's useful in a lot of cases. It's not in some others - partially due to non-fundamental limitations.
For me at least, postgres has the problem that it's too useful. It has so many clear advantages over the alternatives that it often makes sense to choose postgres over more specialized tools.
For example, even if I was primarily storing JSON data, postgres is still a good choice, because it offers better consistency guarantees than most document databases, and has a more powerful query model.
The end result is that the few limitations remaining (eg. the connection model) are felt all the more strongly: I cannot simply say "ah I need lots of connections, I'll use MySQL here" without also giving up on all sorts of other features that I would normally use. (Although MySQL is still improving)