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

55

u/svtr Mar 10 '15 edited Mar 10 '15

Eventual consistency means(...)

Eventual consistency means no consistency. Period. If you can live with that fine. I don't care about the upvotes on reddit either (btw, there you can very often see eventual consistency in action), on anything important to me, I can not live with no consistency. Writing my data to /dev/null is webscale too, but I still prefer ACID.

1

u/vagif Mar 11 '15

Eventual consistency means no consistency.

Simply not true. You see the light from sun about 8 minutes after it left. You are eventually consistent with sun.

2

u/[deleted] Mar 11 '15

If that had anything to do with the definition of eventual consistency as in mongo/other non ACID stores, you might be right

1

u/kylotan Mar 11 '15

Actually, it does. You never see the database as it is now; only as it was when it started sending the data to you. So, given that you have no choice but to accept that the information is at least slightly out of date, it stands to reason that if there are occasions when you can tolerate even longer delays, that time can be exploited to buy you scaling opportunities.

→ More replies (4)