Date: Wed, 17 Feb 2021 00:00:00 +0000
<p>This week on the podcast, <a href="https://twitter.com/markmirch">Mark Mirchandani</a> and <a href="https://twitter.com/gabidavila">Gabi Ferrara</a> talk with Nimesh Bhagat about Cloud SQL Insights. This powerful tool enables developers to diagnose database issues for faster, smoother performance.</p> <p>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.</p> <p>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.</p> <h5 id="nimesh-bhagat">Nimesh Bhagat</h5> <p>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.</p> <h5 id="cool-things-of-the-week">Cool things of the week</h5> <ul> <li>A new collaboration with Google Cloud <a href="https://blog.twitter.com/engineering/en_us/topics/infrastructure/2018/a-new-collaboration-with-google-cloud.html"> blog</a></li> <li>Don’t fear the authentication: Google Drive edition <a href="https://cloud.google.com/blog/topics/developers-practitioners/dont-fear-authentication-google-drive-edition"> blog</a></li> </ul> <h5 id="interview">Interview</h5> <ul> <li>Cloud SQL Insights <a href="https://cloud.google.com/sql/docs/postgres/insights-overview">docs</a></li> <li>Cloud SQL Documentation <a href="https://cloud.google.com/sql/docs/postgres">docs</a></li> <li>GCP Podcast Episode 163: Cloud SQL with Amy Krishnamohan <a href="https://www.gcppodcast.com/post/episode-163-cloud-sql-with-amy-krishnamohan/"> podcast</a></li> <li>Google Cloud Monitoring <a href="https://cloud.google.com/monitoring">site</a></li> <li>Database observability for developers: introducing Cloud SQL Insights <a href="https://cloud.google.com/blog/products/databases/get-ahead-of-database-performance-issues-with-cloud-sql-insights"> blog</a></li> <li>Introduction to Cloud SQL Insights <a href="https://codelabs.developers.google.com/codelabs/cloud-sql-insights-intro#0"> codelab</a></li> <li>Boost your query performance troubleshooting skills with Cloud SQL Insights <a href="https://cloud.google.com/blog/topics/developers-practitioners/boost-your-query-performance-troubleshooting-skills-cloud-sql-insights"> blog</a></li> <li>Introducing Sqlcommenter: An open source ORM auto-instrumentation library <a href="https://cloud.google.com/blog/topics/developers-practitioners/introducing-sqlcommenter-open-source-orm-auto-instrumentation-library"> blog</a></li> <li>Introducing Cloud SQL Insights <a href="https://www.youtube.com/watch?v=qN7x3ngwz1o&feature=emb_logo">video</a></li> <li>Cloud SQL Github <a href="https://github.com/GoogleCloudPlatform/cloudsql-proxy">site</a></li> </ul> <h5 id="what-s-something-cool-you-re-working-on">What’s something cool you’re working on?</h5> <p>Gabi is working on several things, including Schema Migrations with CI/CD pipelines. She is always available on Twitter and she offers free <a href="http://gabi.tips/slots">office hours</a>!</p> <h5 id="sound-effects-attribution">Sound Effects Attribution</h5> <ul> <li>“Small Audience Laugh” by Tim Kahn of <a href="https://Freesound.org">Freesound.org</a></li> </ul>
