django-db-connection-pool

What it is and what it does

django-db-connection-pool replaces Django's standard database backends with pooled alternatives that reuse connections across requests rather than creating new ones each time. It wraps SQLAlchemy's connection pool implementation and supports MySQL, Oracle, PostgreSQL, and JDBC-based databases (Oracle and OceanBase). The package is designed to work correctly in multiprocess environments like uWSGI, where each worker process maintains its own independent pool.

You configure it by changing your Django DATABASES ENGINE setting from the standard backend (e.g., `django.db.backends.mysql`) to the pooled equivalent (e.g., `dj_db_conn_pool.backends.mysql`), then optionally tune pool behavior via POOL_OPTIONS (pool size, overflow limit, connection recycling interval). The pool manages connection lifecycle automatically; you use Django's ORM and raw queries exactly as normal.

Use it for

• High-traffic Django applications where connection creation overhead becomes a bottleneck and connection reuse would reduce latency
• Multiprocess deployments (uWSGI, Gunicorn with multiple workers) where each process needs its own pool to avoid connection conflicts
• Projects using Oracle or PostgreSQL that benefit from tunable pool parameters like connection recycling for long-lived connections
• JDBC-based database access (Oracle via JDBC, OceanBase) when native Python drivers are unavailable or unsuitable
• Applications with bursty traffic patterns where MAX_OVERFLOW allows temporary connection spikes beyond the base pool size

Worth the install?

AI-flagged interpretation of the facts on this page. Verify before relying on it.

Install

django-db-connection-pool on PyPI

Before you install

Low install friction; pure Python wheel. Maintenance status is aging—last commit was 466 days ago, though the repository remains active and the package is marked Production/Stable. Suitable for established projects but may see delayed responses to new issues.

Requires Django and one of SQLAlchemy-compatible database drivers (mysql-connector-python, cx_Oracle, psycopg2, or JPype for JDBC). JDBC backend requires JAVA_HOME and CLASSPATH environment variables to be set.

License in practice

MIT License permits commercial and private use, modification, and redistribution with minimal restrictions. Requires only that the license notice be included in copies or substantial portions of the software.

Quickstart

pip install django-db-connection-pool[mysql]

# In Django settings.py
DATABASES = {
    'default': {
        'ENGINE': 'dj_db_conn_pool.backends.mysql',
        'POOL_OPTIONS': {
            'POOL_SIZE': 10,
            'MAX_OVERFLOW': 10
        }
    }
}

Package facts

Evidence: django_db_connection_pool-1.2.6-py3-none-any.whl

Tags

More Python Modules packages

See also dj-database-url · sqlalchemy-jdbcapi · DBUtils · psycopg2-pool · psycopg-pool · django-db-geventpool · django-sequences · pondpond · databases · connection_pool