asyncpg

asyncpg is a database interface library designed specifically for PostgreSQL and Python/asyncio. asyncpg is an efficient, clean implementation of PostgreSQL server binary protocol for use with Python’s asyncio framework.

asyncpg requires Python 3.8 or later and is supported for PostgreSQL versions 9.5 to 17. Other PostgreSQL versions or other databases implementing the PostgreSQL protocol may work, but are not being actively tested.

Contents

• Installation
  • Building from source
  • Running tests
• asyncpg Usage
  • Type Conversion
  • Custom Type Conversions
  • Transactions
  • Connection Pools
• API Reference
  • Connection
  • Prepared Statements
  • Transactions
  • Cursors
  • Connection Pools
  • Record Objects
  • Data Types
• Frequently Asked Questions
  • Does asyncpg support DB-API?
  • Can I use asyncpg with SQLAlchemy ORM?
  • Can I use dot-notation with asyncpg.Record? It looks cleaner.
  • Why can’t I use a cursor outside of a transaction?
  • Why am I getting prepared statement errors?
  • Why do I get PostgresSyntaxError when using expression IN $1?