SchoolCentral
A multi-tenant education ERP for schools that combines academic operations, payments, and role-based workflows in one platform.
Key Performance Metrics
Project Breakdown
The Problem
Schools needed a single platform to manage complex many-to-many relationships (students, classes, teachers) securely.
The Solution
Implemented a robust relational database model with strict foreign key constraints and cascaded updates.
Technical Challenge
Migrating 50+ schools from legacy SQL databases with zero downtime and data integrity verification.
Business Impact
Processed $2M+ in tuition payments. Reduced administrative overhead by 60% for partner schools.
Key Platform Features
System Architecture
Next.js App Router for server-side rendering and improved SEO. TypeScript for strict type safety.
Go (Golang) REST API for high-concurrency performance. Custom middleware for role-based access control (RBAC).
PostgreSQL with Row Level Security (RLS) to ensure tenant isolation. Complex relational schema for grading logic.
Infrastructure as Code using Terraform. Blue-green deployment strategy on AWS ECS.