AWS First Steps
New feature

Amazon Aurora DSQL now supports foreign key constraints

Amazon Aurora DSQL now allows adding foreign key constraints to new and existing tables, letting users define how referenced rows are handled when deleted or updated.

Amazon Aurora DSQL is a serverless, distributed SQL database with PostgreSQL compatibility and active-active multi-Region availability. It now supports adding foreign key constraints to both new and existing tables. Users can define application rules, such as ensuring a customer's primary address references an existing row in the address table. Aurora DSQL will then reject any write that would leave the customer pointing to an address that no longer exists. When a referenced row is deleted or updated, users can choose from options including NO ACTION, RESTRICT, CASCADE, SET NULL, and SET DEFAULT. This feature is available in all AWS Regions where Aurora DSQL is offered.

Why it matters

This update is useful for database users who need to ensure data integrity. Aurora DSQL provides a globally deployable relational database.

Read the original AWS announcement

Related articles and terms

Amazon AuroraA high-performance database compatible with MySQL and PostgreSQL, delivering up to 5x better throughputRelational Databases - Achieving High Availability with Amazon RDS and AuroraLearn how to build highly available relational databases using Amazon RDS and Aurora.Building Multi-Region Databases with DynamoDB Global Tables - Active-Active ReplicationAchieve low-latency reads and writes with multi-region active-active replication. Learn about conflict resolution mechanisms and DR design.Amazon RDSA fully managed service for operating major relational databases including MySQL, PostgreSQL, Oracle, and SQL Server in the cloudRunning Managed Databases with Amazon RDS - Multi-AZ and Read Replica DesignEnsure high availability with Multi-AZ and distribute read workloads with read replicas. This article introduces Blue/Green Deployments and RDS Proxy usage patterns.