passport-postgres-authentication

A little concept program with authentication using NodeJS with Passport, PostgreSQL, and ExpressJS. It contains login, registration, and password updating functionality.

Why?

I've built small applications with authentication using Passport with MongoDB, but not with Postgres. This gave me the opportunity to learn something new. Hopefully it can help someone else with their projects.

Getting Started

1. Clone the repository

git clone https://github.com/ad3m3r5/passport-postgres-authentication.git

2. Install necessary packages

npm install

3. Create your database and table in PostgreSQL. This is the statement I used.

CREATE TABLE users (
    id UUID NOT NULL,
    username TEXT NOT NULL UNIQUE,
    password TEXT NOT NULL,
    CONSTRAINT users_pkey PRIMARY KEY(id)
)
WITH (oids = false);

4. Create the file .env, which will store database connection information. Add the following variables using your respective values.

PGHOST=<postgres_host>
PGPORT=<postgres_port>
PGDATABASE=<database_name>
PGUSER=<postgres_username>
PGPASSWORD=<postgres_password>

5. Run the application

node server.js

Tech/Software Used

• NodeJS
• PostgreSQL
• VS Code

Main Packages Used

• ExpressJS
• EJS
• Passport
• node-postgres
• bcrypt.js

Screenshots

User login User registration Update/change account password