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

Project details


Release history Release notifications

History Node

0.8.2

This version
History Node

0.8.1

History Node

0.8

History Node

0.7

History Node

0.6

History Node

0.5

History Node

0.4.0

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.1.tar.gz (2.8 kB) Copy SHA256 hash SHA256 Source None Jan 4, 2014

Supported by

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