node-pg-connection-pool

Simplistic node postgres connection pool ready can scale with generic-pool support

Prerequisites

node >= 4 This module requires nodejs v4 or above as it has dependencies on es6 components such as Map, Set, Promise etc.

Getting started

    npm install node-pg-connection-pool

Usage

Seemless execution of commands.

  var PgPool = require("node-pg-connection-pool");
  var pool = new PgPool();

  const result = await pool.query("SELECT $1::int AS number;", ["1"]);

Want postgres raw connection? you got it

  pool.acquire()
    .then(client => {

      // Do some work

      // At the end release the conn back to the pool
      pool.release(client)
    });

API

PgPool([options])

`options` object properties

Name	Type	Description
`name`	string	Name your pool
`pgOptions`	object	opts from node-postgres#client-parameters
`pgNative`	boolean	Use the native bindings. Install `pg-native` in your app before setting this to true.
`poolOptions`	object	opts from node-pool#createpool
`logger`	object	Inject your custom logger