PG Sugar
A couple of methods to automate pooling with pg
.
Create sugar
var sugar = require('pg-sugar');
var s = sugar(pg, connectionString);
Create a client to perform a query
s.client(function (err, query) {
query('SELECT 1', [], function (err, results) {
// Do stuff
// Client is automatically returned to the pool
});
});
Create a transaction client to run transactions
s.transaction(function (err, client) {
client.query('SELECT 2', [], function (err, results, client) {
if (err) {
client.rollback(function () { console.log('LOSE!'); });
}
else {
client.commit(function () { console.log('WIN!'); });
}
});
});