Scale to zero, pay per request
Costing nothing for compute while idle and growing with traffic on its own, for side projects, preview environments, per-tenant databases and spiky apps.
What it asks of a system
A database that scales to zero stops charging for compute when nobody uses it, and comes back when the next query arrives. There are two shapes. Request-priced services, such as DynamoDB on-demand, bill each read and write and never have a server to pause, so an idle table costs only its storage. Serverless versions of server databases, such as Neon or Aurora Serverless v2 with a minimum of 0 capacity units, suspend the compute after a quiet period (five minutes by default on Neon, configurable on Aurora) and start it again on the next connection.
The cost of this is the first request after a pause and the limits on growth. Neon resumes in a few hundred milliseconds, while Aurora’s resume can take up to 15 seconds, so clients need generous connect timeouts and retries. Open connections, replication or a connection proxy can keep the database from pausing at all. Request-priced services also cap how fast traffic can grow: DynamoDB on-demand absorbs up to double a table’s previous peak at once. When you compare, check the minimum bill, what counts as activity, the resume time, how storage is priced, and the point at which provisioned capacity becomes cheaper.
Good at it · 14
Compare side by sideRelational databases
Key-value stores
Amazon DynamoDBAWSOn-demand tables bill per read and write, so a table with no traffic pays only for storage.AWS’s serverless key-value and document database, with single-digit-millisecond reads at any size.Wide-column stores
Query engines
Amazon AthenaAWSNo cluster to keep running: on-demand queries are billed per TB scanned, so an idle account pays nothing for compute.AWS’s serverless SQL engine for data in S3: no cluster to run, and on-demand queries cost $5 per TB scanned.Data warehouses
DatabendOpen sourceQuery nodes hold no data, and Databend Cloud suspends idle warehouses after five minutes and bills running ones per second.A cloud data warehouse written in Rust that keeps every table as Parquet blocks and Git-like snapshots in object storage, so stateless compute clusters can start, scale and stop without moving data. Open core: Apache 2.0, with paid features under the Elastic License 2.0.
MotherDuckCommercialSmall Ducklings start in about 100 ms and stop when idle, and the smallest size is metered per query rather than per hour.A serverless cloud data warehouse built on DuckDB, where one query can run partly on your laptop and partly in the cloud.Sources
- Neon docs: Scale to zero
- AWS Database Blog: Introducing scaling to 0 capacity with Amazon Aurora Serverless v2
- Amazon DynamoDB docs: On-demand capacity mode
Why each technology is listed comes from the sources on its own page.