SOX
A task planner where the limits live in the database
SOX is our own product. It is a task planner for teams, and an example of the multi-user web apps we build for clients.
Role
Product design and development
Timeline
About 1 week of build time, in two stages
Stack
React, Vite, TypeScript, Supabase, Tailwind, Recharts, dnd-kit, Vitest
Industry
Productivity software
The Challenge
A planner has to hold many views of the same tasks and keep them correct for several people at once. It also has a free tier and a paid tier. If the paid limits only exist in the interface, anyone can skip them. We built SOX so the rules hold even when someone calls the database directly.
The Approach
Every table has row level security, and the free and paid limits are checked by the database itself, not only by the buttons on screen. Plan data such as who has Premium is kept in a table users can read but not change. Dependencies are checked for loops, and the critical path is calculated from them. Task notes are stored as limited rich text, so no HTML can be injected. We built the app in two stages: the core board first, then the advanced planning features. About 680 unit tests cover the calculations, and database tests run against a real database inside transactions that roll back.
What We Delivered
Board, grid, schedule, timeline and charts views of the same tasks
Timeline with dependencies, loop checks, critical path and baselines
Backlog with sprints, buckets and recurring tasks
Custom fields with colour rules, plus sorting, grouping, filtering, export and import
Estimated and logged hours per task, with hours per person and per week
Plan budgets, goals, portfolios and a roadmap across plans
Task chat with @mentions, reactions and notifications
Import from Excel and CSV, and export to both
Free and Premium limits enforced in the database
Row level security on all 32 tables, with a full audit of anonymous access
About 680 unit tests plus database tests that run against a real database
Inside the app
SOX is free to try. Sign up and open the app.
Open SOXReady to Start Your Project?
Tell us about your project and get a fixed quote within 2 working days. No commitment.