stackstash

SQLite vs Supabase

SQLite is free. Supabase is Est. $25/mo.

$300/year for Supabase.

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

Supabase logo: Hosted Postgres with auth, file storage, and realtime included.
Supabase logo: Hosted Postgres with auth, file storage, and realtime included.

Supabase

Est. $25/mo

Hosted Postgres with auth, file storage, and realtime included.

Try it

Pros of Supabase

  • A database and login without a separate server

  • The data is still Postgres, so Drizzle can talk to it

  • The free project is enough to prototype

Cons of Supabase

  • Row level security is easy to get wrong

  • You are tied to their dashboard for the managed pieces