stackstash

DynamoDB vs SQLite

DynamoDB and SQLite are 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

SQLite logo: A SQL database stored in one file, with no server to run.
SQLite logo: A SQL database stored in one file, with no server to run.

SQLite

Free

A SQL database stored in one file, with no server to run.

Try it

Pros of SQLite

  • Nothing to install beyond the library

  • Easy to copy, back up, or reset in development

  • Drizzle can use it the same way as Postgres

Cons of SQLite

  • One writer at a time is the comfortable limit

  • You outgrow it once you need hosted auth and storage