WeAreDevelopers Logo WeAreDevelopers
Sign in
For You LIVE
WeAreDevelopers LIVE • Feb 1, 2022

Branch your database like your code: How schema changes and pull requests go hand in hand

Johannes Nicolai , Lilli Seyther-Besecke

Production databases shouldn't bottleneck your Git workflow. Stop fearing schema changes. Learn how to bind isolated database branches to your pull requests for zero-downtime deployments.

Pause
Mute Enter Fullscreen
#1 about 3 min

Scaling MySQL databases for massive user growth

How horizontal scaling challenges and hardware limitations drove the invention of the Vitess framework.

#2 about 3 min

Exploring the architecture of the Vitess database framework

A dedicated query routing layer transparently manages sharded data queries across multiple backend storage nodes.

#3 about 3 min

Standardizing code collaboration with the pull request workflow

Isolated feature branches and pull requests eliminate the anxiety of testing and merging complex software.

#4 about 5 min

Understanding the complexities of database schema changes

Applying imperative delta-based transformations to live data introduces conflict risks that dictate specialized review processes.

#5 about 2 min

Achieving non-blocking schema updates with shadow tables

Asynchronous shadow tables simulate application behavior before completing an atomic cutover without blocking database operations.

#6 about 4 min

Implementing branching and deploy requests for database schemas

Cloning the production schema into isolated testing environments allows developers to safely review structural updates.

#7 about 3 min

Automating database operations leveraging GitHub Actions workflow integrations

Command line tooling and workflow configurations enable teams to govern database environments programmatically via repositories.

#8 about 3 min

Provisioning a continuous integration database using automated workflows

Executing repository actions provisions a full cluster configuration to support distinct code testing requirements.

#9 about 4 min

Aligning local code development with backend database modifications

Synchronizing a pull request with backend parameters highlights how modern updates span multiple infrastructure layers.

#10 about 5 min

Provisioning isolated database testing environments via issue comments

Issuing a repository bot command provisions a temporary testing database initialized with current schema states.

#11 about 7 min

Approving and merging database deploy requests seamlessly

Integrating manual approval commands directly within pull request discussions finalizes atomic schema migrations to production.

#12 about 8 min

Managing hosting regions, enterprise deployments, and complex subqueries

Technical capabilities like geographic node placement, enterprise cloud orchestration, and query routing depend on configurations.

Matching moments

2:26 min

Implementing continuous integration and isolated developer environments

Matthias Niehoff Matthias Niehoff · WWC 2023

5:12 min

Tracking organizational source code modernization with a platform

timtebeek timtebeek · WWC 2024

2:11 min

Scaling organizational trust across hybrid multi-repository workflows

Laura Thorson Laura Thorson · WWC Europe 2026

6:36 min

Overcoming scaling bottlenecks caused by commercial database limitations

Werner Vogels Werner Vogels · WWC 2025

2:41 min

Architectural overview of automated database deployments

Sebastian Wolff · LIVE

1:11 min

Streamlining developer pipelines with integrated infrastructure

Matt Butcher · WWC 2023

More from WeAreDevelopers LIVE

Aliens in Quarantine, Python Deprecates Loops, and AI Buys Old Books - Zbyszek Tenerowicz thumbnail
5:43
5 days ago

Aliens in Quarantine, Python Deprecates Loops, and AI Buys Old Books - Zbyszek Tenerowicz

Chris Heilmann, Daniel Cranney

WeAreDevelopers LIVE - Node and Package Security thumbnail
1:08:30
5 days ago

WeAreDevelopers LIVE - Node and Package Security

Chris Heilmann, Daniel Cranney, Zbyszek Tenerowicz

WeAreDevelopers LIVE - Streaming HTML thumbnail
1:10:26
12 days ago

WeAreDevelopers LIVE - Streaming HTML

Chris Heilmann, Daniel Cranney, Jad Joubran

WeAreDevelopers LIVE - CODE100 at WeAreDevelopers Europe thumbnail
1:02:34
19 days ago

WeAreDevelopers LIVE - CODE100 at WeAreDevelopers Europe

Chris Heilmann, Daniel Cranney, Justin Halsall, Werner Jeschko, Nicole Jeschko, Mirco Tomić

WeAreDevelopers LIVE - Web Performance in an AI World thumbnail
1:07:59
26 days ago

WeAreDevelopers LIVE - Web Performance in an AI World

Chris Heilmann, Daniel Cranney

FIFA Hack, Midjourney Does Ultrasounds, and Trampoline Traffic Lights - Nicole Jeschko and Werner Jeschko thumbnail
5:55
about 2 months ago

FIFA Hack, Midjourney Does Ultrasounds, and Trampoline Traffic Lights - Nicole Jeschko and Werner Jeschko

Chris Heilmann, Daniel Cranney

Upcoming sessions on this topic

Open session

World Congress 2026 North America

Merging at Scale: From Broken Builds to Green Mainline

Manjari Akella, Preetam Dwivedi

Manjari Akella
Preetam Dwivedi
Open session

World Congress 2026 North America

Beyond Vibe Coding: Using CLI Tools as Your AI Counterpart in Pair Programming

Ron Veen

Java enthusiast and Special agent for Team Rockstars IT

Ron Veen
Open session

World Congress 2026 North America

Testing React Backends Like a Pro: Mocking Databases with SQLite

David Morris

Solution Architect

David Morris
Open session

World Congress 2026 North America

Beyond SQL Generation: How to Teach Agents What Your Database Actually Means

Kris Jenkins

Lead Developer Advocate at Snowflake

Kris Jenkins
Open session

World Congress 2026 North America

Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases

Wei Hu

Senior Vice President of Research and Development

Wei Hu
Open session

World Congress 2026 North America

Culture Doesn't Scale Itself: Leading Engineering Teams Through Hypergrowth and the AI Transition

Thanos Baskous

VP of Engineering and Co-founder of Cogent Security

Thanos Baskous

Related videos

Scaling Databases thumbnail
21:09
WWC 2024 • almost 2 years ago

Scaling Databases

Tobias Petry

Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases thumbnail
28:41
WWC 2025 • 12 months ago

Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases

Wei Hu

Build and Deploy a Fullstack App with Open Source Tooling thumbnail
25:53
WWC 2023 • almost 3 years ago

Build and Deploy a Fullstack App with Open Source Tooling

Noam Honig

Navigating the Corporate Jungle: Life as a Developer in a large Company thumbnail
28:16
WWC 2023 • almost 3 years ago

Navigating the Corporate Jungle: Life as a Developer in a large Company

Alexandra Petri

Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases thumbnail
32:46
WWC 2024 • almost 2 years ago

Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases

Wei Hu

Enjoying SQL data pipelines with dbt thumbnail
26:53
WWC 2023 • over 2 years ago

Enjoying SQL data pipelines with dbt

Matthias Niehoff

Related articles

From learning to earning

Jobs that call for the skills explored in this talk.