node-pg-connection-pool

0.9.1 • Public • Published

npm version Build Status Coverage Status Dependency Status Gratipay donate button

node-pg-connection-pool See on Github

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

Run tests

sh test.sh

Contribute

Discover how you can contribute by heading on over to the CONTRIBUTING.md file.

Backers

Maintainers

These amazing people are maintaining this project:

Sponsors

No sponsors yet! Will you be the first?

Patreon donate button Gratipay donate button Flattr donate button

Click here to lend your support to: simple-node-redis-cache and make a donation at pledgie.com !

Contributors

These amazing people have contributed to/reviewed this project:

Discover how you can contribute by heading on over to the CONTRIBUTING.md file.


---

Package Sidebar

Install

npm i node-pg-connection-pool

Weekly Downloads

10

Version

0.9.1

License

MIT

Last publish

Collaborators

  • pasupulaphani