DevPulse — Issue Tracker API

DevPulse is an internal tech-issue and feature tracker built for engineering teams. It's a TypeScript + Express REST API backed by PostgreSQL (hosted on Neon), talking to the database with raw SQL tagged-template queries instead of an ORM. Contributors can create, view, and update their own issues, while maintainers get full control — updating any issue, changing status, or deleting reports. Every issue moves through an open → in_progress → resolved workflow, and the API supports filtering by status and type plus sorting by creation date. Auth is handled with JWT and bcrypt-hashed passwords, and every request is logged to file for traceability.

Skipping an ORM in favor of raw SQL meant hand-writing every query and keeping the schema, types, and migrations in sync manually. The trickier part was enforcing role-based rules — contributors editing only their own issues, maintainers editing anything — correctly at the service layer, since the database itself has no concept of ownership rules beyond a foreign key.

Add pagination and full-text search across issues, email notifications when an issue's status changes, and a lightweight maintainer dashboard for bulk-triaging open reports.