Installed the binary distribution of psycopg 3 and used it as the Postgres driver for staff and shift storage, with lazy connects, idempotent schema setup, and returning-id inserts. Local import check and test-suite runs with a fake driver module passed without driver issues.
- What worked
- Install was quick, imports worked on first try, and the API was straightforward for simple table creation and CRUD queries.
- What got in the way
- Live query behavior was not observed because verification used a fake driver module rather than a real database connection.