What is connection pooling in Node.js?

What is connection pooling in Node.js?

Connection pooling in Node.js is a technique used to manage database connections efficiently by reusing existing connections.

Why is connection pooling important?

It's important because it reduces the overhead of establishing new connections, improving performance and resource utilization.

How do I implement connection pooling in my Node.js application?

You can implement it using libraries like mysql2 or pg for PostgreSQL, which provide built-in connection pooling features.

Can you show me a code example?

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);
}