Jan leads a team of Developer Advocates at Google focused on Databases, Kubernetes, Compute, and Networking. Prior to joining Google, she worked in a variety of roles from developer relations to software engineering to web analytics and conversion optimization. She lives in Raleigh, North Carolina, where she enjoys spending time outdoors and hiking with her family and their beagle, Nugget.
sqlcommenter: Bringing Database Observability to Developers
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.