Node.js Express, Sequelize & PostgreSQL: CRUD Rest APIs

For instruction, please visit:

Node.js CRUD Rest APIs with Express, Sequelize & PostgreSQL example

More Practice:

Node.js Express Pagination with PostgreSQL example

Node.js Express File Upload Rest API example

Node.js Express File Upload with Google Cloud Storage example

Security:

Node.js JWT Authentication & Authorization with PostgreSQL example

Associations:

Sequelize Associations: One-to-Many Relationship example

Sequelize Associations: Many-to-Many Relationship example

Fullstack:

Vue + Node.js + Express + PostgreSQL example

React + Node.js + Express + PostgreSQL example

Angular 8 + Node.js + Express + PostgreSQL example

Angular 10 + Node.js + Express + PostgreSQL example

Angular 11 + Node.js + Express + PostgreSQL example

Angular 12 + Node.js + Express + PostgreSQL example

Integration (run back-end & front-end on same server/port)

Integrate React with Node.js Restful Services

Integrate Angular with Node.js Restful Services

Integrate Vue with Node.js Restful Services

---

 

Project setup

npm install
createdb tutorials-db

Also, rename .env.example to .env and change its environment variable values. If not, it will use hard-coded default values:

# Backend port, changed if you need.
PORT=8080

# CORS origin URL, changed if you need.
CORS_ORIGIN=http://localhost:8081

# Database connection configuration
DB_HOST=<your DB_HOST; otherwise, localhost>
DB_USER=<your DB_USER; otherwise, postgres>
DB_USER_PASSWORD=<your DB_USER_PASSWORD; otherwise, empty>
DB_NAME=<your DB_NAME; otherwise, testdb>

---

 

Run

node server.js

---