What is database connection pooling in Node.js?

What is database connection pooling in Node.js?

Database connection pooling in Node.js is a technique used to manage database connections efficiently. It allows multiple requests to share a limited number of database connections, reducing the overhead of establishing new connections for each request.

Why is connection pooling important?

Connection pooling is important because it improves application performance by reducing latency and resource consumption. It allows for faster response times and better scalability, especially under high load.

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

You can implement connection pooling in Node.js using libraries like mysql2 or pg for PostgreSQL. These libraries provide built-in support for connection pooling, allowing you to configure the pool size and manage connections easily.

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, fields] = await pool.query('SELECT * FROM users');
  console.log(rows);
}