stackstash

DynamoDB vs Postgres

DynamoDB and Postgres are free.

DynamoDB logo: AWS key-value and document database that scales without a server to patch.
DynamoDB logo: AWS key-value and document database that scales without a server to patch.

DynamoDB

Free

AWS key-value and document database that scales without a server to patch.

Try it

Pros of DynamoDB

  • No servers to run

  • Scales with traffic

  • Fits the rest of AWS

Cons of DynamoDB

  • Awkward when you need joins

  • Easy to get the data model wrong

  • Tied to AWS

Postgres logo: Open-source relational database. The usual pick when you want real SQL.
Postgres logo: Open-source relational database. The usual pick when you want real SQL.

Postgres

Free

Open-source relational database. The usual pick when you want real SQL.

Try it

Pros of Postgres

  • Reliable relational database

  • JSON without leaving SQL

  • Free to run yourself

Cons of Postgres

  • You manage backups and upgrades

  • Heavier than SQLite for a tiny app