Does this include static file configuration?

Yes, it includes WhiteNoise integration and app.yaml handler configuration to serve static files directly from the App Engine instance.

How do I manage database passwords securely?

The skill instructs you to use Google Secret Manager or runtime environment variables rather than hardcoding credentials in your repository.

How does this skill handle local vs production database connections?

It uses environment variable detection to switch between local connections via Cloud SQL Auth Proxy and production connections via Unix sockets at /cloudsql/.

What versions of Django and PostgreSQL are supported?

It is optimized for Django 5.1+ and PostgreSQL 15+, utilizing the psycopg2-binary adapter and modern Gunicorn configurations.

Django Cloud SQL PostgreSQL

Name: Django Cloud SQL PostgreSQL
Author: jezweb

byjezweb

•

245

Cloud Infrastructure

Deploys and configures Django applications on Google App Engine Standard with secure Cloud SQL PostgreSQL integration.

About

This skill provides a production-ready blueprint for running Django in the Google Cloud ecosystem, focusing on the specific networking requirements of App Engine and Cloud SQL. It automates the configuration of Unix socket connections for production, sets up the Cloud SQL Auth Proxy for secure local development, and optimizes Gunicorn settings for high-performance hosting. By incorporating database pooling and security best practices, it helps developers resolve common deployment errors like 'No such file or directory' and authentication failures.

Key Features

Advanced database connection pooling with CONN_MAX_AGE
Secure Unix socket connection setup for PostgreSQL
Automated App Engine Standard deployment configuration
245 GitHub stars
Local development integration via Cloud SQL Auth Proxy
Optimized Gunicorn and WhiteNoise production settings

Use Cases

Setting up a secure local development environment that mirrors production database behavior
Migrating a local Django project to Google App Engine Standard
Troubleshooting PostgreSQL connection issues in Google Cloud environments

About

Key Features

Advanced database connection pooling with CONN_MAX_AGE
Secure Unix socket connection setup for PostgreSQL
Automated App Engine Standard deployment configuration
245 GitHub stars
Local development integration via Cloud SQL Auth Proxy
Optimized Gunicorn and WhiteNoise production settings

Use Cases

Setting up a secure local development environment that mirrors production database behavior
Migrating a local Django project to Google App Engine Standard
Troubleshooting PostgreSQL connection issues in Google Cloud environments