Re:SQL vs. NoSQL Is the Wrong Distinction
by bokwoon on Wednesday August 25, 2021 @09:55AM
(#28301705)
I've seen a very good article on this: https://www.trek10.com/blog/dynamodb-single-table-relational.... It's an insightful dive into how KV stores can model relational data. However I also feel that these 'NoSQL can do relational modelling!' proponents are kind of hijacking the term: a relational model is understood to be based on relational algebra, and DynamoDB's Everything is One Big Table design ain't it.
NoSQL can model relational data, but it is not a relational model (as understood by E.F. Codd).
Also, NoSQL data access patterns are pretty much set in stone, which is kind of what the relational model explicitly avoids.
Re:SQL vs. NoSQL Is the Wrong Distinction
by greymalik on Wednesday August 25, 2021 @08:49AM
(#28300960)
Book link for the lazy: https://www.dynamodbbook.com/
Data is usually relational, there's no getting away from that just because of the database you use. NoSQL can manage all kinds of relations, just with an extremely different approach.
If you're interested in learning how this works instead of repeating the tired meme of "mongodb lol" checkout Alex Debrie's book on DynamoDB and Rick Houlihans YouTube content.
I also wrote a brief thread about this on Twitter: https://twitter.com/thdxr/status/1394903426023272452?s=19