Orbit
Multi-tenant collaborative platform
Overview
Orbit is a collaborative task platform built for teams. Each organization gets isolated data — users can only see and modify resources within their org. I used tRPC for end-to-end type safety between the Next.js frontend and the API layer, Drizzle ORM for type-safe database queries, and implemented fractional indexing for the Kanban board to enable O(1) reordering without rewriting multiple database rows.
Tech Stack
Key Outcomes
Designed a multi-tenant PostgreSQL schema with organization-scoped RBAC and denormalized orgId for query performance.
Implemented tRPC procedures with middleware for end-to-end type safety, eliminating runtime type errors between client and server.
Built fractional indexing for Kanban board task reordering — O(1) position updates without rewriting adjacent rows.
Created an invitation system with secure org-scoped invite links and role assignment on join.