Can someone explain the difference between database hosting services?
I work for a small startup and our application is using postgres. I want some sort of solution which is easy to deploy but also handles scalability.
I first looked at Railway and it looked like they spin up a single machine for you? If that's the case seems okay for small projects, but won't help with scale.
I also looked into Heroku Postgres, which seems like they spin up additional servers if needed?
There's also AWS, but that seems like a complicated option and the idea that you could get charged a ton if a mistake is made seems scary.
Lastly, I noticed both T3 docs and Vercel mention PlanetScale, but they use MySQL not postgres, would this cause an issue?
I first looked at Railway and it looked like they spin up a single machine for you? If that's the case seems okay for small projects, but won't help with scale.
I also looked into Heroku Postgres, which seems like they spin up additional servers if needed?
There's also AWS, but that seems like a complicated option and the idea that you could get charged a ton if a mistake is made seems scary.
Lastly, I noticed both T3 docs and Vercel mention PlanetScale, but they use MySQL not postgres, would this cause an issue?
