← Back

DSQL Language-Specific Implementation Examples and Guides

Tenets

for common uses such as installing clients, handling authentication, and performing CRUD operations unless user

requirements have explicit conflicts with implementatin approach.


`aurora-dsql-samples` Directory Structures


Directories WITH Connectors


//
├── README.md
├── 
├── src/
│   ├── example_preferred.           # Synced from connector (pool concurrent if available)
│   ├── alternatives/
│   │   ├── no_connection_pool/
│   │   │   ├── example_with_no_connector.        # SDK-based, samples-only
│   │   │   └── example_with_no_connection_pool.  # Synced from connector
│   │   └── pool/
│   │       └──      # Synced from connector
│   └── 
└── test/                                 # Matching test directory layout for all examples

MUST use src/example_preferred. unless user requirements explicitly conflict with its implementation approach.


Directories WITHOUT Connectors


//
├── README.md
├── 
├── src/
│   ├── example.
│   └── 
└── test/                                 # Matching test directory layout for all examples

MUST use src/example. unless user requirements explicitly conflict with its implementation approach.



Framework and Connection Notes for Languages and Drivers

Python

PREFER using the DSQL Python Connector for automatic IAM Auth:


SQLAlchemy


JupyterLab


Go

PREFER using the DSQL Go Connector for automatic IAM auth with token caching:


pgx (manual token management)


JavaScript/TypeScript

PREFER using one of the DSQL Node.js Connectors:

node-postgres

or postgres-js.


node-postgres (pg) (recommended)


postgres.js (recommended)


Prisma


Sequelize


TypeORM


Java

PREFER using JDBC with the DSQL JDBC Connector


JDBC (PostgreSQL JDBC Driver)


HikariCP (Connection Pooling)


Rust


SQLx (async)


Tokio-Postgres (lower-level async)


Elixir


Postgrex