Promise-based wrapper for node-postgres library designed for easy use with ES7 async/await.
$ npm install pg-client --save
Usage sample in a Node.js/Express web app:
import db from 'pg-client';
import { Router } from 'express';
import { connectionString } from '../config';
const router = new Router();
router.get('/users', (req, res, next) => {
db.connect(connectionString, async ({ query }) => {
const result = await query('SELECT id, email FROM users WHERE id = $1', 123);
if (result.rowCount) {
res.send(result.rows[0]);
} else {
res.sendStatus(404);
}
}).catch(next);
});
export default router;
- Membership Database — SQL database schema boilerplate for building web apps
- React Starter Kit — Isomorphic web app boilerplate
The MIT License © 2016 Kriasoft, LLC. All rights reserved. Made with ♥ by Konstantin Tarkus (@koistya) and contributors