Building Python applications with SQLAlchemy and Aurora DSQL

Connecting SQLAlchemy to Amazon Aurora DSQL requires three key adaptations: UUID primary keys, relationship() with foreign() annotations instead of ForeignKey() constraints, and AUTOCOMMIT engine mode to avoid unsupported SAVEPOINT operations. This tutorial walks through building a veterinary clinic CLI app that demonstrates these production-ready patterns, including IAM authentication via the Aurora DSQL Python Connector and OCC retry logic with exponential backoff.