What is database connection pooling in Node.js?

What is database connection pooling in Node.js?

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

Why is connection pooling important?

Connection pooling is important because it improves application performance by reusing existing connections, reducing latency, and minimizing resource consumption on the database server.

How do I implement connection pooling in Node.js?

You can implement connection pooling in Node.js using libraries like pg for PostgreSQL or mysql for MySQL. They provide built-in support for connection pooling.

Can you show me a code example?

Sure! Here's a simple example using the mysql library:

const mysql = require('mysql');
const pool = mysql.createPool({
  connectionLimit: 10,
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydb'
});

pool.getConnection((err, connection) => {
  if (err) throw err; // not connected!
  // Use the connection
  connection.query('SELECT * FROM users', (error, results) => {
    connection.release(); // release the connection back to the pool
    if (error) throw error;
    console.log(results);
  });
});