Set the connection duration when using SQL Alchemy

Configure the maximum number of seconds a connection can persist when connecting to Cloud SQL for PostgreSQL by using SQLAlchemy.

Explore further

For detailed documentation that includes this code sample, see the following:

• Manage database connections

Code sample

Python

To authenticate to Cloud SQL for PostgreSQL, set up Application Default Credentials. For more information, see Set up authentication for a local development environment.

# 'pool_recycle' is the maximum number of seconds a connection can persist.
# Connections that live longer than the specified amount of time will be
# re-established
pool_recycle=1800,  # 30 minutes

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.