Role-Based Dashboards for Teachers, Students and Parents
One platform, three very different users: how the teacher, student and parent model behind Kilele Archade handles roles, row-level security and privacy.
Blog / System Architecture
System Architecture
Roles, row-level security, multi-tenancy and privacy boundaries — the structural decisions that are expensive to retrofit.
The architecture decisions that matter most are usually the ones about who can see what. A learning platform with students, teachers and parents, or a rental platform with owners, managers and tenants, both collapse into the same problem: many parties over one dataset, each entitled to a different slice of it.
My default is to put that enforcement in the database rather than in application code, attach roles to relationships instead of accounts, and let each audience get a different zoom level over the same events. It keeps a bug in one endpoint from becoming a data leak across the product.
Writing on system architecture (1)
Built in practice
Apex
A rental management and property automation platform simplifying property, tenant, payment, reporting, communication and operational workflows.
Kilele Archade
An AI-powered CBC-focused learning platform providing intelligent learning assistance, revision, assessments, educational resources and personalised learning.
Hire for this
Backend APIs & Integrations
REST APIs, third-party service integration, authentication and role-based access, payment and communication workflows built to stay maintainable.
Database & Data Platform Design
PostgreSQL-first data modelling: schemas, row-level security, migrations, and pgvector embeddings kept next to the relational data they describe.