“RDS goes down too. And when it does, you’re still the one getting paged, you just have fewer tools to fix the problem.”
https://pierce.dev/notes/go-ahead-self-host-postgres#user-content-fn-4
Not that much to argue with here. Anybody starting something new right now should most likely steer clear of the AWS trap.
