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
cloud.google.com/sql/docs/pos...
gcloud cli
cloud.google.com/sdk/docs/ins...
Set up gcloud Application Default Credentials
cloud.google.com/docs/authent...
Connecting Cloud Run to Cloud SQL
cloud.google.com/sql/docs/pos...
Previous video on Manually Deploy Docker Image to Google Cloud Run
• Manually Deploy Docker...
Follow me on social media!
Twitter: / scriptbytesio
Instagram: / scriptbytes
Check out my blog!
scriptbytes.io/

[@kamanemo]

Thanks. Great job!

[@guilhermematos1953]

thats what i looking for, thanks!

[@scriptbytes]

Glad I could help!

[@mrestrella4]

Good video, Thanks!

[@scriptbytes]

Glad you liked it! Thanks for watching.

[@tensor2539]

this video is helpful!

[@scriptbytes]

Thanks for watching!

[@abdulmalikmahasneh9853]

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

[@scriptbytes]

I haven’t used GKE so if I do this it would be after a bunch of experimenting

[@gordanabaksic2573]

😊

[@TrikNgonlen]

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

[@scriptbytes]

Unfortunately I don't know much about PHP/Laravel so I dunno how much help I would be with that.

[@TrikNgonlen]

@@scriptbytes that's ok..the point is "I need help on how to deploy web app or API with Cloud Run + Cloud SQL service". Thank you.

[@scriptbytes]

Ah yes of course. That is something I've had on my list! Not sure when I'll get to it, but hopefully soon!

[@TrikNgonlen]

It's great to hear that.@@scriptbytes

[@gordanabaksic2573]

18:59

[@putinninovacuna8976]

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.

[@scriptbytes]

It’s all a balance of security and usability, and also it’s a result of using cloud managed services.
However, you don’t need the IPs of all your users. That part is only for developers who need to connect directly to your database.