Discover essential strategies for implementing database guardrails in your continuous integration pipeline in this 48-minute conference talk from Conf42 Observability 2023. Explore proactive approaches to push testing left, understand the importance of context in root cause analysis, and learn about common database-related issues that can arise in production. Delve into topics such as slow queries, schema changes, indexing challenges, and ORM pitfalls. Gain insights into query execution, SQL anatomy, and the role of observability in database management. Examine the benefits of OpenTelemetry (OTel) and learn how to leverage traces and spans for improved monitoring. Conclude with a demonstration of Metis, showcasing features for source code integration, pull request analysis, and enhanced observability to strengthen your database CI practices.
Missing Chapter in Your CI Playbook: Database Guardrails
Overview
Syllabus
intro
preface
be proactive and push to the left
know the context to find the root cause! monitor and troubleshoot
how do you know your code will work in production?
what can go wrong?
ci/cd
so what can go wrong?
problems with databases
slow queries
incompatible changes in schema
missing indexes
too many indexes
bugs
orm challenges - n plus 1 selects
- joins
- polymorphism
- data types
- lack of visibility
- migrations
- reviews
know the context to find the root cause
executing the query
anatomy of an sql query
observability
otel
traces and spans in otel and jaeger
load testing?
be proactive and push to the left!
metis demo
metis features
source code integration
pull request analysis
observability
summary
thank you
Taught by
Conf42
