When Linus designed Git, one of his famous quotes was “branching is not the issue, merging is”. Properly merging and reverting database schema changes still feels like we were in CVS or Subversion times – especially if many teams and tons of data get involved. We will tell how those DB challenges got addressed at GitHub and how the same tooling found its way into PlanetScale’s database branching and merging workflow. We will do a live demo showing how to create free databases on our SaaS platform, branch off from main, connect to the DB feature branch from various frameworks and programming languages and propose MySQL schema changes in the associated deploy requests. We will also demo how to test, approve, merge and revert database branches directly from a GitHub pull request along with the corresponding application code changes.
Finally, you will learn about the Open Source technologies that make all of this possible: Vitess and gh-ost, used in production at places like GitHub, MyFitnessPal and Twitter.