Database Guardrails - New Age for Developers and Databases

Explore the evolution of database management and the concept of database guardrails in this conference talk from Conf42 JavaScript 2023. Delve into the complexities of modern database systems, including challenges with slow queries, schema changes, indexing, and ORM issues. Learn about monitoring and observability techniques, with a focus on OpenTelemetry and Jaeger. Discover how database guardrails can proactively address common problems by providing context, analyzing queries, and integrating with source code and pull requests. Gain insights into executing SQL queries and implementing effective database management strategies to enhance developer productivity and system reliability.

intro
preamble
where we used to be...
where we are now
everything is complex
monitoring doesn't make it simpler
what breaks in the current world?
problems with databases
slow queries
incompatible changes in schema
missing indexes
too many indexes
bugs
- n+1 selects
- joins
- polymorphism
- data types
- lack of visibility
- migrations
- reviews
tests - do they work?
load testing?
solution - database guardrails
know the context to find the root cause
monitoring and observability
opentelemetry otel
traces and spans in otel and jaeger
what to observe?
executing the query: parser, rewriter, planner, executor
anatomy of an sql query
database guardrails
be proactive and push to the left!
- demo
- source code integration
- pull request analysis, observability
summary
thank you