Quick AWS DynamoDB
Posted on October 2, 2021
Tags: aws
1 Dynamo vs Traditional SQL
1.1 Terms
- Row in SQL , Record/item in DynamoDB , Document in MongoDB
1.2 Schema(less)
- Dynanmo has no Schema, meaning you do type validation in application code
1.3 SQL scaling problems
- Traditional SQL problems
- Does not scale
- SQL JOINS are expensive and cannot be used at scale
- Most db operations only operate on a single record meaning typically joins arent even neccessary
- SQL JOINS are expensive and cannot be used at scale
- Consistency is expensive at scale
- only needed for things like banking
- Does not scale
1.4 Stateful vs Stateless connection
- Traditional SQL opens up stateful TCP connections. (limited connections)
- DynamoDB uses stateless HTTP (no-limit)
