1.0.0 • Published 6 years ago
pg-managed-pool v1.0.0
pg-managed-pool
A really small library for making your postgres pool connections easier by handling the connection and release of the client for you. Works well with async functions.
Install it:
npm install pg pg-managed-pool
Use it:
const managedPool = require('pg-managed-pool');
const connect = managedPool({ /* connection details */ });
connect(async client => {
const result = await client.query('SELECT * FROM whatever');
console.log(result.rows);
// Whether or not your query throws, the client will be released back to the pool
// at the end of this function. Then you can handle errors any way you like.
}).then(/* handle errors */);
If you want access to the pool object, you can create your own pool and pass it in instead of the connection object, or you can add a function as the second argument that accepts the pool object:
const { Pool } = require('pg');
const managedPool = require('pg-managed-pool');
const pool = new Pool({ /* connection details */});
pool.on('error', () => /* do stuff */);
const connect = managedPool(pool);
// ...OR...
const connect2 = managedPool(
{ /* connection details */ },
pool => pool.on('error', () => /* do stuff */);
);
1.0.0
6 years ago