December 2027
Intermediate
400 pages
1h 45m
English
Overview
Amazon Aurora DSQL: The Definitive Guide gives you the patterns, strategies, and production-tested techniques for building on AWS's serverless, multi-Region distributed SQL database. Written by Wendy L. Wise, who leads Aurora DSQL's control plane engineering team at AWS, this book offers firsthand insight into the opportunities engineers unlock when adopting DSQL. Its optimistic concurrency control, IAM-based authentication, and streamlined features set you free to rethink how you design resilient, scalable applications from the ground up.
Each chapter pairs real-world patterns with hands-on labs. You'll build applications that gracefully handle optimistic concurrency conflicts with retry logic and idempotency keys, implement the transactional outbox pattern cleanly without triggers, design tenant-isolated SaaS architectures, and configure dashboards in Python and TypeScript. You'll discover where CloudFormation and Terraform fit today, which PostgreSQL compatibility differences to plan for, and how to use the DSQL MCP server for AI-assisted database development.
- Understand how DSQL's architecture differs from traditional PostgreSQL and why it matters
- Design schemas and applications for multi-Region active-active environments
- Build applications that handle optimistic concurrency conflicts with retry logic and idempotency keys
- Build serverless applications with IAM authentication, the transactional outbox pattern, and observability
- Navigate IaC options and plan migrations from Aurora or RDS
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.