Scholara
A school management platform for Nepal, rebuilt from a single-school prototype into a multi-tenant SaaS. One platform for preschools, schools and colleges, with a web console for staff and a mobile app for parents.
| org_id | student | class | today |
|---|---|---|---|
| org_7f2 | Aarav S. | Casa B | Present |
| org_a91 | Mira K. | Grade 9 | Present |
| org_c3e | Nabin T. | BBA I | Late |
| org_7f2 | Sita R. | Toddler | Present |
| org_a91 | Ishan P. | Grade 7 | Absent |
| org_c3e | Rhea G. | BSc II | Present |
| org_7f2 | Kiran M. | Casa A | Present |
| org_a91 | Anya B. | Grade 10 | Present |
Shared infrastructure. Separate worlds.
Pooled multi-tenancy
Every table carries an org_id and Postgres row-level security isolates each school. The tenant rides in the JWT, so every policy is a single indexed check.
Web + mobile, one backend
A Next.js admin console and an Expo parent app share one typed Supabase backend.
Security-first
Hardened auth, no-store caching on private pages and shared-device-safe sign-out.
Built to scale
Search, filters and pagination on every list; aggregation happens in the database, never in the client.