Task Manager API

A RESTful backend API for managing projects and tasks built with Node.js, Express, and PostgreSQL.

Features

• CRUD operations for tasks
• CRUD operations for projects
• PostgreSQL relational database
• Controller and route architecture
• Input validation
• Seed data support

Tech Stack

• Node.js
• Express.js
• PostgreSQL
• pg
• dotenv

API Endpoints

Tasks GET /tasks POST /tasks PUT /tasks/:id DELETE /tasks/:id

Projects GET /projects POST /projects PUT /projects/:id DELETE /projects/:id GET /projects/:id/tasks

Installation

npm install

Environment Variables

Create a .env file:

DB_USER= DB_HOST= DB_NAME= DB_PASSWORD= DB_PORT=

Run Server

node server.js

Database Setup

Run schema.sql to create tables.

Run seed.js to populate sample data.