React · TypeScript · Supabase · In Production

An entire institution, running on my code

The complete management system of Safina International, an educational institute in Multan: admissions, classes, billing, payroll, library, facilities, and ID cards. Designed, built, shipped, and operated end to end, solo.

Live portal View on GitHub Read the plain-language guide (PDF) Employment reference (PDF)

user roles, each with its own tailored interface

tables under trigger-written audit with before-and-after values - only the log itself and an internal counter sit outside it

ordered SQL migrations from prototype to production

What it does

Students sign in with an emailed code, no passwords anywhere, and see their day at a glance: classes, homework with online submission, an attendance donut, fees they can actually understand, and a digital student ID that doubles as a printable card. Teachers post and grade homework and take one-tap attendance. The office runs admissions through a three-step wizard, the accounts desk records cash against auto-generated invoices, and gym and daycare staff see exactly their members and no one else's.

Student dashboard — The student dashboard: the day at a glance.

Fees page — Fees built for one glance: what to pay now, what is coming.

Facility booking — First-come facility booking with capacity locking.

Session ticket — A session ticket, shown at the door.

The parts that were hard

Billing that matches real life. Tuition and subscriptions in advance, sessions in arrears, mid-month joins charged immediately and prorated to the day, one-time trials with month locks, automatic suspension for unpaid fees with a grace mechanism.
Money that cannot be silently edited. Financial records are append-only: corrections happen through recorded reversals and waivers, never deletion, and every change lands in a database-trigger audit log with before-and-after values.
Security with no server of my own. Authorization lives entirely in PostgreSQL row-level security and guarded functions; each of the seven roles reads exactly what it needs. The service-role key is never used.
Built for non-technical users, in two languages. Plain-language interfaces, printable branded PDFs, and parent handouts in English and Urdu.

The stack

Vite, React 18, and TypeScript with a hand-written design system, no UI libraries. Supabase (PostgreSQL) behind row-level security. Email OTP auth over the institute's own domain. Netlify hosting, pg_cron for nightly billing. Everything runs on free tiers, by design, for an institute that needed world-class software on a startup budget of zero.