How do I manage database connections in Node.js?

How do I manage database connections in Node.js?

Managing database connections in Node.js typically involves using a connection pool. This allows you to reuse connections and improve performance. Would you like to see an example?

Yes, please provide an example of using a connection pool.

Here's a simple example using the mysql package:

const mysql = require('mysql');

const pool = mysql.createPool({
  connectionLimit: 10,
  host: 'localhost',
  user: 'yourUsername',
  password: 'yourPassword',
  database: 'yourDatabase'
});

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

What are the benefits of using a connection pool?

Using a connection pool helps manage multiple database connections efficiently, reduces the overhead of establishing connections, and improves application performance by reusing existing connections.