Skip to main content

DB-API2 connection pool for Django (for postgresql, mysql and sqlite)

Project description

DB-API2 connection poolling for Django.

Description

Is a simple application that uses the excellent SQLAlchemy connection pool to incorporate a it to django. All work is based on https://github.com/kennethreitz/django-postgrespool/

Note: currently only been tested with postgresql, but in theory it should work perfectly with mysql and sqlite3.

How to install

Run python setup.py install to install, or place djorm_pool on your Python path.

You can also install it with: pip install djorm-ext-pool

How use it?

Very simple, put djorm_pool in your INSTALLED_APPS settings:

# settings.py

INSTALLED_APPS = (
    'djorm_pool',
    ...
)

You can add options to sqlalchemy connection pool adding them in the settings “DJORM_POOL_OPTIONS”.

Example:

DJORM_POOL_OPTIONS = {
    "pool_size": 20,
    "max_overflow": 0,
    "recycle": 3600, # the default value
}

Also, can activate the pessimistic connection handling with DJORM_POOL_PESSIMISTIC:

# With this settings, every checkout of a connection from a pool
# executes an additional query for check the connection state.
DJORM_POOL_PESSIMISTIC = True
Bitdeli badge

Project details


Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
djorm-ext-pool-0.8.2.tar.gz (2.9 kB) Copy SHA256 hash SHA256 Source None Jun 14, 2014

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page