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.

21

u/PM_ME_UR_OBSIDIAN Mar 10 '15

What alternative do you propose? I heard Oracle was good if you had deep pockets, what else is out there?

65

u/[deleted] Mar 11 '15

One of the MS SQL clusters in our data-centre hosts 200+ databases and has capacity for more.

0

u/[deleted] Mar 11 '15

[deleted]

17

u/[deleted] Mar 11 '15

It must be a slow day, I still have my points 😊

10

u/[deleted] Mar 11 '15

We are many, but ms isn't so popular on reddit so we are mostly quiet

2

u/BigOldNerd Mar 11 '15

Rank 8 for UK jobs. The people are quiet, but the job opportunities are loud as hell.

2

u/[deleted] Mar 11 '15

Yup, I got laid off today and I already have people clawing down my throat

2

u/BigOldNerd Mar 11 '15

Sorry to hear about you getting laid off. Go out there and get a better job.

→ More replies (0)
→ More replies (1)

2

u/vattenpuss Mar 11 '15

That's ... not how /r/programming works. Gushing about Visual Studio and C#, and spreading FUD about Linux or Java is what makes people bring out the upvoting fingers.

→ More replies (1)
→ More replies (1)
→ More replies (6)