Skip to main content

Postgres Connection Pooling for Django.

This project has been archived.

The maintainers of this project have marked this project as archived. No new releases are expected.

Project description

This is a simple Postgres Connection Pooling backend for Django 1.4+, powered by the lovely and beautiful SQLAlchemy.

Usage

Using Django-PostgresPool is simple, just set django_postgrespool as your connection engine:

DATABASES = {
    'default': {
        'ENGINE': 'django_postgrespool'

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

import dj_database_url

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

If you’re using south:

SOUTH_DATABASE_ADAPTERS = {
    'default': 'south.db.postgresql_psycopg2'
}

Everything should work as expected.

Installation

Installing Django-PostgresPool is simple, with pip:

$ pip install django-postgrespool

Configuration

Optionally, you can provide additional options to pass to SQLAlchemy’s pool creation:

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.

Django 1.3 Support

django-postgrespool currently supports Django 1.4 and greater. See this ticket for 1.3 support.

Project details


Release history Release notifications | RSS feed

Download files

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

Source Distribution

django-postgrespool-0.3.1.tar.gz (4.3 kB view details)

Uploaded Source

File details

Details for the file django-postgrespool-0.3.1.tar.gz.

File metadata

File hashes

Hashes for django-postgrespool-0.3.1.tar.gz
Algorithm Hash digest
SHA256 a969b1b2d71c4c440c9b97a54c37c21e5047d43f4590aef13c7342983eb9a03b
MD5 170adaa2b756f846a1e9ec46152dda05
BLAKE2b-256 42bf85ea69cf9807218c0257dd31f1a6b993a3fa41a2372f7eb96ea809b72a35

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page