Neon
Serverless Postgres with branching, auto-scaling, and generous free tier.
My Experience
Neon is what Postgres looks like in the serverless era. The auto-scaling is seamless — your database spins down when idle and scales up instantly when traffic comes in. For a side project, this means you're not paying for idle database time.
Database branching is the killer feature. You can create a copy of your production database for testing or development, complete with its own connection string. It's like git branches for your data.
The cold start can be a bit annoying — first query after idle takes 1-3 seconds. If you need sub-second responses at all times, enable always-on compute (costs a few dollars/month).
Pros
- +Serverless Postgres — scales to zero when not in use
- +Database branching for development (like git for databases)
- +0.5 GB free storage, always-on compute included
Cons
- −Cold start latency on scale-from-zero
- −Not ideal for high-concurrency write-heavy workloads
- −Fewer extensions available than traditional Postgres
Best For
Developers who want Postgres without managing connections or scaling.