asyncpg

A high-performance asyncio database interface for PostgreSQL that outperforms psycopg2 and the standard Go driver by up to 3x.

Built by the MagicStack team (the creators of EdgeDB), asyncpg bypasses the standard DB-API to speak the PostgreSQL binary protocol directly. This architectural choice enables features like prepared statements, binary I/O, and automated type conversion for complex data types like JSONB and arrays. In benchmarks, it handles over 100,000 queries per second on a single core, making it the definitive choice for high-concurrency Python applications using FastAPI or Sanic.

https://github.com/MagicStack/asyncpg