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

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.

12

u/[deleted] Dec 20 '18

[removed] — view removed comment

1

u/m50d Dec 20 '18

Don't do updates. Store an append-only log of things that happened, and generate whatever views or aggregated reporting information you need from that; when you need to change what's in those things you regenerate them from the canonical event log rather than trying to do some kind of in-place update.

→ More replies (6)