PostgreSQL, TypeScript, Node.js and Express.js Stack

Overview

This repo is a boilerplate project starter built with TypeScript for a PostgreSQL / Express.js / Node.js backend service. You can plug-in any other frontend library seamlessly.

Technologies Used

PostgreSQL - The World's Most Advanced Open Source Relational Database
Typescript - TypeScript extends JavaScript by adding types to the language
Node.js - Node.js® is a JavaScript runtime built on Chrome's V8 JavaScript engine.
Express.js - Express is a minimal and flexible Node.js web application framework that provides a robust set of features for web and mobile applications.
TypeORM - TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap, Ionic, React Native, NativeScript, Expo, and Electron platforms and can be used with TypeScript and JavaScript (ES5, ES6, ES7, ES8)

Highlights

Folders / Files Structure

Here is a high-level overview of our file structure.

src/
  __tests__/ # tests
  config/
  packages/
    api/ # API helpers, middlewares, resources, controllers, validations
    database/ # database helpers, models, database migrations
  index.ts
  server.ts
README.md
package.json, etc...

Environment Variables

# JWT
AUTH_TOKEN_EXPIRATION_TIME=""
AUTH_TOKEN_SECRET=""

# DATABASE
DB_HOST=""
DB_NAME=""
DB_PASSWORD=""
DB_PORT=""
DB_USERNAME=""
DB_MAIN_SCHEMA=""
DB_AUDIT_SCHEMA=""

# LOGGING
LOGGING_COMBINED_FILE=""
LOGGING_ERROR_FILE=""
LOGGING_LEVEL=""
LOGGING_TYPE=""

# SERVER
SERVER_PORT=""

Setup

Create a .env.local file on the root of the project based on .env.example
Create a dev app database. $ createdb <DB_NAME>;
Execute $ npm run setup:local
Start the development server running $ npm run dev

Running Tests

Create a .env.test file on the root of the project based on .env.example
Create a test app database. $ createdb <DB_NAME>;
Execute $ npm run setup:test
Run $ npm test

License

This project is an open-sourced software licensed under the MIT license.

knazran/notify-service