Podevcast

SQL Commenter with Nimesh Bhagat and Morgan McLean

Google Cloud Platform Podcast

Episode | Podcast

Date: Wed, 16 Mar 2022 17:00:00 +0000

First time co-host <a href="https://twitter.com/jankleinert">Jan Kleinert</a> joins <a href="https://twitter.com/markmirch">Mark Mirchandani</a> this week to talk about database observability and the cool tools that make it possible. Morgan McLean and Nimesh Bhagat describe database observability, which uses metrics, logs, and other tools to help users understand the health of your database. We talk about Object Relational Mappers and the challenges with using these for debugging database performance. SQL Commenter helps database observability in two ways: it is both a library and a standard, Nimesh tells us. He describes the process for us, detailing exactly how SQL Commenter effects projects. Recently, SQL Commenter was donated to OpenTelemetry to augment the observability offerings, create an application standard, and make it easier for developers to use a variety of different tools and languages. Engineers can get end-to-end traces no matter which database technologies they use. Morgan tells us about Splunk and how information from SQL Commenter is taken into Splunk and used. Backend data like metrics from Cloud Monitoring and client libraries can be correlated together with SQL Commenter and brought into Splunk for full stack observability. Nimesh offers client examples to help us understand how these useful tools integrate for optimal observability. He tells us about the databases and ORMs supported by SQL Commenter. Our guests and co-host Jan give tips to help our listeners get started with SQL Commenter and talk about what they’re looking forward to in the future of observability. <h5>Nimesh Bhagat</h5> Nimesh is a product manager at Google Cloud, he leads Database Observability. He has worked across engineering and product roles, building highly available and high performance enterprise infrastructure used by Fortune 500 companies. His passion lies in combining powerful infrastructure with simple user experience so that every business and developer can build software at scale and velocity. <h5>Morgan McLean</h5> Morgan is Director of Product Management at Splunk and co-creator of OpenCensus / OpenTelemetry. <h5>Cool things of the week</h5> <ul> <li style="font-weight: 400;">Google Cloud Innovators <a href="https://cloud.google.com/innovators">site</a></li> <li style="font-weight: 400;">Redesigning the Cloud SDK + CLI for easier development <a href="https://cloud.google.com/blog/products/application-development/redesigning-the-cloud-sdk-cli-for-easier-development"> blog</a></li> <li style="display: inline;"> <ul> <li style="font-weight: 400;">GCP Podcast Episode 291: Redesigning the Cloud SDK and CLI with Wael Manasra and Cody Oss <a href="https://gcppodcast.com/post/episode-291-redesigning-the-cloud-sdk-and-cli-with-wael-manasra-and-cody-oss/"> podcast</a></li> </ul> </li> <li style="font-weight: 400;">What is Active Assist? <a href="https://www.youtube.com/watch?v=A2VgO5N_B7g">video</a></li> <li style="display: inline;"> <ul> <li style="font-weight: 400;">GCP Podcast Episode 235: Active Assist with Chris Law + MariaDB SkySQL with Robert Hedgepeth <a href="https://www.gcppodcast.com/post/episode-235-active-assist-with-chris-law-and-skysql-with-robert-hedgepeth/"> podcast</a></li> </ul> </li> </ul> <h5>Interview</h5> <ul> <li style="font-weight: 400;">SQL Commenter <a href="https://google.github.io/sqlcommenter/">site</a></li> <li style="font-weight: 400;">Sequelize <a href="https://sequelize.org/">site</a></li> <li style="font-weight: 400;">SQL Alchemy <a href="https://www.sqlalchemy.org/">site</a></li> <li style="font-weight: 400;">ADO.net <a href="https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ado-net-overview"> site</a></li> <li style="font-weight: 400;">GCP Podcast Episode 247: Cloud SQL Insights with Nimesh Bhagat <a href="https://www.gcppodcast.com/post/episode-247-cloud-sql-insights-with-nimesh-bhagat/"> podcast</a></li> <li style="font-weight: 400;">OpenTelemetry <a href="https://opentelemetry.io/">site</a></li> <li style="font-weight: 400;">Splunk <a href="https://www.splunk.com/">site</a></li> <li style="font-weight: 400;">Cloud Monitoring <a href="https://cloud.google.com/monitoring">site</a></li> <li style="font-weight: 400;">Cloud Spanner <a href="https://cloud.google.com/spanner">site</a></li> <li style="font-weight: 400;">Cloud SQL <a href="https://cloud.google.com/sql">site</a></li> <li style="font-weight: 400;">Cloud Trace <a href="https://cloud.google.com/trace">site</a></li> <li style="font-weight: 400;">Sqlcommenter now extending the vision of OpenTelemetry to databases <a href="https://cloud.google.com/blog/products/databases/sqlcommenter-merges-with-opentelemetry"> blog</a></li> </ul> <h5>Hosts</h5> Mark Mirchandani and Jan Kleinert