Skip to main content
Python Software Foundation 20th Year Anniversary Fundraiser  Donate today!

Postgres Connection Pooling for Django.

Project description

https://badge.fury.io/py/django-postgrespool2.svg

Django-PostgresPool2

This is a fork of original django-postgrespool.

Installation

Installing Django-PostgresPool2 is simple, with pip:

$ pip install django-postgrespool2

Usage

Using Django-PostgresPool2 is simple, just set django_postgrespool2 as your connection engine:

DATABASES = {
    'default': {
        'ENGINE': 'django_postgrespool2'

If you’re using the dj-database-url module:

import dj_database_url

DATABASES = {'default': dj_database_url.config(engine='django_postgrespool2')}

Everything should work as expected.

Configuration

Optionally, you can provide pool class to construct the pool (default sqlalchemy.pool.QueuePool) or additional options to pass to SQLAlchemy’s pool creation.

DATABASE_POOL_CLASS = 'sqlalchemy.pool.QueuePool'

DATABASE_POOL_ARGS = {
    'max_overflow': 10,
    'pool_size': 5,
    'recycle': 300
}

Here’s a basic explanation of two of these options:

  • pool_size – The minimum number of connections to maintain in the pool.
  • max_overflow – The maximum overflow size of the pool. This is not the maximum size of the pool.

The total number of “sleeping” connections the pool will allow is pool_size. The total simultaneous connections the pool will allow is pool_size + max_overflow.

As an example, databases in the Heroku Postgres starter tier have a maximum connection limit of 20. In that case your pool_size and max_overflow, when combined, should not exceed 20.

Check out the official SQLAlchemy Connection Pooling docs to learn more about the optoins that can be defined in DATABASE_POOL_ARGS.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for django-postgrespool2, version 2.0.1
Filename, size File type Python version Upload date Hashes
Filename, size django-postgrespool2-2.0.1.tar.gz (7.1 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page