Python client

  1. The connector of database backend, currently is MySQL.

a) The connector: https://dev.mysql.com/doc/connector-python/en/connector-python-introduction.html

b) The configuriton

c) PEP 0249: https://peps.python.org/pep-0249/

d) Connection ways with Cloud SQL: Connect Overview

e) Read official document of PyMySQL at Github

Notes:

  • The currently supported driver for MySQL is pymysql. Ref: https://cloud.google.com/sql/docs/mysql/connect-connectors#python_1

f) Connection String use PyMysql:

Ref: https://pypi.org/project/cloud-sql-python-connector/

mssql+pymssql://<username>:<password>@<freetds_name>/?charset=utf8

Ref: https://docs.sqlalchemy.org/en/14/dialects/mssql.html#mssql-pyodbc-access-tokens