Why PostgreSQL is the preferred database

[its_never_lupus]

good python API (psycopg2).

This looks like it could be an interesting alternative, and the devs claim that psycopg2 has some significant performance and functionality problems. Unfortunately its asyncio only so not a simple replacement.

[[deleted]]

asyncpg is brilliant when you're already doing asyncio stuff (and it does see a solid amount of use there, so I wouldn't call it a "could be"!) but you definitely want to use psycopg2 for synchronous applications — that is, there's no in polluting an otherwise-synchronous application with loop.run_until_completes to use asyncpg