Simplistic node postgres connection pool ready can scale with generic-pool support
node >= 4
This module requires nodejs v4 or above as it has dependencies on es6 components such as Map, Set, Promise etc.
npm install node-pg-connection-pool
- 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)
});
- PgPool([options])
Name | Type | Description |
---|---|---|
name |
string |
Name your pool |
pgOptions |
object |
opts from node-postgres#client-parameters |
pgNative |
boolean |
Use the native bindings. Install |
poolOptions |
object |
opts from node-pool#createpool |
logger |
object |
Inject your custom logger |
sh test.sh
Discover how you can contribute by heading on over to the CONTRIBUTING.md
file.
These amazing people are maintaining this project:
No sponsors yet! Will you be the first?
These amazing people have contributed to/reviewed this project:
Discover how you can contribute by heading on over to the CONTRIBUTING.md
file.
<script>(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,document,'script','https://www.google-analytics.com/analytics.js','ga');ga('create', 'UA-57413413-7', 'auto');ga('send', 'pageview');</script> ---