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

1:48 min

Leveraging compute separation for autoscaling and Git-like branching

Oleksandra Bovkun

Oleksandra Bovkun · Europe 2026 Virtual

2:26 min

Implementing continuous integration and isolated developer environments

Matthias Niehoff

Matthias Niehoff · World Congress 2023

5:12 min

Tracking organizational source code modernization with a platform

timtebeek

timtebeek · World Congress 2024

2:11 min

Scaling organizational trust across hybrid multi-repository workflows

Laura Thorson

Laura Thorson · World Congress 2026 Europe

6:36 min

Overcoming scaling bottlenecks caused by commercial database limitations

Werner Vogels

Werner Vogels · World Congress 2025

2:41 min

Architectural overview of automated database deployments

Sebastian Wolff · LIVE

More from WeAreDevelopers LIVE

WeAreDevelopers LIVE - Is CSS Catching Up to Flash? thumbnail

WeAreDevelopers LIVE - Is CSS Catching Up to Flash?

Chris Heilmann, Daniel Cranney, Bramus Van Damme

WeAreDevelopers LIVE - Project Chopin: Make Your Team and Agents Play Along thumbnail

WeAreDevelopers LIVE - Project Chopin: Make Your Team and Agents Play Along

Chris Heilmann, Daniel Cranney, Krzysztof Cieślak

Fake or News - AI Toothbrushes, Carrier Pigeon Tech & Life on Mars - Krzysztof Cieślak thumbnail

Fake or News - AI Toothbrushes, Carrier Pigeon Tech & Life on Mars - Krzysztof Cieślak

Chris Heilmann, Daniel Cranney

WeAreDevelopers LIVE - Open Source Agent Toolkits thumbnail

WeAreDevelopers LIVE - Open Source Agent Toolkits

Chris Heilmann, Daniel Cranney, Eddie Jaoude

Fake or News - AI Music Detectors, Translating Ancient Languages & Tiny Heads in Teslas - Eddie Jaoude thumbnail

Fake or News - AI Music Detectors, Translating Ancient Languages & Tiny Heads in Teslas - Eddie Jaoude

Chris Heilmann, Daniel Cranney

Fake or News: AI Agents Hire Each Other, Spider-Man Ads in Cars & RAM Thieves - Marc Plogas thumbnail

about 1 month ago

Fake or News: AI Agents Hire Each Other, Spider-Man Ads in Cars & RAM Thieves - Marc Plogas

Chris Heilmann, Daniel Cranney, Marc Plogas

Related videos

Scaling Databases thumbnail

World Congress 2024 • about 2 years ago

Scaling Databases

Tobias Petry

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

World Congress 2025 • about 1 year 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

World Congress 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

World Congress 2023 • about 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

World Congress 2024 • about 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

World Congress 2023 • almost 3 years ago

Enjoying SQL data pipelines with dbt

Matthias Niehoff

Related articles

CH

Chris Heilmann

Dev Digest 132 - Binging WADFlix?

Hello there, watch all the talks of the WeAreDeveloper World Congress, learn prompt engineering and how to sensibly add AI to your apps.Phase 2 of the WeAreDevelopers Cinematic UniverseToday we are...

about 2 years ago

Dev Digest 132 - Binging WADFlix?

CH

Chris Heilmann

Dev Digest 121 - AI goes offline

Hello fellow developer, let's take a look at the cost of AI and its efficiency, catch up on security issues and sing the praise of new JavaScript and CSS features.News and ArticlesThe way we use AI...

over 2 years ago

Dev Digest 121 - AI goes offline

CH

Chris Heilmann

Dev Digest 120 - Apple and peers

Hello fellow developer, yes, yes, yes, Apple announced a ton of things last week, so much so that you can't escape the announcements, which is why we won't cover them here. Instead, here are some i...

over 2 years ago

Dev Digest 120 - Apple and peers

CH

Chris Heilmann

WeAreDevelopers Dev Digest Issue 116 - The new search wars…

Welcome to edition 116 of the WeAreDevelopers Dev Digest. This time we talk about how the fight for AI and search dominance heats up with Google releasing a lot at their I/O event and OpenAI doing ...

over 2 years ago

WeAreDevelopers Dev Digest Issue 116 - The new search wars…

From learning to earning

Jobs that call for the skills explored in this talk.

about 1 month ago

Principal Systems Engineer, Database Infrastructure

Expert Remote Ruby MySQL Golang

about 1 month ago

Staff Systems Engineer, Database Infrastructure

Experienced Remote Ruby MySQL Golang

Stackit Database - Go Developer

Grpc MongoDB Databases

Stackit Database - Postgresql - Engineering Manager

Barcelona, Spain

MariaDB Databases Kubernetes

Cloud Engineer (German)

Barcelona, Spain

Staff Software Engineer, Database Infrastructure

Experienced Remote Ruby MySQL Golang