AWS Database Blog
Author: Rob Petersen
Rob Petersen is a Senior Technical Account Manager at AWS, bringing 20 years of IT industry experience to help customers accelerate their cloud adoption journey. Prior to joining AWS, Rob served as an infrastructure architect for a major quick-service restaurant corporation, where he played a pivotal role in their cloud transformation journey. His experience spans both leading large-scale cloud migrations and managing hybrid infrastructure operations, giving him unique insights into the challenges and opportunities organizations face during cloud adoption.
Amazon Aurora DSQL connections: Drivers, strings, and best practices
Connecting to Amazon Aurora DSQL requires a different approach than traditional PostgreSQL databases. Instead of long-lived passwords, you use short-lived IAM authentication tokens. Instead of static endpoints, you work with distributed cluster endpoints that route connections across Availability Zones. In this post, you learn how to configure connection strings, set up drivers in Python, Java, and Node.js, and implement best practices for authentication, connection pooling, and lifecycle management with Amazon Aurora DSQL.
DSQL SQL Dialect: How Amazon Aurora DSQL differs from single-instance PostgreSQL
This post is for database architects, developers, and DBAs who must evaluate Amazon Aurora DSQL or work with PostgreSQL workloads on a distributed database. Knowing exactly where Amazon Aurora DSQL aligns with standard PostgreSQL and where it diverges helps you to reduce risk and design schemas that perform well from day one. You might find that most existing PostgreSQL applications work with minimal changes.