3 ms·
To be honest, as a customer, it is hard for me to justify using DynamoDB. Some of this criticism can be out of date: 1. DynamoDB is not as convenient. There ar
by didip 5y ago
To be honest, as a customer, it is hard for me to justify using DynamoDB. Some of this criticism can be out of date:
1. DynamoDB is not as convenient. There are a bit too many dials to turn.
2. DynamoDB does not have a SQL facade on top.
3. DynamoDB is proprietary, I believe there's no OSS API equivalent if you want to migrate out.
4. DynamoDB was kind of expensive. But it has been a while since I last check the pricing page.
It's simply much better to start with PostgreSQL Aurora and move to a more scalable storage based on specific uses-cases later. For example: Cassandra, Elastic, Druid, or CockroachDB.
- nathanfig 5y agoThat’s surprising to me, I consider DynamoDB to be far simpler than any relational DB including the alternatives you list
- deleted 5y ago[deleted]
- arecurrence 5y agoI strongly agree that most early stage businesses should be on Postgres. There's simply too much churn in early stage data models. Also, unforeseen esoteric needs jumping out of the wood work that you can knock out a SQL query for instead of having to build a solution come up constantly. However, this does assume that your development team has a competent understanding of SQL. I've been in a couple startups that went Dynamo first and development velocity was a pale shadow of velocity with Postgres. When one of those startups dumped dynamo for Postgres velocity multiplied immediately. I'd estimate we were moving at around 1000% and the complete transition took less time than even I expected (about a month). Once the business matures, moving tables onto dynamo and wrapping them in a microservice makes a lot of sense. Dynamo does solve a lot of problems that become increasingly material as the business evolves. Eventually, SQL's presence declines and transitions into an analytics system as narrower, but easier for ops, options proliferate.
- Zimnx 5y agoAd 3. Lot of people don't know about it, but there's a open source, free, and DynamoDB compatibile databse called ScyllaDB - API it's called Alternator to be specific.
- didip 5y agoI definitely didn't know about it before. Thanks!
- voxic11 5y ago> 2. DynamoDB does not have a SQL facade on top. I think this is out of date https://aws.amazon.com/about-aws/whats-new/2020/11/you-now-can-use-a-sql-compatible-query-language-to-query-insert-update-and-delete-table-data-in-amazon-dynamodb/ https://aws.amazon.com/about-aws/whats-new/2020/11/you-now-c...