Google Cloud SQL with a Public IP | Tutorial

Learn how to:
1. Set up a Google Cloud SQL database with a public IP address. I use Postgres in this demo.
2. How to connect to it locally using either an authorized network or the Cloud SQL Proxy.
3. Then how to connect a locally running API to it. I'm using a .Net 6 API in this example.
4. Finally how to deploy that API to Cloud Run, and how to configure the connection there.

#development #sql #programming

Documentation links:
Cloud SQL Proxy

gcloud cli

Set up gcloud Application Default Credentials

Connecting Cloud Run to Cloud SQL

Previous video on Manually Deploy Docker Image to Google Cloud Run

Follow me on social media!

Check out my blog!

[putinninovacuna]

Why does connecting my web app to my database in Cloud SQL have to be so complex? I just want to connect my database to an AlloyDB, Cloud SQL, or some VM without so many complications. All I ask is to connect my web app so that it can be used and my embeddings can be saved. That’s all I want to do. But you say that I even need to know the IPs of the users who are going to use the app so that they can have access to save data in the database. It doesn’t make sense to have so much complexity.

[abdulmalikmahasneh]

great job and thank you for your effrots,
can you make another video on how to connect to cloud sql from GKE (Kubernetes cluster) ?

[TrikNgonlen]

Can you make tutorial on how to deploy laravel app with mysql to Cloud Run + Cloud SQL service?
Thanks.