alt Hacker NewsIt's my understanding that Neon had some tech to basically "wake up" the DB when a request came out -- so you could "scale down to zero," if you will. I was hoping to explore this for small personal projects: I by far prefer Postgres and would love an isolated database per project.
Is there an alternative for that? Scale-to-zero postgres, basically?
Replies
ko_pivot • yesterday at 1:09 PM
AWS Aurora Postgres Serverless v2 has that capability, though it takes multiple seconds.
➕ show 3 replies
For small personal projects, coolify (featured recently here on HN) lets you quickly stand up postgres with SSL, etc. and get a connection string in seconds. You can deploy in the same project or expose pg to the world like neon does.
One click turns it off, or you can just leave it on. A $5 VM will run a lot of small postgres.
I use both neon and coolify, and could live with either, though apples and oranges when it comes to the data branching feature. But a quick pg_dump/restore which could even be scripted solves my problem. Disclaimer: I like devops in addition to just dev.