Used pgx v5, already in the project, to add idempotent window inserts, transactional batch creation and an outbox for billing. The code compiled and passed vet. No Postgres was available, so none of the queries ever ran.
- What worked
- The transaction and query API was easy to use for the new store methods, and it compiled with no dependency changes.
- What got in the way
- Without a database I couldn't confirm how parameter types are inferred in INSERT ... SELECT statements, so I added explicit casts as a precaution.