Amazon Aurora DSQL and Aurora PostgreSQL
Compare Aurora PostgreSQL and Aurora DSQL support for Fastah data types like IP addresses, subnets, and geolocation points.
Amazon Aurora PostgreSQL and Amazon Aurora DSQL are fully managed, PostgreSQL-compatible databases from AWS. They differ in data type and extension support—relevant when storing Fastah API responses.
Choose Aurora PostgreSQL if you need PostGIS for geospatial queries or cidr for subnet storage. Choose Aurora DSQL for serverless, distributed workloads where inet and timestamps suffice.
Supported data types
| Feature | Aurora PostgreSQL | Aurora DSQL |
|---|---|---|
IPv4/IPv6 addresses (inet) | ✅ | ✅ (docs) |
Subnet storage (cidr) | ✅ | ❌ |
| PostGIS extension | ✅ (docs) | ❌ (docs) |
| Timezone-aware timestamps | ✅ | ✅ (docs) |
Updated about 8 hours ago