Database patterns to learn. Engine commands to look up.
Series for database patterns. References for engine commands and errors.
Database development series
- 01
Database Change Automation
Six levels — manual to integrated. Three approaches: ticketing, pipeline, platform.
- 02
Database as Code
Schemas in version control. Migrations as code. CI/CD for every change.
- 03
SQL Review
Three layers — linting, semantic rules, approval workflow. Catch bad SQL before it ships.
- 04
Online Schema Migration
Two layers — engine locks and deployment topology. Postgres, MySQL, gh-ost, blue-green.
- 05
SQL Editor
Two layers — editor and governance. Roundups, comparisons, access control, just-in-time, masking.
- 06
Database Data Protection
Two controls — gate just-in-time, mask at query. Plus engine-native masking and Postgres RLS.
- 07
Database Audit Logging
Two layers — infrastructure and workflow. Engine and compliance spokes.
- 08
Database Governance for AI Agents
Four controls — identity, authorization, audit, masking. Same governance, new principal type.
Database engine references
- 03
MariaDB
- 04
SQL Server
- 05
MongoDB
- 06
ClickHouse
- 07
Spanner
Beyond references