BACKEND

Issue Tracker API

REST API for Tracking Git Issues

Overview

Strongly-typed REST API with PostgreSQL, JWT auth, RBAC, dynamic query filtering and a centralized error-handling architecture.

Challenges Faced

Designing a robust and scalable database schema for issues, comments, and role-based permissions was challenging. Implementing complex dynamic query filters (e.g., filtering by status, assignee, and tags simultaneously) required writing efficient SQL queries.

Future Plans

Build a modern frontend client (React/Next.js) to consume this API, and implement webhooks to integrate seamlessly with GitHub repositories for automated issue syncing.

Tech Stack

TypeScriptNode.jsExpressPostgreSQLJWT

Highlight

Typed API