Boilerplate for express, postgresql, prisma and typescript

This boilerplate follows clean architecture with SOLID principles. This sample define a simple user schema and handle two endpoints that allows users to create new accounts and login by them. There is also a middleware to validate JWT tokens that are provided by clients with Bearer authorization header.

Technologies

• Environment: Nodejs
• Language: Typescript
• Framework: Expressjs
• ORM: Prisma
• Database: Postgresql
• Authentication: Basic, JWT
• Inversion Of Control (D in SOLID): Awillix
• Password hash library: bcryptjs

Prequisite

• Create the .env file by copying the .env.example file
• Database:
  • The easy way to have a Postgresql server is using docker or you can use Postgreql cloud
  • Once you have the database connection URL, replace the sample one in the .env file by yours
• Install dependencies

npm install

• Initialize database schema

npx prisma migrate dev --name "init" --preview-feature
npx prisma db push --preview-feature

Docker build

docker build -t app-name .

NPM scripts

1. Run dev

npm run dev

2. Linting

npm run lint

3. Build

npm run build

4. Run production

npm run start