generic pool

generic-pool.js

const genericPool = require("generic-pool");
const DbDriver = require("mysql");
 
/**
 * Step 1 - Create pool using a factory object
 */
const factory = {
  create: function() {
    return DbDriver.createConnection({
        host: '192.168.8.221',
        user: 'monty',
        password: 'some_pass',
        database: 'nodejs'
    });
  },
  destroy: function(client) {
    client.disconnect();
  }
};
 
const opts = {
  max: 10, // maximum size of the pool
  min: 2 // minimum size of the pool
};
 
const myPool = genericPool.createPool(factory, opts);

const resourcePromise = myPool.acquire();
 
resourcePromise
  .then(function(client) {
    client.query("select * from customer", [], function(err, data) {

        if(err) throw err;
        console.log("data===", data)
      // return object back to pool
      myPool.release(client);
      
    });
  })
  .catch(function(err) {
    // handle error - this is generally a timeout or maxWaitingClients
    // error
  });