This week on the podcast, Mark Mirchandani and Gabi Ferrara talk with Nimesh Bhagat about Cloud SQL Insights. This powerful tool enables developers to diagnose database issues for faster, smoother performance.

Nimesh tells us the inspiration for Cloud SQL Insight’s development and describes its biggest benefits. One of the important aspects of Insights is the ability for developers to gain an application-centric view by allowing them to tag database queries with SQL comments. These tags are aggregated in Insights and give developers a visual of the database queries. Here, developers can see load patterns and use that information to improve database efficiency. Cloud SQL Insights offers managed database analysis that helps developers understand the past and predict the future.

Simplifying the journey of database debugging, Nimesh explains, was the goal of creating Cloud SQL Insights. He takes us through the process of using the software, pointing out the improvements Insights makes over the old way. Cloud SQL Insights only launched in January, but it’s already helping numerous clients with their projects. Nimesh describes these real-world uses, including Major League Baseball experience as part of Insights Early Access Program.

Nimesh Bhagat

Nimesh is a product manager at Google Cloud, he leads Cloud SQL Insights. 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.

Cool things of the week


A new collaboration with Google Cloud blog
Don’t fear the authentication: Google Drive edition blog


Interview


Cloud SQL Insights docs
Cloud SQL Documentation docs
GCP Podcast Episode 163: Cloud SQL with Amy Krishnamohan podcast
Google Cloud Monitoring site
Database observability for developers: introducing Cloud SQL Insights blog
Introduction to Cloud SQL Insights codelab
Boost your query performance troubleshooting skills with Cloud SQL Insights blog
Introducing Sqlcommenter: An open source ORM auto-instrumentation library blog
Introducing Cloud SQL Insights video
Cloud SQL Github site


What’s something cool you’re working on?

Gabi is working on several things, including Schema Migrations with CI/CD pipelines. She is always available on Twitter and she offers free office hours!

Sound Effects Attribution


“Small Audience Laugh” by Tim Kahn of Freesound.org