- Year
- 2025
- Role
- Lead developer, team of five
- Stack
- Next.js and Supabase
Lighthouse, desktop, Oct 2026
- 97
- Performance
- 100
- Accessibility
- 100
- Best practices


01 / 06Home page
screen 1 of 6: Home page
Visit live site(opens in a new tab) Next: Fresco Grow Lab
Technical notes
Decisions
- 01Access in the databaseRow-level security scopes counsellors to departments and students to their own records.
- 02Checked writesEvery write is a server action that checks the role and validates the form.
- 03Token-swap themingSemantic tokens and shared components make the dark theme a token swap.
- Context
- Digitises a paper-based guidance workflow: record retrieval, in-person booking and announcements move to one platform. Counselling records are confidential, so each student’s data is isolated from other students and from uninvolved staff.
- Role
- Lead developer on a five-person team with Gerlie Campion, Francis Adrian Esteban, Jhey Gulde and Kathleen Grace Gultiano. Submitted as a project research paper, December 2025.
- Timeline
- 4 months.
- Approach
- Three roles with distinct areas. Students book, reschedule and cancel; counsellors accept, decline and complete requests and set working hours; admins manage accounts, content and the dashboard. Reads are plain functions shared by server components and query hooks. Every write is a server action that checks the role and validates against the form’s schema.
- Confidentiality
- Access control lives in the database. Row-level security on every table scopes counsellors to their departments and students to their own records. Guard triggers enforce own-booking cancellation, double-booking prevention and admin-only department changes. Notifications are created only by database triggers and delivered live over a websocket. A 29-check SQL suite runs as each role to verify the policies, alongside 73 unit tests in CI.
- Interface
- Built on a documented design system: semantic colour tokens, a fixed type scale and 17 shared components, so the dark theme is a token swap. Loading, empty and error states are visually distinct, and skeletons match each page’s layout. Contrast is verified by script on every colour change.
- Outcome
- Pitched to and approved by the school’s guidance office. Live at steady-system.jcrdev.me.
Full stack
- Next.js
- React
- TypeScript
- Supabase
- PostgreSQL
- Tailwind CSS
- shadcn/ui
- Radix UI
- TanStack Query
- Zod
- Cloudinary
- Vitest
- GitHub Actions
- Vercel