We don't need DynamoDB when we have Aurora Postgres

Aurora Postgres has many cool features. Let's compare them to DynamoDB and review them. While I'm writing this article, the latest version of Postgres - v17.4 Key-value and document data models - We don't need to talk about key-value. It is more interested in "how to store document data?". Postregs has a special type to sore JOSN data - JSONB. It was introduced in version 9.4 more than 10 years ago. Using EF Core 8 we don't even need to think of serialization/deserialization - just use it. Serverless that scales to zero - AWS introduced scaling to 0 capacity with Amazon Aurora Serverless v2. It is an infrastructure-level configuration, but keep in mind a cold start during resuming. ACID transactions - nice joke

Mar 14, 2025 - 11:14
 0
We don't need DynamoDB when we have Aurora Postgres

Aurora Postgres has many cool features. Let's compare them to DynamoDB and review them. While I'm writing this article, the latest version of Postgres - v17.4

  1. Key-value and document data models - We don't need to talk about key-value. It is more interested in "how to store document data?". Postregs has a special type to sore JOSN data - JSONB. It was introduced in version 9.4 more than 10 years ago. Using EF Core 8 we don't even need to think of serialization/deserialization - just use it.

  2. Serverless that scales to zero - AWS introduced scaling to 0 capacity with Amazon Aurora Serverless v2. It is an infrastructure-level configuration, but keep in mind a cold start during resuming.

  3. ACID transactions - nice joke