Database Guardrails - new age for developers and databases
summary
Shows concrete failures and fixes: a single aggregate query extracts ~300,000 rows and runs ~25 seconds until rewritten as several small queries; a CTE rewrite doubles latency (13s vs 8s). Identifies silent harms — long migrations (minutes to hours, sometimes months), runaway n+1 queries, too many or missing indexes — and ties runtime behavior to planner choices via execution plan and OpenTelemetry traces. Matis integrates into CI/CD and local dev with one JS dependency to catch these issues before production.
AI-written summary · about
chapters (36)
- 0:00intro
- 0:22preamble
- 1:03where we used to be...
- 2:41where we are now
- 5:00everything is complex
- 5:28monitoring doesn't make it simpler
- 6:35what breaks in the current world?
- 8:00problems with databases
- 10:12slow queries
- 16:04incompatible changes in schema
- 19:46missing indexes
- 21:01too many indexes
- 22:00bugs
- 24:18n+1 selects
- 26:37joins
- 27:04polymorphism
- 28:20data types
- 30:06lack of visibility
- 30:42migrations
- 31:21reviews
- 31:57tests - do they work?
- 33:02load testing?
- 35:01solution - database guardrails
- 35:31know the context to find the root cause
- 40:07monitoring and observability
- 40:42opentelemetry (otel)
- 41:20traces and spans in otel and jaeger
- 42:39what to observe?
- 42:51executing the query: parser, rewriter, planner, executor
- 43:20anatomy of an sql query
- 45:17database guardrails
- 48:10be proactive and push to the left!
- 48:22demo
- 52:37source code integration
- 53:00summary
- 53:55thank you
related talks
22mDatabase Guardrails - New Age for Developers and Databases
48mMissing chapter in your CI playbook: database guardrails
37mPlatform Engineers Must Change Developers and Databases - And Here Is How
50mAdam Furmanek: You Must Test Your Databases And Here Is How
14mDatabase Performance at Scale for RoR Applications
41mUsing Databases to Pull Your Application Weight
25mPowerful Data: Making Rails Apps Faster with Aggregation
40mrails db:migrate:safely