Overall Satisfaction with Amazon DynamoDB
It is a great way to store vast amounts of data for quick retrieval. Along with new features added to it like global secondary indexes, automated backups, and dynamo streams, it becomes a great cheaper alternative to SQL. We use it to hold any data we need stored with high reliability while still being able to access it sub second.
- Fast retrieval
- Auto scaling to control costs
- Query and scanning allow for different use cases
- Can get very expensive very fast
- Sharding and hot spotting are hidden problems that can cause ALOT of head ache
- Not relational or transactional at all
- Better faster coding for data storage and retrieval
- Can get very expensive very fast for some use cases, while really cheap for others
- Hidden errors and short falls leads to very frustrating troubleshooting
Sql is much more feature rich yet costly and harder to maintain. Requires physical servers while dynamo everything is in the cloud across multiple AZs. Redis is actually great to put on top of dynamo to use as a read cache which is much faster and cheaper, but the storage and retrieval options are not as robust and the reliability is decreased