SQL DB
A managed relational database with ACID transactions and a structured schema queried via SQL.
Description
Managed relational databases (AWS RDS/Aurora, GCP Cloud SQL, Azure SQL) all run ACID-compliant SQL engines with managed backups, replicas, and point-in-time recovery. The largest difference is the engine: Cloud SQL and RDS host open-source engines (PostgreSQL, MySQL, and others), Azure SQL centres on a managed SQL Server, and cloud-native options like Aurora reimplement the storage layer for higher scale and faster failover. They also differ in how read replicas, high-availability, and serverless/auto-scaling modes are packaged. To the best of our knowledge the relational guarantees are comparable; the choice mainly follows the engine and HA model you need.
Capabilities
- Relational schema with joins and constraints
- ACID transactions
- Managed backups and replicas
- Point-in-time recovery