How To Build a RESTful API with TypeScript, Node.js, Express, Prisma, and PostgreSQL

March 18, 2022
TypeScript - Express - Prisma - PostgreSQL

WARNING: This post is over a year old. Some of the information this contains may be outdated.

Prerequisites

• Node.js v10 to v14 is installed on your computer.
• PostgreSQL v13 is running which can easily set up with Docker as demonstrated here.

Content

Step 1 — Creating Your TypeScript Project

Step 2 — Setting Up Prisma with PostgreSQL

Step 3 — Defining Your Data Model and Creating Database Tables

Step 4 — Exploring Prisma Client Queries in a Plain Script

Step 5 — Implementing Your First REST API Route

Step 6 — Implementing 3 layers architecture

Step 7 — Deploy to cloud service