postgresql - How to deploy PostgresSQL python app which is hosted in google cloud?

Question

I have problem with deploying python app which writes down additional info to sql database. Postgres SQL is hosted in google cloud and for connecting to it i'm using credential files and invoking it through cmd in path with stored json. Command In powershell

>>CD "path where stored"
>>cloud_sql_proxy -credential_file=./credentials.json -instances="[PROJECT-ID]:[REGION]:[INSTANCE-NAME]=tcp:5435"

The question, how i will deploy it google app engine, And how can i call function with json. without typing it into cmd?

question from:https://stackoverflow.com/questions/65872893/how-to-deploy-postgressql-python-app-which-is-hosted-in-google-cloud

Answer 1

I see you are using the Cloud SQL Proxy to connect to your PostgreSQL instance.

In the specific case of App Engine the public facing documentation offers clear instructions and code on how to achieve this.

You basically need to provide the App Engine's service account the correct permissions (the recommended role will be Cloud SQL Client) and adapt the code in your Python application to connect to the instance.

The link shared shows how to use the SQL alchemy to achieve this connection for both Public and Private IP.