connection-pooling – ITFROMZERO

Odyssey: The Ultimate Solution to Save PostgreSQL from Bottlenecks at Scale

By admin September 17, 2026

Switch from PgBouncer to Odyssey to leverage multi-threaded power for PostgreSQL. A detailed guide on optimizing configurations to handle tens of thousands of concurrent connections in enterprise environments.

MySQL

Connecting MySQL in Node.js with mysql2: Connection Pooling, Prepared Statements, and Transactions

By admin July 9, 2026

A guide to connecting MySQL in Node.js with the mysql2 library the right way, avoiding the common mistakes junior developers make. Learn how to use Connection Pooling for performance optimization, Prepared Statements to block SQL Injection, and Transactions to ensure data integrity when operating across multiple tables simultaneously.

Database

Optimizing PostgreSQL Performance with PgBouncer: Connection Pooling in Production

By admin February 28, 2026

A guide to installing and configuring PgBouncer to address connection overhead in PostgreSQL. Real-world experience after 6 months in production: server connections reduced from 180 to 25, API response time improved from 800ms to under 300ms.