Skip to content

A detailed comparison of serverless cloud SQL database providers, including developer experience, pricing, runtime limits, and community support. Compare options that allow scaling to zero cost when not in use, with comprehensive tables comparing features like SQL dialect support, free tier offerings, and maximum database sizes.

License

Notifications You must be signed in to change notification settings

hbmartin/comparison-serverless-cloud-sql-databases

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Comparing hosts for serverless cloud SQL databases

This document provides a comparison between hosted, serverless (no cost or management to spin down to zero) providers of SQL cloud databases.

  • PlanetScale has been removed due to their ending of free plans.
  • Render has been removed since their free plan is disabled after 30 days.
  • Tembo has been removed since their free plan is disabled after 14 days.
  • Nhost has been removed since they sporadically shut down active projects.

Please join our discussions or fix/update information by editing this doc!

See also the Python FaaS Comparison

See also the Authentication Providers Comparison

DevEx

Dialect Status Cloud Cnxn OSS Examples Docs
Aurora Serverless v2 (AWS)² PostgreSQL / MySQL GA AWS
Azure SQL Serverless GA Azure
CockroachDB Postgres compat. GA AWS / GCP Pool Link 🚀
D1 (Cloudflare) SQLite GA Cloudflare HTTP 🚫 Link 🚀
Gel (fka EdgeDB) PosgreSQL + EdgeQL Early AWS
LiteFS SQLite GA (v0) Fly.io N/A Link 🚀
MotherDuck DuckDB
Neon PostgreSQL GA
Nile PostgreSQL Early Pool Link 👍
Prisma Prisma ¹ GA Vultr Link 🚀
Supabase PostgreSQL Pool / HTTP 🚀
SurrealDB SurrealQL (PSQL-ish) Link 🚀
Turso SQLite GA ? Embed + HTTP Link 🚀
Xata PostgreSQL Early
  1. Prisma uses PostgreSQL but does not expose a database connection. It requires the Prisma client library.
  2. Unlike v1, Aurora Serverless v2 has a minimum and does not scale down to zero. However it is kept here since it is a common point of comparison.

Pricing

Note that the "Free Plan" is intended to represent ongoing free resources i.e. not trials or sign-up credits.

Free Plan Bill Limits First Paid Tier
Aurora Serverless v2 (AWS) None $0.12 / ACU (~1 GB RAM) hour (varies by region) + $0.10 / GB-month storage + $0.20 / 1M reqs (non-optimized tier)
Azure SQL Serverless
CockroachDB 10 GiB + 50M RUs / mo. Yes $0.50 / GiB + $0.20 / 1M RUs (over free)
D1 (Cloudflare) 5M RR / day + 100k RW / day + 5 GB $5 / mo for 25B RR + 50M RW + 5GB, after $0.001 / M RR + $1.00 / M RW + $0.75 / GB-mo
Gel 1/16 vCPU, 1/2 GiB RAM, 1GB storage $20 / mo for 1/8 vCPU, 1 GiB RAM, 10GiB storage, 100GiB transfer
LiteFS (Fly.io) 3 GB storage (including VM) + 160 GB egress (per ?) ? $0.15 per GB / mo + $0.02 per GB egress (over free, min $5 / mo) + optional $0.50/GB / mo for backups
MotherDuck
Neon 500 MB, 190 CPU hours $20 / mo = 10 GB, 300 CPU hours
Nile 1GB storage, 50M query tokens $15 / mo = 5GB storage, 150M query tokens
Prisma 1 GB storage, 100k ops, 5MB response, 10s duration Yes $50/mo = 5 GB storage (+ $1.5 / GB), 100k ops (+ $8 / M), 10 MB response, 20s durtration
Supabase 500 MB, 5GB bw, 50k MAU $25 / mo = 8GB storage, 250 GB bw + $0.125 / GB + $0.09 / GB bw
SurrealDB 1 GB storage Limited compute node size
Turso 500 DBs, 9 GB, 1B row reads 10k DBs, 24 GB
Xata 15 GB storage $20/mo = 15 GB storage + $2 / GB

RUs = CPU + IOPs, mo = month, M = million, k = thousand, RR = rows read, RW = rows written, B = billion, bw = bandwidth

Runtime Limits

DB Size # DBs Duration
Default / Free Max / Paid Default / Free Max / Paid
Aurora Serverless v2 (AWS)
Azure SQL Serverless
CockroachDB
D1 500 MB 2 GB 10 50k 30 s
LiteFS
MotherDuck
Neon
Prisma 10 60 See above
Supabase
Turso 9 GB 24 GB 500 10k
Xata Early

Discussions, Community, and Support

Ours Forum GitHub SO Reddit
Aurora Serverless v2 (AWS)
Azure SQL Serverless
CockroachDB Forum Slack GitHub SO r/CockroachDB
D1 (Cloudflare) Forum Discord Projects SO r/CloudFlare
Gel
LiteFS (Fly.io) Fly.io Forum LiteFS
MotherDuck
Neon
Nhost
Nile
Prisma
Supabase
Turso Discord GitHub SO
Xata

References and Useful Links

About

A detailed comparison of serverless cloud SQL database providers, including developer experience, pricing, runtime limits, and community support. Compare options that allow scaling to zero cost when not in use, with comprehensive tables comparing features like SQL dialect support, free tier offerings, and maximum database sizes.

Topics

Resources

License

Code of conduct

Stars

Watchers

Forks