So at work, we’re looking at using Laravel, automating with Docker and using Swarm, having a development environment local to the developer’s machine.
Given those things, Laravel uses php artisan to change the database. The database will just be a copy of the latest backup of production.
Laravel has features like adding timestamps, and soft-deletion columns to tables, as well as managing relations between multiple tables (i.e. many-to-many relationships).
How would you automate syncing those schema changes to production safely?