Which Python API for PostgreSQL?

[Paul Boddie]

h112211 at gmail.com wrote:
>
> Any specific reasons to go for psycopg instead of PyGreSQL?

I can't really comment about PyGreSQL: due to the unavailability of
PyGreSQL packages for my system (and a long pause in its development
which suggested that it may not be the most appropriate choice) I
started using pyPgSQL a long time ago instead. However, recent
experiences suggest that psycopg (version 2) is faster than pyPgSQL and
also supports savepoints (whereas pyPgSQL seems not to). Moreover, it
has been asserted that pyPgSQL is in maintenance-only mode, whereas
psycopg is in active development. I suppose PyGreSQL is seeing more
action these days, too.

It's quite possible that all three packages will do what you want, but
perhaps only experience with them will give you the answer you're
looking for.

Paul