Skip to main content
JCR.DEV

01.2Case Plates

Steady

Guidance and counselling, confidential by design.

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

01 / 06Home page

screen 1 of 6: Home page

Visit live site(opens in a new tab)
Technical notes

Decisions

  1. 01Access in the databaseRow-level security scopes counsellors to departments and students to their own records.
  2. 02Checked writesEvery write is a server action that checks the role and validates the form.
  3. 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
Next: Fresco Grow Lab