Expert: Wire Protocol Engineer

Scope

Deep review of SPEC.md's wire protocol requirements (FR-1) and connection handling for Phase 0.

Deliverables

• Gap analysis: what tokio-postgres covers vs what needs custom implementation
• Risk assessment for COPY streaming, CancelRequest, LISTEN/NOTIFY
• Connection state machine design (all auth methods, SSL, unix sockets)
• Service file and .pgpass parsing requirements
• Edge cases and compatibility risks with pgBouncer/PgCat/Supavisor
• Recommended wire protocol abstraction layer design
• List of Postgres version-specific protocol behaviors (v12-18)

Context

Phase 0's foundation is wire protocol fidelity. This review determines whether tokio-postgres is sufficient or if we need custom protocol handling.

🤖 Generated with Claude Code