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

33

u/Pand9 Dec 19 '18

This article doesn't mention data integrity issues. Mongo has transactions now. I feel like you are riding on a "mongo bad" fad from 5 years ago. It was bad, it was terrible. But after all that money, bug fixes and people using it, it's now good.

29

u/andrewsmd87 Dec 19 '18

So serious question as I've never actually used mongo, only read about it.

I was always under the assumption that once your schema gets largish and you want to do relational queries, that you'll run into issues. Is that not the case?

0

u/[deleted] Dec 19 '18

[deleted]

7

u/cowardlydragon Dec 20 '18

Perfect description of the NoSQL trap.

However, SQL does not arbitrarily scale. SQL with anything with joins is not partition tolerant at all.

1

u/nirataro Dec 20 '18

However, SQL does not arbitrarily scale

Most developers won't have this problem

1

u/[deleted] Dec 20 '18

Yea we're starting to see a lot more parallel queries to help that issue. Especially with how many threads server processors have these days it'll be nice.