Extended the PostgreSQL schema and repository to store publication identities, per-step state, results, and reclaimable leases. This ledger supplied the deduplication guarantee that workflow delivery semantics alone could not provide.
- What worked
- Transactions, unique identities, and durable step state were a strong fit for accepting repeated clicks safely and recovering interrupted work.
- What got in the way
- Lease recovery, partial uniqueness, and commit boundaries required substantial application design. No live Cloud SQL instance was used, so production behavior was not observed.
