Pinboard (jm)
https://pinboard.in/u:jm/public/
recent bookmarks from jmTrek10 | From relational DB to single DynamoDB table: a step-by-step exploration2019-01-08T12:33:01+00:00
https://www.trek10.com/blog/dynamodb-single-table-relational-modeling/
jmIs modeling my relational database in a single DynamoDB table really a good idea?
About a year ago, I wrote a fairly popular article called “Why DynamoDB isn’t for everyone”. Many of the technical criticisms of DynamoDB I put forth at that time (lack of operational controls such as backup/restore; a persistent problem with hot keys) have since been partially or fully resolved due to a truly awe-inspiring run of feature releases from the DynamoDB team.
However, the central argument of that article remains valid: DynamoDB is a powerful tool when used properly, but if you don’t know what you’re doing it’s a deceptively user-friendly guide into madness. And the further you stray into esoteric applications like relational modeling, the more sure you’d better be that you know what you’re getting into. Especially with SQL-friendly “serverless” databases like Amazon Aurora hitting their stride, you have a lot of fully-managed options with a smaller learning curve.
]]>dynamodb databases storage nosql sql relational aws relationshttps://pinboard.in/https://pinboard.in/u:jm/b:3cda4573d696/