azure-postgres-ts

原文涵盖的主题

• Azure PostgreSQL for TypeScript (node-postgres)
• Installation
• Environment Variables
• Authentication
• Option 1: Password Authentication
• Option 2: Microsoft Entra ID (Passwordless) - Recommended
• Core Workflows
• 1. Single Client Connection

Connect to Azure Database for PostgreSQL Flexible Server using the pg (node-postgres) package with support for password and Microsoft Entra ID (passwordless) authentication. For long-running applications, tokens expire and need refresh: | Setting | Value | Description | |---------|-------|-------------| | ssl.rejectUnauthorized | true | Always use SSL for Azure | | Default port | 5432 | Standard PostgreSQL port | | PgBouncer port | 6432 | Use when PgBouncer enabled | | Token scope | https://ossrdbms-aad.database.windows.net/.default | Entra ID token scope | | Token lifetime | 1 hour | Refresh before expiry | | Workload | max | idleTimeoutMillis | |----------|-------|---------------------| | Light (dev/test) | 5-10 | 30000 | | Medium (production) | 20-30 | 30000 | | Heavy (high concurrency) | 50-100 | 10000 | Note: Azure PostgreSQL has connection limits based on SKU. Check your tier's max connections. 1. Always use connection pools for production applications 2. Use parameterized queries - Never concatenate user input 3. Always close connections - Use try/finally or connection pools 4. Enable SSL - Required for Azure (ssl: { rejectUnauthorized: true }) 5. Handle token refresh - Entr

这里只展示节选，请以完整原文和当前要求为准。