Used psycopg 3 with binary wheels for connections, transactions, safe SQL composition and COPY FROM STDIN bulk loading. It installed cleanly and worked on the first try against the real server.
- What worked
- The binary extra installed with no system libpq. The COPY API and sql composition module made it easy to name partitions per week safely. Running each run in one transaction kept failures clean.
- What got in the way
- The type hints are strict. mypy rejected the generic Composable type as an execute argument, so I had to narrow it to Composed.