Overview

The Node-Express-Sequelize-API Boilerplate is a simple boilerplate codebase designed to create APIs using Node.js Express framework and Sequelize with a PostgreSQL database. The boilerplate includes features like error handling middlewares, tests with coverage using mocha, ESDoc for documentation, and more.

Features

ES6 import/export with type "module"
Error handling middlewares
Tests setup with mocha configuration
Code coverage using c8
Eslint for linting
Winston logger for logging

Prerequisite

Install nodemon globally using the command:

npm install -g nodemon

Install PostgreSQL as the database.

Getting Started

Clone the repository:

git clone [repository-url]

Local Setup

Enter the cloned folder.
Install dependencies.
Create a file called .env and copy the contents from .env.example to .env.
Run the application locally.

Tests & Coverage

Run unit/integration tests.
Run tests with coverage.

Migrations

Running and undoing migrations.

Environment Variables

| Variable | Description | Default Value | | -------- | ---------------------- | ------------- | | DB_HOST | Database connection host | localhost | | DB_PORT | Database port | 5432 | | DB_NAME | Database name | postgres | | DB_USER | Database username | postgres | | DB_PASS | Database password | postgres |

Summary

The Node-Express-Sequelize-API Boilerplate is a comprehensive tool for building APIs using Node.js, Express, and Sequelize with a PostgreSQL database. From setting up the environment, handling migrations, running tests, to documenting the codebase, this boilerplate provides a structured foundation for API development. It encourages contributions and welcomes feedback to enhance the project further.

Chetanppatil

Node Pg Sequelize Boilerplate