Postgres Connection Pooling for Django.
Reason this release was yanked:
This package is deprecated. Try using: https://pypi.org/project/django-postgrespool2/
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() DATABASES['default']['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
Hashes for django-postgrespool-0.3.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7622a56a5652bb6dee1a279e7e2ec4b18efcb5670e4cc17c57f87040984a2e8c |
|
MD5 | 3904250428523e76f057113d07405498 |
|
BLAKE2b-256 | 8ecd0e9b7c297a84caf6334d1dbd9da35af50d533f1230b96bc21223d5addc1e |