Thanks in part to:

• Getting Started on Heroku with Node.js
• Seans-TypeScript-NodeJS-CRUD-REST-API-Boilerplate
• Express ES2017 REST API Boilerplate
• Node Postgres
• Postgres migrate
• Postgres migrate

brew tap mongodb/brew
brew install mongodb-community

brew install postgres
brew services start postgresql
brew services start postgres

Now you should put your DB connection string to DATABASE_URL environment variable and run npm run migrate up.

psql postgres

\c boilerplate

CREATE DATABASE boilerplate;
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

DATABASE_URL=postgres://`{whoami}`:test@localhost:5432/boilerplate yarn run migrate up

Create a new migration. From here

yarn run migrate create customer table init

• move migrations to .ts, and use data models
• tie data models to swagger defs
• add auth for customers
• password table for customers
• swagger-jsdoc
• add abstract class for types, for loading to data store
• map pg functions to Contractor/Customer classes