Postgres Connection Pooling for Django.
Project description
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
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-postgrespool2-1.0.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 76550e5b2e5a65bbd2022467c4720d7b2eb1f8281fce93ed91d90f559028ec04 |
|
MD5 | e30916cd415b3d87b984e0bb9f2ea830 |
|
BLAKE2b-256 | c2c81994d96d0713a5dd17503894b1bd4871b50cd0b2fc156fd1d002e187c334 |