What we set up
Migrations in the repo. Staging and production as separate databases. Backups you can point at. A single source of truth for accounts and orders.
Managed, not heroic
Neon, Supabase, RDS, or Cloud SQL. We do not SSH into a box to vacuum on a Saturday unless you have hired us to run that box.
Questions
NoSQL instead?
If you already have it and it works. We will not start a billed product on a document store because it felt modern in a tutorial.