Skip to content

CofQ

A full-stack exam prep platform for Ontario skilled tradespeople pursuing their Red Seal certification.

Next.js
Frontend
Supabase
Database
Stripe
Payments
2026
Year
CofQ — App landing page with magic-link sign-in interface

Turning scattered study materials into a modern certification platform

Ontario's skilled trades sector requires workers to pass rigorous Red Seal and Certificate of Qualification (CoQ) exams to legally practice their trade. Existing study resources were fragmented — outdated PDFs, disconnected practice sheets, and no way to track progress or identify weak areas.

Boolean Brew built CofQ from scratch: a trade-specific LMS where aspiring electricians, plumbers, and other tradespeople can purchase their exam prep course, work through practice questions at their own pace, and see exactly where they stand before exam day.

Industry
Skilled Trades Education
Platform
Web Application
Region
Ontario, Canada
Services
Full-Stack Development, UI/UX Design, Auth, Payments
Year
2026
The Challenge
  • No centralized, digital platform for CoQ exam practice in Ontario
  • Exam content varies by trade; a single platform needed to serve multiple categories
  • Users needed a secure, low-friction way to pay, sign in, and access content
  • Sensitive user data (email, progress) required strong privacy protections
The Solution
  • Trade-scoped course catalogue with per-trade pricing and Stripe checkout
  • Question-by-question progress tracking with explanations revealed post-answer
  • Magic-link + password auth, database-backed sessions with rolling expiry
  • AES-256-GCM encrypted email storage; answer correctness never sent to the client

Core platform features

Practice Exam Engine

Question-by-question exam flow with multiple-choice answers, instant feedback, and per-question explanations revealed after submission.

Progress Tracking

Per-user, per-course progress stored server-side. Users can see their completion percentage, resume where they left off, and identify weak spots.

Stripe Checkout

Per-trade course pricing with Stripe Checkout. Purchase verification is exclusively via signed webhooks — client success callbacks are never trusted.

Secure Auth

Auth.js v5 with magic link and password flows. Database-backed sessions, bcrypt password hashing, and single-use tokens that expire in 15 minutes.

Admin Dashboard

Role-gated admin panel for managing courses, questions, and users. Content updates are live instantly with no redeployment required.

Transactional Email

Resend-powered emails for magic links, purchase confirmations, and password resets. AES-256-GCM encrypted email storage in the database.

Platform walkthrough

Stack overview

Frontend
Next.js 14 TypeScript Tailwind CSS shadcn/ui
Backend
Next.js API Routes tRPC Prisma ORM
Infrastructure
Supabase PostgreSQL Vercel
Integrations
Auth.js v5 Stripe Resend

Built secure from day one

AES-256-GCM
Email encryption at rest
Bcrypt cost 12
Password hashing
15-min TTL
Magic link tokens

User emails are AES-256-GCM encrypted in the database with SHA-256 hashes used for lookups. Answer correctness is computed server-side only — clients never receive the raw flag in page payloads. Payment entitlements are verified exclusively via signed Stripe webhooks.

Course management without a redeployment

The admin panel lets content owners add and edit trade courses, manage question banks, and monitor user purchases — all without touching code. Role-gated via the database so admin access is never trust-from-client.

  • Create and publish new trade courses instantly
  • Add, edit, and reorder questions and answer choices
  • Manage user access and purchase history
CofQ — Admin dashboard showing user count, packages, revenue, and recent purchases

Building something similar?

Whether it's an LMS, a SaaS platform, or something more bespoke — we scope it, build it, and ship it in 6–10 weeks.