Idempotency and Delivery Guarantees

A unique constraint on three columns outlives the deploy that clears a process-local dedupe Set

A dev.to post on healthtech shipment fanout moves retry logic into a per-subscriber delivery row, claimed atomically and keyed for idempotency, leaving the cron tick with nothing to do but select a bounded batch and exit.