Nodejs Postgresql

How to connect PostgreSQL with nodejs & it's connection pooling.
Alternatives To Nodejs Postgresql
Select To Compare


Connecting NodeJs & PostgreSQL

Learn how to connect PostgreSQL with NodeJs, While you are using PostgreSQL as database and NodeJs as backend, you need PostgreSQL database packages to connect with nodejs. There are various packages available but most popular and well documented is node-postgres pg. Let’s start.

What's needed

  • Make sure you have postgresql installed on machine and pgAdmin - postgresql management tool
  • Make sure you have node.js installed

Folder Structure

Within the download you'll find the following directories and files:

Connecting NodeJs & PostgreSQL
├──── app.js
├──── package.json
├── package-lock.json
├── .gitattributes
├── .gitignore

Database Connections - PostgreSQL

Create Database and use the credentials at connectionStrings.

const { Client } = require('pg');
var connectionString = "postgres://postgres:[email protected]:5432/database";

const client = new Client({
    connectionString: connectionString

Getting started

  • Download the project’s zip
  • Create table & insert some default value in PostgreSQL
	id int not null,
	name text not null,
	rollnumber int not null

INSERT INTO Employee values(1,'John',1001);

  • Type npm install in terminal/console in the source folder where package.json is located
  • Type node app.js in terminal/console in the source folder where app.js is located
  • server started on port 4000. (http://localhost:4000/) in default browser

Brief Documented

Documented on medium

Help on Executing Queries

Documented is available node-postgres(Doc) pg

Copyright and License

Copyright 2019 Connecting NodeJs & PostgreSQL, released under the MIT License.

Popular Data Storage Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.