Meet AWS’s newest serverless DB: Aurora DSQL

AWS re:Invent is happening this week, and wow, do they have some bombshell announcements. One of the most exciting ones, in my opinion, is the introduction of a serverless SQL-based database. Some key features include:
- Autoscaling horizontally, not just vertically.
- Multi-region availability baked right in.
- Partial PostgreSQL compatibility.
There are a few limitations you might not expect:
- It’s currently not MySQL-compatible.
- Due to its native horizontal scalability, several PostgreSQL features that limit scaling have been removed, including triggers, views, foreign key constraints, and more.
It almost sounds too good to be true—as long as you can design with its limitations in mind. I’m hoping to find some time to experiment with it soon, but first, I need to wrap up the video course I’m working on. More updates on that coming soon...