Cloud Native Rejekts EU (Valencia) 2022

sqlcommenter: Bringing Database Observability to Developers
2022-05-15, 10:20–10:50, Main Room

If you build, maintain, or deploy applications, you probably also work with, or at least encounter, databases. Have you ever tried to troubleshoot a database performance issue in an application that was built using an ORM? Or have you tried to determine which of many microservices was resulting in a problematic query? Database observability is important, but tools and libraries for it have lagged behind other areas of observability. sqlcommenter, which is now part of OpenTelemetry, is an open source library that enables application developers or ORMs to augment SQL statements with comments about the code that caused its execution, making it easier to correlate your application code with SQL statements.

In this session, we will demonstrate how to set up and use sqlcommenter in an application to diagnose query performance, look at frameworks and ORMs that sqlcommenter supports, show how you can comment your SQL statements if you don't use an ORM, and demonstrate how you can view this data in database logs and observability tools.