Completed
too many indexes
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Database Guardrails - New Age for Developers and Databases
Automatically move to the next video in the Classroom when playback concludes
- 1 intro
- 2 preamble
- 3 where we used to be...
- 4 where we are now
- 5 everything is complex
- 6 monitoring doesn't make it simpler
- 7 what breaks in the current world?
- 8 problems with databases
- 9 slow queries
- 10 incompatible changes in schema
- 11 missing indexes
- 12 too many indexes
- 13 bugs
- 14 - n+1 selects
- 15 - joins
- 16 - polymorphism
- 17 - data types
- 18 - lack of visibility
- 19 - migrations
- 20 - reviews
- 21 tests - do they work?
- 22 load testing?
- 23 solution - database guardrails
- 24 know the context to find the root cause
- 25 monitoring and observability
- 26 opentelemetry otel
- 27 traces and spans in otel and jaeger
- 28 what to observe?
- 29 executing the query: parser, rewriter, planner, executor
- 30 anatomy of an sql query
- 31 database guardrails
- 32 be proactive and push to the left!
- 33 - demo
- 34 - source code integration
- 35 - pull request analysis, observability
- 36 summary
- 37 thank you
