News for hackers. Stuff that matters.
Re:The Rise of SQL-Based Data Modeling by pdexter on Thursday January 30, 2020 @10:49AM (#22192188)
What's the connection between NoSQL vs SQL and eventual consistency?
Re:The Rise of SQL-Based Data Modeling by dragonwriter on Thursday January 30, 2020 @11:13AM (#22192459)
NoSQL is a bad name that really doesn't have anything to do with SQL per se, but is a shorthand for non-relational datastores (no one calls non-SQL relational systems “NoSQL”), which, while they depart from the relational model in a number of different ways, typically include eventual rather than strong consistency to support liveness in a distributed context.
Re:The Rise of SQL-Based Data Modeling by cle on Thursday January 30, 2020 @11:07AM (#22192389)
NoSQL in some cases trades off consistency for scalability (generally by sharding data, so propagating data across shards introduces eventual consistency).

As you can imagine, data that reside in a single shard don’t need to be propagated, so you can get strong consistency easily (e.g. fetching a single document). It’s when you start doing queries, joins, aggregations, etc. that you start encountering eventual consistency.

Re:The Rise of SQL-Based Data Modeling by jsight on Thursday January 30, 2020 @11:49AM (#22192821)
Mainly that most people who ask that question are using it as a lead-in to promoting a NoSQL product.