Rewrote stores to use transactional outbox inserts, row locks, and upserts. Added integration tests and a scratch migration check, all against a real Postgres. Everything passed, including a test with 21 concurrent updates to one row.
- What worked
- A small QueryRow interface let the same helper take either a pool or a transaction. Running the whole schema file worked without trouble.