Psycopg

Psycopg is a PostgreSQL adapter based on the C library for PostgreSQL libpq. Among other things, it offers:

• DB API 2.0 compatibility

• Multithreading with thread safety

• Connections pooling to be able to use a cache of existing database connections for queries.

• Asynchronous and Coroutines support

• Adaptation of the Python types in SQL

Install

With Spack you can provide psycopg2 in your kernel, e.g. with

$ spack env activate python-311
$ spack install py-psycopg2