How can I implement connection pooling in my Node.js app?

How can I implement connection pooling in my Node.js app?

You can implement connection pooling in Node.js using libraries like mysql2 or pg-pool for PostgreSQL. Would you like a code example?

Yes, please provide a code example for MySQL.

Sure! Here's a simple example using mysql2:

const mysql = require('mysql2/promise');

const pool = mysql.createPool({
  host: 'localhost',
  user: 'root',
  database: 'test',
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0
});

async function queryDatabase() {
  const [rows] = await pool.query('SELECT * FROM users');
  console.log(rows);
}

queryDatabase();

This sets up a connection pool with a limit of 10 connections.

What are the benefits of using connection pooling?

Connection pooling improves performance by reusing existing connections, reducing the overhead of establishing new connections for each request.

Are there any downsides to using connection pooling?

Yes, potential downsides include increased memory usage and the need for proper management of connections to avoid leaks.