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 Β· World Congress 2022

4:59 min

Bringing DevOps practices to data transformation with DBT

Matthias Niehoff Matthias Niehoff Β· World Congress 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 Β· World Congress 2021

2:59 min

Eliminating operational errors with containerized application deployments

Aarno Aukia Β· LIVE

More from WeAreDevelopers LIVE

WeAreDevelopers LIVE - Is CSS Catching Up to Flash? thumbnail
1:03:33
10 days ago

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
1:21:17
17 days ago

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 Cieślak thumbnail
4:23
18 days ago

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

Chris Heilmann, Daniel Cranney

WeAreDevelopers LIVE - Open Source Agent Toolkits thumbnail
1:00:38
24 days ago

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
6:16
25 days ago

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
5:46
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

Integrating backups into your GitOps Pipeline thumbnail
25:24
World Congress 2023 β€’ almost 3 years ago

Integrating backups into your GitOps Pipeline

Florian Trieloff

Databases on Kubernetes: Why you should care thumbnail
45:49
LIVE β€’ almost 6 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
World Congress 2023 β€’ about 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.