Optimistic concurrency is the whole design: event sourcing on Aurora DSQL - DEV Community
How an incident-command record built on Amazon Aurora DSQL stays consistent under cross-region contention, and why the property that lets the database survive a region loss is the same one that keeps the record from forking.