WeAreDevelopers Logo WeAreDevelopers
Sign in
For You LIVE
WeAreDevelopers LIVE • May 12, 2021

Database DevOps with Containers

Rob Richardson

Stop treating your database like application code. Discover how to use Docker containers to securely distribute sanitized, production-like data into dev environments for risk-free daily deployments.

Pause
Mute Enter Fullscreen
#1 about 2 min

Defining the goals of database DevOps

Automating processes ensures consistency, reduces operational costs, and minimizes the risk of human error during deployments.

#2 about 3 min

Building an application DevOps pipeline with user feedback

Starting from user suggestions and ending with user feedback creates a continuous loop where source control serves as the ultimate system of record.

#3 about 3 min

Treating production data as the master database copy

Unlike application code where source control is authoritative, production data is the true source of truth for safe database architectures.

#4 about 6 min

Adapting production databases for safe non-production use

Anonymizing sensitive user details, removing production secrets, and safely shrinking data bulk protects privacy while maintaining realistic testing scenarios.

#5 about 6 min

Automating database pipelines using container virtualization

Leveraging containers rather than full virtual machines provides a lightweight, automated method to manage environment dependencies by virtualizing the operating system kernel.

#6 about 4 min

Defining infrastructure consistently using Docker configuration files

Transforming simple configuration text files into portable image binaries allows teams to spin up complete application environments uniformly.

#7 about 4 min

Managing ephemeral system layers in Docker containers

Docker constructs executable images using stacked read-only layers and provisions an ephemeral read-write layer during execution to cleanly isolate runtime modifications.

#8 about 4 min

Provisioning ephemeral SQL Server environments using Docker

Containerized databases provide a fast and disposable mechanism for teams to execute workloads without the overhead of manual server installations.

#9 about 6 min

Building sanitized multi-stage Docker database images

Automating the restore, sanitization, and packaging process via multi-stage builds prevents intermediate production secrets from leaking into the final developer image.

#10 about 5 min

Validating sanitized container databases in local development

Connecting locally to a freshly built database container empowers engineers to safely query realistic data and instantly reset their environment.

Matching moments

5:18 min

Shifting mindsets on running databases in containers

Denis Wilson Souza Rosa +1 · LIVE

2:49 min

Deploying mission-critical databases within container infrastructures

Wei Hu Wei Hu · WWC 2022

4:59 min

Bringing DevOps practices to data transformation with DBT

Matthias Niehoff Matthias Niehoff · WWC 2024

1:58 min

Modern improvements driving database adoption in Kubernetes

Denis Souza Rosa · LIVE

5:06 min

Running isolated database integration tests using containers

Christian Kühn · WWC 2021

2:59 min

Eliminating operational errors with containerized application deployments

Aarno Aukia · LIVE

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

Stop Running Mystery Meat in Production

Jeroen van Erp

Technical Advocate @ SUSE

Jeroen van Erp
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

rm -rf: Horror Stories From Unsandboxed AI Agents (and How Docker Fixes This)

Rishab Kumar

Staff Developer Evangelist @ Twilio

Rishab Kumar
Open session

World Congress 2026 North America

Databases in the Agent Era

Monica Sarbu

Founder and CEO of xata.io

Monica Sarbu
Open session

World Congress 2026 North America

Testing AI Workflows Locally with Testcontainers

Anna Chernyshova

Sr Solutions Engineer @ Docker

Anna Chernyshova
Open session

World Congress 2026 North America

Boring Failover: Predictable Region Recovery Across 5,000 Microservices

Garvit Kataria, Sahil Sabharwal

Garvit Kataria
Sahil Sabharwal

Related videos

Integrating backups into your GitOps Pipeline thumbnail
25:24
WWC 2023 • almost 3 years ago

Integrating backups into your GitOps Pipeline

Florian Trieloff

Databases on Kubernetes: Why you should care thumbnail
45:49
LIVE • over 5 years ago

Databases on Kubernetes: Why you should care

Denis Wilson Souza Rosa, Steffen Schneider

DevSecOps: Security in DevOps thumbnail
33:20
LIVE • almost 6 years ago

DevSecOps: Security in DevOps

Aarno Aukia

Automated MS SQL Server database deployments with dacpacs and Azure DevOps thumbnail
39:35
LIVE • almost 5 years ago

Automated MS SQL Server database deployments with dacpacs and Azure DevOps

Sebastian Wolff

All things Docker Compose! thumbnail
28:30
WWC 2023 • almost 3 years ago

All things Docker Compose!

Michael Irwin

Reusing apps between teams and environments through Containers thumbnail
43:39
LIVE • over 5 years ago

Reusing apps between teams and environments through Containers

Adrian Kosmaczewski

Related articles

From learning to earning

Jobs that call for the skills explored in this talk.