Backend Interview Exercise

A Fastify + PostgreSQL backend application for the interview exercise.

Setup

1. Install dependencies:

npm install

2. Start database

docker-compose up -d

2. Set up your database connection:

cp .env.example .env
# Edit .env with your database credentials

3. Run migrations:

npm run migrate

4. Start the development server:

npm run dev

The server will start on http://localhost:3000

Available Endpoints

Users

• GET /users/:id - Get a user by ID

Tasks

• GET /tasks - List all tasks
• GET /tasks/:id - Get a task by ID
• POST /tasks - Create a new task
• PATCH /tasks/:id - Update a task
• DELETE /tasks/:id - Delete a task

Database Schema

See src/db/migrations/001_initial.sql for the database schema.