Some blatantly obvious thing that I was oblivious to before dipping my toes into databases:
How Changes are Committed into DB
It’s the same way as git commit:
- Make changes all you want
- Commit said changes into database (as a transaction)
How Databases are Deployed
- Local: initialize the database
- Local: create a migration describing the initial table setup
- Local: commit the migration files into version control
- Server: pull the migration file changes from version control
- Server: initialize the database
- Server: run an upgrade, to replay the migrations