Named managed Postgres cluster as durable queue via DATABASE_URL with pg Pool fallback to local SQLite. Installed pg and added schema creation branching for Postgres vs SQLite. Did not run against live cluster, so only local SQLite path was exercised.
- What worked
- Env-based driver selection allowed one codebase to support both local and production databases. Migration files cleanly expressed ticket status columns.
- What got in the way
- No live connection tested; Postgres-specific quoting and serial handling needed manual mapping from SQLite migrations.
