/Javascript/Node.js/Nodejs postgresql local connection

Nodejs postgresql local connection

const pgp = require('pg-promise')(/* initialization options */);

const cn = {
    host: 'localhost', // server name or IP address;
    port: 5432,
    database: 'myDatabase',
    user: 'myUser',
    password: 'myPassword'
};

// alternative:
// var cn = 'postgres://username:password@host:port/database';

const db = pgp(cn); // database instance;

// select and return a single user name from id:
db.one('SELECT name FROM users WHERE id = $1', [123])
    .then(user => {
        console.log(user.name); // print user name;
    })
    .catch(error => {
        console.log(error); // print the error;
    });

// alternative - new ES7 syntax with 'await':
// await db.one('SELECT name FROM users WHERE id = $1', [123]);

Source: stackoverflow.com

Similar codes

0 vote173 views1 answer
Nodejs read file sent in the request without saving to file system
Javascript Node.js
2 votes167 views1 answer
Promise syntax in node js
Javascript Node.js
0 vote174 views1 answer
Cai nodejs ubuntu
Javascript Node.js
0 vote186 views1 answer
Common library for .net and node js for encryption
Javascript Node.js
0 vote184 views1 answer
Node mailer office 365
Javascript Node.js
0 vote168 views1 answer
Nodejs hpp github
Javascript Node.js
0 vote240 views2 answers
Express-rate-limit nodejs
Javascript Node.js
0 vote174 views1 answer
How to manage logging using winston for production and development in node js "github"
Javascript Node.js
0 vote188 views1 answer
Mongoose connection increase timeout in node js
Javascript Node.js
0 vote157 views1 answer
Node spawn bash catch errors
Javascript Node.js