Reading the pitch and this solves all of the problems I don't have (as a developer and operator of services that don't need to scale to millions of users). How often do you need to clone/restore whole databases, really? But I may be misunderstanding the pitch.
(Neon PM) instant branching in a development workflow because it's like git but for your database. You can develop or test against an exact copy of production without the risks of testing on production. Autoscaling is useful if the load on your datbase varies (you can save money, even if your app isn't serving millions of users).
Until you start firing emails and texts to your production customers :-)
That aside, I think Neon is pretty cool. I will wait some time to see how stable a service it is, whether price hikes happen often, or whether VC money destroys it.
I think Autora for me is too pricey, but I settled for self hosting PG on Hetzner. I'm there bc Hetzner has been stable for me for years. What I fear the most is having to migrate a db off of some service bc I stopped being their target audience. I know this sucks for startups trying to make it but a risk is a risk. I'll wait and see.