djorm-ext-pool
pypi i djorm-ext-pool

djorm-ext-pool

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

by djangonauts

0.8.2 (see all)License:BSD
pypi i djorm-ext-pool
Readme

djorm-ext-pool

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:

.. code-block:: python

# settings.py

INSTALLED_APPS = (
    'djorm_pool',
    ...
)

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

Example:

.. code-block:: python

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:

.. code-block:: python

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

.. image:: https://d2weczhvl823v0.cloudfront.net/djangonauts/djorm-ext-pool/trend.png :alt: Bitdeli badge :target: https://bitdeli.com/free

GitHub Stars

123

LAST COMMIT

3yrs ago

MAINTAINERS

1

CONTRIBUTORS

6

OPEN ISSUES

6

OPEN PRs

0
VersionTagPublished
0.8.2
8yrs ago
0.8.1
9yrs ago
0.8
9yrs ago
0.7
9yrs ago
No alternatives found
No tutorials found
Add a tutorial