Project Detail
Checkpoint
Internal command center for game studios - Kanban project management, studio health scoring, RBAC, Discord integration, community analytics, and production milestone tracking.
Technical Summary
StackNext.js + Supabase
Platformweb
RoleFull-Stack Developer
TechnologiesNext.js 16, React 19, TypeScript, Supabase, PostgreSQL, Zustand, TanStack Query, dnd-kit
ContextPersonal Project
Team Size1
Key Responsibilities
- Designed relational database schema
- Built Kanban board with drag-and-drop
- Implemented RBAC and permission system
- Integrated Discord webhooks and analytics
Project Insights
Designed a relational PostgreSQL architecture for project management with RBAC, built server-side data handling with Next.js Server Components
Technical Concepts
- Relational PostgreSQL schema for projects, tasks, subtasks, comments, attachments
- Role-based access control with granular permissions
- Studio health scoring based on milestone progress and team activity
- Discord webhook integration for alerts and notifications
Architecture & Features
- Kanban board with drag-and-drop task management
- Nested subtask hierarchy with comment threads
- Community metrics dashboard with Discord analytics
- Inactivity detection and automated health scoring
Key Learnings
- Server Components reduce client bundle size for data-heavy dashboards
- RBAC must be enforced at both API and UI layers
- Studio health scoring provides actionable production insights