Amazon Aurora DSQL has introduced support for foreign key constraints, allowing developers to enforce referential integrity directly within the database layer. The new feature includes options for immediate versus deferred enforcement and the ability to add constraints to existing tables. It also integrates with optimistic concurrency control to handle conflicts in distributed workloads.
- Enforce referential integrity natively in Aurora DSQL without application-level checks.
- Choose between immediate and deferred constraint enforcement based on transaction needs.
- Add foreign keys to existing tables to retrofit integrity into legacy schemas.
- Leverage optimistic concurrency control to resolve conflicts in distributed writes.