Connect Google Cloud SQL to a Python Cloud Function
ฝัง
- เผยแพร่เมื่อ 21 ก.ค. 2024
- In this video we will connect to the Google Cloud SQL database from a Cloud Function written in
Python. We will start by creating the Cloud SQL instance, then connect to it and enter some data,
then work on the function that can read this data.
Source code, commands and links used in the video:
github.com/titus58/youtube-tu...
Chapters
00:00 Introduction
00:28 Create the Cloud SQL instance
02:22 A warning on Cloud SQL pricing
05:33 Connect to Cloud SQL from localhost using cloud_sql_proxy
09:50 Create database table and enter data
12:39 Start on the Python code, install PyMySQL library
14:28 Write main.py
18:28 Passing query parameters without causing SQL injection attack
19:59 Reorganize code, prepare for Cloud Function
21:39 Create the cloud function
22:29 Give IAM permission to the App Engine service account
25:08 Investigate function failure, enable Cloud SQL Admin API
26:46 Final testing and repeated warning about cost
27:41 Outro
Muchas gracias, tenia mas de un día queriendome conectar y no podía.
Thank you very much i really appreciate people like you who spread this kind of knowledge
Thank you 🙏
Thanks, Vladsave, your video made my task very easy.
Great tutorial, thanks a lot!
Awesome tutorial 💌
Thanks for
I am unable to connect to my SQL instance just following what you have provided. I see you used socket from local host but on cloud function you did not use the socket part. I get the following error
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'w.x.y.z' (timed out)")
My SQL instance has a public and private IP.
Should I use sockets even on the cloud, or maybe sql proxy? service account is as you ve shown with the right level of permissions.
If it fails on the Cloud functions make sure you enable Cloud SQL Admin API. If the proxy fails on your local machine make sure the user you are using has permissions for Cloud SQL and you enter the password correctly. You can go to IAM in Google Web Console and give "Cloud SQL Admin" to the user you logged in with
I want to connect to my instance in a project I have deployed on google server. I am scrapping data and I want to store the data in this instance. How do I do that? Can you spare me few minutes? I will provide my contact details.
Do you have tutorial about deploying Laravel App + MySQL to Cloud Run + Cloud SQL?
Unfortunately no, I never used Laravel. Maybe I'll do one in the future
@@vladsavecoding4111 awesome! Can't wait for that
are all the process the same if my machine runs on
windows?
Yes, you can use cloud_sql_proxy on windows
@@vladsavecoding4111 thank you for replying, but can you make a tutorial where in you use a machine running on windows? because I somehow cannot follow this video since its on mac