Intro / Module Description

The pgdbpool Python Module is a tiny PostgreSQL Database Connection De-Multiplexer primarily scoped for Web- / Application Server.

1. Basic Install

pip3 install pgdbpool

2. Dependencies

psycopg2 PostgreSQL Python Module is required. Preferable installation with OS Package Manager.

# install psycopg2
apt-get install python3-psycopg2

3. Build Dependencies

On current Debian 12 / Ubuntu 22.04.3, 24.04.1 install the following additional packages (Documentation Rendering & Testing).

# install base packages
apt-get install python3-pip python3-sphinx python3-sphinx-rtd-theme

# install pytest for running unit and integration tests
apt-get install python3-pytest python3-pytest-pep8

4. Tests

To run all tests (unit and integration) after pip package installation.

# run pytest
cd ./ && pytest

5. Current Features

  • Connection Pooling in (threaded) Web-Server Environment (Single Destination DB-Node)

  • Automatic DB Reconnection

  • PostgreSQL Prepared Queries Module

6. Planned Features

  • Connection Load Balancing to multiple (auto-scaled) Database Nodes