A Database
DevOps Pipeline
by Rob Richardson
About Me
Rob Richardson is a software craftsman building web properties in ASP.NET and Node, React and Vue. He's a frequent speaker at conferences, user groups, and community events, and a diligent teacher and student of high quality software development. You can find this and other talks on https://robrich.org/presentations and follow him on twitter at @rob_rich.
A DevOps Pipeline
Goals of DevOps
Because computers are cheaper than people
DevOps Pipeline for Apps
 |
suggestion |
task tracking |
code |
build |
test |
deploy |
qa |
prod |
feedback |
 |
||||||||
 |
 |
Icons: Icons8 and Font Awesome
DevOps Pipeline for Apps
|
suggestion |
task tracking |
|
code |
build |
test |
|
deploy |
qa |
prod |
feedback |
|
||||||
|
|
|
Icons: Icons8 and Font Awesome
A DevOps Pipeline
for Databases
How're we doing?
The Problem:
Typical database processes are manual.
Database pipelines can't destroy and rebuild.
Database DevOps Pipeline
Database Migration Scripts
Creation Scripts
Migration Scripts
Creation Scripts
Migration Scripts
Hybrid Approach
Database Migration Tools
See also: Jason Hoffman's list of OpenSource Database Migration Tools
Demo
Database DevOps Pipeline
- With containers
- GitHub Actions
Database DevOps
Just do it.