How does connection pooling work in Node.js?

How does connection pooling work in Node.js?

Connection pooling in Node.js allows multiple database connections to be reused, improving performance and resource management.

What are the benefits of using connection pooling?

The benefits include reduced latency, efficient resource usage, and improved application scalability.

Can you show me an example of implementing connection pooling?

Sure! You can use libraries like mysql2 or pg for PostgreSQL. Here's a basic 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, fields] = await pool.query('SELECT * FROM users');
  console.log(rows);
}

What happens if all connections in the pool are in use?

If all connections are in use, new requests will wait until a connection is released back to the pool, up to the queueLimit.