The DSQL Book
AboutSubscribe

The DSQL Book

A book about building on Amazon Aurora DSQL, written in public, one chapter at a time, from production clusters.

Free. Unsubscribe any time with one click.

Every claim here is run against a live cluster or quoted from AWS documentation with the date. The chapters that are not written yet say so below, and they arrive in order as they are finished.

Subscribe and each chapter lands in your inbox when it is done. Nothing else is sent.

2 of 17 published

  1. Chapter 1A database that is not PostgreSQLNot yet written
  2. Chapter 2The Aurora DSQL constraints referenceEvery PostgreSQL feature Aurora DSQL refuses or changes, verified statement by statement against a live cluster in October 2026, with what to write instead and which refusals reach into your application code.
  3. Chapter 3Designing a schema you cannot tightenNot yet written
  4. Chapter 4Ids: uuids, sequences and the cache sizeNot yet written
  5. Chapter 5Indexes that build in the backgroundNot yet written
  6. Chapter 6Foreign keys, now that they existNot yet written
  7. Chapter 7Connections and IAM tokensAurora DSQL closes every connection after one hour and authenticates with a token that expires in fifteen minutes. How to write a pool that survives both, in a Lambda or anywhere else.
  8. Chapter 8The retry loopNot yet written
  9. Chapter 9Upserts and idempotencyNot yet written
  10. Chapter 10Bulk: three thousand rows at a timeNot yet written
  11. Chapter 11Migrations without a maintenance windowNot yet written
  12. Chapter 12What a query costsNot yet written
  13. Chapter 13Multi-regionNot yet written
  14. Chapter 14Backups, CDC and getting data outNot yet written
  15. Chapter 15Where search livesNot yet written
  16. Chapter 16Local development and testingNot yet written
  17. Chapter 17ToolingNot yet written

All posts, newest first