pg-then

pg-then

• Use postgresql with promise api, based on pg.

Install

$ npm install pg
$ npm install pg-then

Usage

• Client pooling

const pg = require('pg-then')
 
const pool = pg.Pool('postgres://username:password@localhost/database')
 
pool
  .query('SELECT ...')
  .then(...)
  .catch(...)

• Use QueryStream

pg.Pool(config)
  .stream('SELECT ...')
  .on('data', data => ...)
  .on('end', () => ...)
  .on('error', err => ...)

• Client instance

const pg = require('pg-then')
 
const client = pg.Client('postgres://username:password@localhost/database')
 
client
  .query('SELECT ...')
  .then(...)
  .catch(...)
 
// ...
 
client.end()

License

MIT