Explore containerized database development and testing in this comprehensive conference talk. Learn how to leverage Docker containers for SQL Server on Linux to enhance agility in database development and testing processes. Discover techniques for encapsulating database servers and storage, addressing data persistence concerns, and integrating containerized databases into CI/CD pipelines. Gain insights into unit testing, source code sharing, and working with relational databases in Docker environments. Follow along with practical demonstrations using Visual Studio Code, migrations, and API testing. Understand Docker file structures, image creation, and Docker Compose for managing multi-container applications. Address common challenges such as race conditions and troubleshooting containerized database setups. Explore strategies for tracking and sharing secondary data across different development branches, ultimately improving the overall agility and efficiency of database-driven application development.
Dev and Test Agility for Your Database with Docker
Overview
Syllabus
Introduction
Unit testing
Sharing source code
Persistence
Relational Database
Database in Docker
Sequel Server
Docker Image
Containers and Databases
Docker is already running
Docker is just like pulling packages
Docker pull command
Demo applications
Docker run
Docker entry point
Small solution
Visual Studio Code
Migrations
Test Data
Running the API
Testing the API
Troubleshooting
Moving Parts
Running Again
Race Condition
Docker File Overview
Docker Image Overview
Compose Overview
Connecting to the Database
Connection string
Migration
Start from scratch
DockerCompose
Docker Compose
Docker Compose vs API
Docker Logs
Tracking Secondary Data
Sharing Secondary Data in a Normal World
Changing to a New Branch
Taught by
NDC Conferences
