Byway LMS
Course marketplace with instructor, student and operations dashboards
Role: Full-stack: schema, triggers, RLS and UI
- routes
- 27
- RLS-protected tables
- 12
- role dashboards
- 3
Overview
Byway is a course marketplace and learning platform. Instructors publish courses made of modules and lessons, learners browse a public catalog, enroll, work through the curriculum, and receive a certificate when they finish. Platform staff moderate the catalog, the reviews and the user base from a separate operations dashboard.
There is no API server. Pages query Postgres directly through Supabase, and Row Level Security decides what each caller can see and change, which means authorization lives in the database, not in the application code.
The student dashboard resolves the actual next unwatched lesson, so "continue learning" points at a specific lesson rather than a course page. The instructor dashboard carries enrollment trends, per-course completion rates and an enrolled-to-completed funnel. The admin surface adds twelve-month platform charts and review moderation.
The screens
15Platform operations dashboard with enrolment and revenue charts
Captured from the running system. Records shown are demonstration data.
The interesting part
Progress is computed by the database, not the client.
Recording a lesson completion fires a Postgres trigger that recomputes enrollment progress, and crossing 100 percent issues the certificate automatically. No client can get this wrong, no background job has to catch up, and two tabs open at once cannot disagree. The design language follows the same idea: a four-stop colour ramp where a thing's position on the ramp *is* its progress, with the number and the fill length always saying the same thing so nothing is lost to colour blindness.
What it does
- Public catalog with search, category filtering and course detail pages
- Student dashboard: enrollments, next-lesson resolution, cart, wishlist, certificates, reviews
- Instructor dashboard: course builder, status transitions, enrollment trends, rating distribution
- Admin dashboard: platform counters, twelve-month charts, review and user moderation
- Certificates issued by trigger and exportable to image
- Light and dark themes applied before first paint, with no flash
- Tailwind v4 configured entirely in CSS via @theme
Built with
- Framework
- Next.js 16
- React 19
- App Router
- Turbopack
- Language
- TypeScript (strict)
- UI
- Tailwind v4
- Motion
- Recharts
- react-hot-toast
- Data
- Supabase
- PostgreSQL 17
- @supabase/ssr
- Forms
- React Hook Form
- Zod
- Backend
- Row Level Security
- Postgres triggers
Next project
Alpenglow Retreat
Booking site and staff operations dashboard on one database