News for hackers. Stuff that matters.
Re:The DynamoDB Paper by deepGem on Thursday July 14, 2022 @10:43AM (#32096677)
True. Spanner and the likes of Spanner, CockroachDB, YugaByte all are strongly consistent and scalable dbs. The greatest advantage IMO is the ability to just use SQL without having to worry about carefully designing a data model. What bothers me however is that these data stores are not truly relational data stores. They spin a relational layer on top of a scalable key-value data store.

Is it necessary to use a strongly consistent transactional data store if your needs don't demand transactions, by transactions I mean 2PC. IMO you are still better off with DynamoDB/Cosmos/MongoDB for eventual consistency use cases. The reason being, you have to resort to a data model if you don't need the relational layer in YugaByte at least, not sure about Spanner. So why bother with Yugabyte if am resorting to a data model. Might as well stick with DynamoDB.

Re:The DynamoDB Paper by manigandham on Thursday July 14, 2022 @01:08PM (#32098742)
What part of SQL requires not having to design a data model? What exactly do you mean by that?

And technically all relational databases are relational layers on top of a key/value subsystem. Splitting that apart and scaling the storage is how most of the NewSQL databases scale , from CRDB to Yugabyte to Neon.

Re:The DynamoDB Paper by deepGem on Friday July 15, 2022 @06:46AM (#32106781)
What I mean is that the data model in the NoSQL world is tightly coupled with the query pattern. So you define the query pattern and then tailor the data model to that query pattern. In the relational world, you typically choose the index based on your query pattern. Not tailor the data model to your query pattern. You follow normalization principles.

Of course, every data store needs a data model. No debate there :).

Not sure what you mean by relational databases are relational layers on top of key-value stores. InnoDB has a 16KB page data as it's fundamental data structure.

https://dev.mysql.com/doc/internals/en/innodb-page-structure...

Re:The DynamoDB Paper by arminiusreturns on Thursday July 14, 2022 @10:49AM (#32096759)
I think VoltDb (and SciDB) are worth checking out also. I'm seeing some very impressive ACID compliant TPS with elixir connected to voltdb. I don't like having to pay to get distributed features however (open source community edition is feature gimped compared to payed.)
Re:The DynamoDB Paper by jd_mongodb on Thursday July 14, 2022 @01:45PM (#32099225)
You seem to think MongoDB is eventually consistent. MongoDB is designed as strongly consistent database. You can choose to query a secondary and that will be eventually consistent but that is not the default behaviour.
Re:The DynamoDB Paper by deepGem on Friday July 15, 2022 @06:48AM (#32106792)
I must have clarified, what I mean by strong consistency is that you have transactional support (2 phase commit). MongoDb is atomic, meaning every single document is strongly consistent. However, I stand corrected. They have introduced transactions as of 4.2.
Re:The DynamoDB Paper by _benedict on Friday July 15, 2022 @10:27AM (#32108528)
I believe multi document transactions offer only causal consistency?
Re:The DynamoDB Paper by dboreham on Thursday July 14, 2022 @01:47PM (#32099257)
> What bothers me however is that these data stores are not truly relational data stores

Suggests there may be an impossibility theory lurking somewhere.