pg-query

Run queries with node-postgres with less boilerplate. node-posgres is low level by design and rather verbose.

This is a simple abstraction I've spun into a module after implementing something like this in most of my projects.

install

npm install pg-query

use

var query =require('pg-query');

query('SELECT NOW()',function(err,rows,result){

assert.equal(rows,result.rows);

});

Notice the callback is called with 3 parameters.
First the error argument.
Next the rows returned by the query.
Finally the full result object which contains the same reference to the rows at result.rows

query.first does a bit of argument type checking. If you pass an array as the values argument it is passed to the query unchanged. If you pass anything else truthy it is wrapped inside an array. This makes query.first easier to compose and use.

comments

pg-query is domain aware so your callback will always be called in the correct domain.
If you're not using domains it will gracefully ignore them.

pg-query uses whichever version of node-postgres you have installed in your project.

pg-query uses a random pooled database client for each query.
If you're using a transaction (eg BEGIN/COMMIT) you need to check out a client from the pool manually.
Repeat: DO NOT USE THIS FOR RUNNING TRANSACTIONS