DynamoDB is a completely different beast and would use no other data store unless I had to. It can pretty much handle any transactional workload I need.
It's cheap, its fast and it scales super high. Don't need much more
DynamoDB is consistent and scalable, not fast and cheap.
DDB is great for storing data that is required to be scalable and never needs to be joined. Add in DAX, developer time necessary to orchestrate transactions, calculate the scaling costs and...that's how AWS gets you.
Plus, local development requires half-complete emulators or a hosted database you're charged for.
No, maybe people should think twice about DynanoDB.
This came up in a thread a few days back, but people considering it should note that Dynamo’s transactions are limited to 25 rows. That may be enough for most operations, but I definitely wouldn’t say it can handle “any transactional workload”. I ran into this limit pretty quickly when trying it out.
It's cheap, its fast and it scales super high. Don't need much more