More advanced topics

Once you have familiarised yourself with the Psycopg basic operations, you can take a look at the chapter of this section for more advanced usages.

Contents:

• Concurrent operations
  • Asynchronous operations
  • with async connections
  • Interrupting async operations
  • Gevent support
  • Server messages
  • Asynchronous notifications
  • Detecting disconnections
• Static Typing
  • Generic types
  • Type of rows returned
  • Generic pool types
  • Example: returning records as Pydantic models
  • Checking literal strings in queries
• Row factories
  • Creating new row factories
• Connection pools
  • Basic connection pool usage
  • Pool startup check
  • Connections life cycle
  • Other ways to create a pool
  • Null connection pools
  • Pool connection and sizing
  • Connection quality
  • Pool operations logging
  • Pool stats
• Cursor types
  • Client-side cursors
  • Client-side-binding cursors
  • Server-side cursors
  • Raw query cursors
• Data adaptation configuration
  • Writing a custom adapter: XML
  • Example: PostgreSQL numeric to Python float
  • Example: handling infinity date
  • Dumpers and loaders life cycle
• Prepared statements
  • Using prepared statements with PgBouncer
• Pipeline mode support
  • Client-server messages flow
  • Pipeline mode usage
  • Synchronization points
  • The fine prints