Read the abstract ➤ https://www.conf42.com/JavaScript_2023_Adam_Furmanek_database_guardrails Other sessions at this event ➤ https://www.conf42.com/js2023 Join Discord ➤ https://discord.gg/DnyHgrC7jC Chapters 0:00 intro 0:22 preamble 1:03 where we used to be... 2:41 where we are now 5:00 everything is complex 5:28 monitoring doesn't make it simpler 6:35 what breaks in the current world? 8:00 problems with databases 10:12 slow queries 16:04 incompatible changes in schema 19:46 missing indexes 21:01 too many indexes 22:00 bugs orm challenges 24:18 - n+1 selects 26:37 - joins 27:04 - polymorphism 28:20 - data types 30:06 - lack of visibility 30:42 - migrations 31:21 - reviews 31:57 tests - do they work? 33:02 load testing? 35:01 solution - database guardrails 35:31 know the context to find the root cause 40:07 monitoring and observability 40:42 opentelemetry (otel) 41:20 traces and spans in otel and jaeger 42:39 what to observe? 42:51 executing the query: parser, rewriter, planner, executor 43:20 anatomy of an sql query 45:17 database guardrails 48:10 be proactive and push to the left! metis 48:22 - demo 52:37 - source code integration 52:46 - pull request analysis, observability 53:00 summary 53:55 thank you