Amazon Aurora DSQL cluster connectivity tools
Aurora DSQL is compatible with many third-party database drivers and ORM libraries. AWS provides two types of tools to simplify working with Aurora DSQL:
-
Connectors – Authentication plugins that extend database drivers to handle IAM token generation automatically. Use connectors when working directly with database drivers.
-
Adapters and dialects – Extensions for specific ORM frameworks that provide IAM authentication and improved Aurora DSQL compatibility. Use adapters when working with a supported ORM framework.
Aurora DSQL adapters and dialects
The following table shows the available adapters and dialects for Aurora DSQL. Each repository is available on the GitHub website.
| Programming language | ORM/Framework | Repository link |
|---|---|---|
| Java | Hibernate | aurora-dsql-orms/java/hibernate |
| Python | Django | aurora-dsql-orms/python/django |
| Python | SQLAlchemy | aurora-dsql-orms/python/sqlalchemy |
| Python | Tortoise ORM | aurora-dsql-orms/python/tortoise-orm |
| TypeScript | Drizzle ORM | aurora-dsql-orms/node/drizzle |
Database driver samples
The following table shows sample code for connecting to Aurora DSQL using third-party database drivers. Each sample repository is available on the GitHub website.
| Programming language | Driver | Sample repository link |
|---|---|---|
| C++ | libpq | aurora-dsql-samples/cpp/libpq |
| C# (.NET) | Npgsql | aurora-dsql-samples/dotnet/npgsql |
| Go | pgx | aurora-dsql-samples/go/pgx |
| Java | HikariCP + pgJDBC | aurora-dsql-samples/java/pgjdbc |
| JavaScript | node-postgres (AWS Lambda) | aurora-dsql-samples/lambda |
| JavaScript | node-postgres | aurora-dsql-samples/javascript/node-postgres |
| JavaScript | Postgres.js | aurora-dsql-samples/javascript/postgres-js |
| Python | asyncpg | aurora-dsql-samples/python/asyncpg |
| Python | Psycopg | aurora-dsql-samples/python/psycopg |
| Python | Psycopg2 | aurora-dsql-samples/python/psycopg2 |
| Ruby | pg | aurora-dsql-samples/ruby/ruby-pg |
| Rust | SQLx | aurora-dsql-samples/rust/sqlx |
ORM and framework samples
The following table shows sample code for using third-party ORM libraries and frameworks with Aurora DSQL. Each sample repository is available on the GitHub website.
| Programming language | ORM/Framework | Sample repository link |
|---|---|---|
| Java | Hibernate | aurora-dsql-orms/java/hibernate/examples/pet-clinic-app |
| Java | Liquibase | aurora-dsql-samples/java/liquibase |
| Java | Spring Boot | aurora-dsql-samples/java/spring_boot |
| Python | Django | aurora-dsql-orms/python/django/examples/pet-clinic-app |
| Python | SQLAlchemy | aurora-dsql-orms/python/sqlalchemy/examples/pet-clinic-app |
| Python | Tortoise ORM | aurora-dsql-orms/python/tortoise-orm/example |
| Ruby | Rails | aurora-dsql-samples/ruby/rails |
| TypeScript | Drizzle ORM | aurora-dsql-orms/node/drizzle/examples/veterinary-app |
| TypeScript | Prisma | aurora-dsql-samples/typescript/prisma-multi-region |
| TypeScript | Sequelize | aurora-dsql-samples/typescript/sequelize |
| TypeScript | TypeORM | aurora-dsql-samples/typescript/type-orm |
