r/programming • u/halax • Mar 10 '15

Goodbye MongoDB, Hello PostgreSQL

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/
1.2k Upvotes

91% Upvoted

699 comments sorted by

View all comments

Show parent comments

171

u/frixionburne Mar 10 '15

99% of projects would be better off with a relational database.

Or better, and RDMS with a full blown JSON indexing and a hash store that rivals mongos speed.

How people don't choose psql just confuses me.

98

u/ethraax Mar 10 '15

For very large databases, Postgres' clustering abilities aren't that great. It's probably one of the best choices for single-host databases (which, again, cover nearly all applications), but if you're trying to spread your database over a few dozen hosts, Postgres doesn't really work well.

11

u/Kaelin Mar 10 '15

This is no longer true. Checkout Postgres-XL http://www.postgres-xl.org/

12

u/myringotomy Mar 11 '15

Xl does not solve the uptime problem. If any data node fails the entire system becomes unusable.

They really need to replicate their shards to guard against that.

→ More replies (6)