Database as Code. Not only migrations
summary
Migrations are only the start: a proposed set of four rules requires all database changes scripted and automated, version control as single source, release-on-demand and DBA integrated with devops, and the talk shows how that applies beyond DDL to DML, queries, administration and monitoring. Concrete tools include dbt which materializes SQL files into tables and views and adds testing and templating with ginger, plus a small client called malevich for schema exploration and performance analysis.
AI-written summary · about
related talks
46mDatabase DevOps - It is Possible!
31mDevOps Practices for the Database Team
36mUnlocking the Benefits of Database DevOps and Automation
33mBringing DevOps To The Database
05mMaking Database Changes a Tier one Artifact
45mEnabling Continuous Delivery with Database Practices
50mBringing DevOps to the Database
31mHelp! My Database Is The Bottleneck