title	ExpressJS Prisma
description	An ExpressJS server that uses Prisma to connect to a PostgreSQL database
tags	express postgresql prisma typescript

ExpressJS Prisma Example

This is an ExpressJS REST API that uses Prisma to connect to a Postgres database and CRUD todos.

✨ Features

• Prisma
• Express
• Postgres
• TypeScript

💁‍♀️ How to use

• Install dependencies pnpm
• Provision a Postgres container on Railway
• Connect to your Railway project with railway link
• Migrate the database railway run pnpm migrate:dev
• Seed railway run pnpm prisma db seed
• Run the Server app railway run pnpm dev
• Prisma studio railway run pnpx prisma studio

📝 Notes

This is a simple REST API for todo items. The available routes are

• GET /todos gets all todos
• POST /todos creates a new using text in the JSON body
• GET /todos/:id gets a todo by id
• PUT /todos/:id updates a todo by id
• DELETE /todos/:id deletes a todo by id