Neon: Serverless Postgres with Branching, Autoscaling, and Bottomless Storage

Intro

Postgres has been the go-to relational database for years, but managing it in production still involves a lot of manual work: scaling storage, handling connection limits, and dealing with slow backup restore times. Neon aims to fix that by rethinking how Postgres is deployed and operated.

What makes it interesting is that it's not a fork or a wrapper. It's still Postgres under the hood, but with a serverless architecture that adds branching (like Git for your database), autoscaling compute, and truly unlimited storage. If you've ever wished your Postgres database behaved more like a cloud storage bucket with SQL on top, this is worth a look.

What It Does

Neon is a fully managed serverless Postgres database. You get a regular Postgres endpoint you can connect to from any Postgres-compatible client or ORM. But behind the scenes, it separates storage from compute. Compute instances are stateless and spin up/down on demand. Storage is handled by a separate layer that scales to petabytes, backed by object storage (like S3).

Key highlights from their GitHub repo:

• Branching – Create instant read/write branches of your database, even for large datasets. Useful for testing migrations, preview environments, or isolating CI runs.
• Autoscaling – Compute resources scale automatically based on load. If your app goes quiet, compute scales to zero. When traffic spikes, it spins up within seconds.
• Bottomless storage – You pay for what you store, but there's no hard limit. Storage is backed by cheap object storage, with a local disk cache for hot data.

Why It’s Cool

1. Branching Like Git

This is the standout feature for developers. You can branch your entire database in seconds, regardless of size. Want to test a schema migration? Branch the production database, run migrations, verify everything works, then delete the branch. No more restoring from a dump or keeping a second full copy around. It's cheap, fast, and changes are isolated.

2. Autoscaling Compute

Most "serverless" databases handle storage scaling but leave compute as a fixed resource. Neon's compute layer can scale down to zero when not in use (saving money) and scale back up quickly under load. For apps with variable traffic patterns (think staging environments, personal projects, or APIs with bursty usage), this can significantly reduce costs.

3. Bottomless Storage

Because storage is separate and backed by object storage, you never need to manually increase disk size or worry about running out of space. The local disk acts as a cache, while the bulk of cold data lives in S3. This is similar to how Aurora or some data warehouses work, but applied to standard Postgres.

4. It's Still Postgres

Everything