Repository files navigation

Learn how to create a Simple Crud Application by Connecting 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-postgrespg. Let’s start.

• Make sure you havepostgresql installed on machine andpgAdmin - postgresql management tool
• Make sure you havenode.js installed

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

NodeJs & PostgreSQL Crud Application.├── LICENSE├── README.md├── public│   ├── css│   │   └── main.css│   └── js│       └── main.js├── routes│├── customers.js│└── index.js├── views│   ├── customer│   │   ├── list.ejs│   │   ├── add.ejs│   │   └── edit.ejs│   ├── layouts│   │   ├── header.ejs│   │   └── footer.ejs│   └── inedx.ejs├── app.js└── package.json

Create Database and use the credentials atconnectionStrings.

const { Client } = require('pg');var connectionString = "postgres://postgres:postgres@localhost:5432/database";const client = new Client({    connectionString: connectionString});

• Download the project’s zip
• After Creating Database, Check your Connection Strings and Create new table in PostgreSQL

CREATE TABLE customer(    id serial NOT NULL,    name character varying(200) NOT NULL,    address text NOT NULL,    email character varying(200) NOT NULL,    phone character varying(20) NOT NULL)

• Typenpm install in terminal/console in the source folder wherepackage.json is located
• Typenode app.js in terminal/console in the source folder whereapp.js is located
• server started on port 4000. (http://localhost:4000/) in default browser

Documented is available node-postgres(Doc)pg

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