azure-postgres-ts

What problem does it solve?

Provides clear, production-oriented guidance to connect Node.js and TypeScript applications to Azure Database for PostgreSQL Flexible Server, removing uncertainty around authentication, SSL, pooling, transactions, and token refresh. It helps teams avoid common pitfalls like disabled SSL, SQL injection, leaked connections, and expired Entra ID tokens.

Core Features & Use Cases

• Secure Authentication: Demonstrates both password-based and Microsoft Entra ID (passwordless) authentication flows and how to acquire and refresh tokens.
• Connection Management & Pooling: Shows recommended Pool configuration, explicit checkout/release patterns, graceful shutdown, and pool sizing guidance for different workloads.
• Safe Querying & Transactions: Emphasizes parameterized queries to prevent injection, transaction helpers with rollback semantics, typed TypeScript query results, and structured error handling.
• Use Case: Implement a backend service that uses Entra ID for passwordless connections, runs transactional order processing, and scales safely under connection limits.

Quick Start

Connect your Node.js TypeScript app to an Azure PostgreSQL Flexible Server using the node-postgres package and DefaultAzureCredential for passwordless authentication.