Google Cloud SQL with a Public IP | Tutorial

Поділитися
Вставка
  • Опубліковано 8 вер 2024
  • 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.c...
    gcloud cli
    cloud.google.c...
    Set up gcloud Application Default Credentials
    cloud.google.c...
    Connecting Cloud Run to Cloud SQL
    cloud.google.c...
    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/

КОМЕНТАРІ • 18

  • @kamanemo
    @kamanemo 11 місяців тому +1

    Thanks. Great job!

  • @guilhermematos1953
    @guilhermematos1953 3 місяці тому

    thats what i looking for, thanks!

  • @mrestrella4
    @mrestrella4 9 місяців тому

    Good video, Thanks!

    • @scriptbytes
      @scriptbytes  9 місяців тому

      Glad you liked it! Thanks for watching.

  • @abdulmalikmahasneh9853
    @abdulmalikmahasneh9853 6 місяців тому

    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
      @scriptbytes  6 місяців тому

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

  • @tensor2539
    @tensor2539 6 місяців тому

    this video is helpful!

  • @gordanabaksic2573
    @gordanabaksic2573 Рік тому +1

    😊

  • @putinninovacuna8976
    @putinninovacuna8976 4 місяці тому

    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
      @scriptbytes  4 місяці тому

      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.

  • @TrikNgonlen
    @TrikNgonlen 9 місяців тому

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

    • @scriptbytes
      @scriptbytes  9 місяців тому

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

    • @TrikNgonlen
      @TrikNgonlen 9 місяців тому +1

      @@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
      @scriptbytes  9 місяців тому +1

      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
      @TrikNgonlen 9 місяців тому

      It's great to hear that.@@scriptbytes

  • @gordanabaksic2573
    @gordanabaksic2573 Рік тому +2

    18:59