DevFlow
Issue tracker, built with AI tools
What a larger full-stack app looks like.
Backlog 2
To do 2
In progress 2
In review 1
Done 2
- MSAPI-3 · In progress → In review
- AKAPI-9 created
A simplified re-creation of the real app, running on sample data — try it.
What it does
DevFlow is an issue tracker for small software teams. A team creates a workspace with owner, admin and member roles, adds projects and sprints, and files issues — tasks or bugs with a priority, status, assignee and due date, numbered per project like API-1. Issues can be searched, filtered and sorted, moved across a Kanban board and discussed in comments, and an activity feed records what changed.
About the project
DevFlow is an AI-assisted exploration of a larger full-stack application: an issue and sprint tracker with a React client, an Express API, a PostgreSQL database, authentication, role-based permissions, tests and deployment. It was built with AI tools, and the stack is the project’s, not a claim of my own mastery.
How it fits together
A simplified view of the database schema. On every request the server reads the member’s role from the database before it touches a workspace’s data.
Project stack
React, TypeScript, React Router, TanStack Query, Node.js, Express, PostgreSQL, Prisma, Zod, Vitest, Docker, GitHub Actions
This is the project’s stack, not a list of my skills. Most of it is on my learning path; I can’t build with it on my own yet.
Details
- 01
Permissions are checked on the server
Roles are read from the database on every request. Hiding a button in the interface is treated as convenience, never as security.
- 02
Issue numbers that can’t collide
Each project keeps a counter. A new issue takes the next number inside a database transaction, and a unique index on project and number is the final guarantee.
- 03
The server decides the board order
When a card moves, the client only sends where it should go. The server reorders the columns in one transaction and returns the confirmed board.
What the project explores
This project explores how the parts of a full-stack app fit together — client, API, database, authentication, tests and deployment — and was built with AI assistance.
Limits
- No realtime updates, notifications or email.
- No password reset or email invitations; members must already have an account.
- There’s no shared demo account. You register your own to try it.
- The demo runs on Render’s free tier, so the first load after a quiet period is slow.