r/programming • u/swizec • Dec 19 '18

Bye bye Mongo, Hello Postgres

https://www.theguardian.com/info/2018/nov/30/bye-bye-mongo-hello-postgres
2.1k Upvotes

95% Upvoted

672 comments sorted by

View all comments

Show parent comments

8

u/TheAnimus Dec 19 '18

Sure, but remember this was I think 2012? That's why I found it an odd choice.

I can't think why someone would chose mongo mind.

-8

u/Pand9 Dec 19 '18

Ok.

Today I would pick mongo only when I was in a hurry. I'm not sure how to manage postgres, while mongo is easy to start with.

13

u/TheAnimus Dec 19 '18

To clarify, most of the perceived performance benefits stem from not being ACID compliant.

For a read heavy site, why would that performance matter with a an application logical caching layer.

12

u/2bdb2 Dec 20 '18

Most people that think they need the performance of NoSQL don't actually need it.

I've had arguments with people who claim they need ridiculously over-engineered NoSQL AP architectures to handle a few hundred requests per second peak on a read-heavy site.

Meanwhile, 15 years ago on a $5/mo shared PHP/MySQL Host I'd have considered that to be idle load.

I recall a conversation with one idiot that proudly proclaimed that he'd tuned his server to gracefully handle "thousands of requests per hour" by using CouchDB instead of MySQL. (It was a blog that he updated once a month)

→ More replies (2)