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