This package contains bindings for the PostgreSQL driver, using the driver manager to provide a DBAPI 2.0/PEP 249-compatible interface on top.
Dependencies: a build of the PostgreSQL driver, and the adbc-driver-manager
Python package. Optionally, install PyArrow to use the DBAPI 2.0-compatible interface.
Set the environment variable ADBC_POSTGRESQL_LIBRARY
to the path to libadbc_driver_postgresql.{dll,dylib,so}
before running pip install
.
# If not already installed pip install -e ../adbc_driver_manager export ADBC_POSTGRESQL_LIBRARY=/path/to/libadbc_driver_postgresql.so pip install -e --no-deps .
See CONTRIBUTING.md for details on the general build process.
A running instance of PostgreSQL is required. For example, using Docker:
$ docker run -it --rm \ -e POSTGRES_PASSWORD=password \ -e POSTGRES_DB=tempdb \ -p 5432:5432 \ postgres
Then, to run the tests, set the environment variable specifying the PostgreSQL URI before running tests:
$ export ADBC_POSTGRESQL_TEST_URI=postgresql://localhost:5432/postgres?user=postgres&password=password $ pytest -vvx
See CONTRIBUTING.md for details on the general test process.