REST API local development example using Typescript and Node.js with a Postgres database.

• Typescript
• Express
• Prisma
• Knex

docker-compose with two services:

• backend
• postgres

Build and start both services docker compose up -d

Initialize database docker compose exec backend pnpm db:up

Seed the database docker compose exec backend pnpm db:seed

Clean the database docker compose exec backend pnpm db:down

Stop both services docker compose down

Stop both services and delete volumes docker compose down -v

Rebuild backend service after changes docker compose build backend

Execute psql docker compose exec postgres psql -U postgres -h postgres -d webapp_dev

To run Prisma studio create a .env file. Because the Postgresinstance is running within docker we need to change the url we are using a little bit. The localhost alias will not work as it does in docker-compose.

DATABASE_URL=postgresql://postgres:postgres@localhost:5432/webapp_dev