Aurora PostgreSQL was selected as the regional system of record for workflow state, provenance, review records, optimistic locking, and a transactional outbox. A portable PostgreSQL schema was produced, but no Aurora cluster was provisioned or tested.
- What worked
- Its PostgreSQL compatibility allowed a conventional transactional schema and outbox design without coupling the domain model to a proprietary API.
- What got in the way
- Managed-service configuration, failover, connectivity, encryption, and production transaction behavior remained unassessed.
