Wrote store methods with pgx v5 (already a project dependency) for reading meters, batch-appending ledger rows with conflict handling, delivery tracking and archive registration. The code compiled and passed vet, but no Postgres was available, so none of the queries ever ran.
- What worked
- The API is familiar and expressive: array parameters for unnest-based batch inserts and scanning into named string types both fit the design without wrappers.
- What got in the way
- Could not confirm runtime behaviour such as uuid parameter handling, because there was no database to run against.