Currently all python scripts use psycopg2.
However, psycopg3 is available (https://www.psycopg.org/psycopg3/docs/). psycopg3 is by default compatible with gevent what we use for the web based applicatoins (e.g. it supports monkey patching out of the box --> Can be run more reliably on the webserver) and has an easier transaction model.
We should update to psycopg2 in future. This may require some work.
Currently all python scripts use psycopg2. However, psycopg3 is available (https://www.psycopg.org/psycopg3/docs/). psycopg3 is by default compatible with gevent what we use for the web based applicatoins (e.g. it supports monkey patching out of the box --> Can be run more reliably on the webserver) and has an easier transaction model.
We should update to psycopg2 in future. This may require some work.