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:

  • Asynchronous operations
    • with async connections
    • Interrupting async operations using Ctrl-C
    • Server messages
    • Asynchronous notifications
    • Detecting disconnections
  • Static Typing
    • Generic types
    • Type of rows returned
    • Example: returning records as Pydantic models
    • Checking literal strings in queries
  • Row factories
    • Creating new row factories
  • Connection pools
    • Pool life cycle
    • Connections life cycle
    • Using connections from the pool
    • Pool connection and sizing
    • Null connection pools
    • Connection quality
    • Pool stats
  • Cursor types
    • Client-side cursors
    • Client-side-binding cursors
    • Server-side 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
  • Pipeline mode support
    • Client-server messages flow
    • Pipeline mode usage
    • Synchronization points
    • The fine prints

psycopg

Navigation

  • Getting started with Psycopg 3
  • More advanced topics
    • Asynchronous operations
    • Static Typing
    • Row factories
    • Connection pools
    • Cursor types
    • Data adaptation configuration
    • Prepared statements
    • Pipeline mode support
  • Psycopg 3 API
  • psycopg release notes
  • psycopg_pool release notes

Related Topics

  • Documentation overview
    • Previous: Differences from psycopg2
    • Next: Asynchronous operations

Quick search

©2022, Daniele Varrazzo and The Psycopg Team. | Powered by Sphinx 4.5.0 & Alabaster 0.7.12