🛡️ RLS Guard Dog

Secure Classroom Management with Row-Level Security

LoginSign Up
👨‍🎓

Student Dashboard

Students can view only their own progress records with automatic RLS filtering

👨‍🏫

Teacher Management

Teachers manage students in their grade/subjects and edit progress records

👩‍💼

School Analytics

Head teachers access school-wide analytics with MongoDB integration

Built With

⚡

Next.js 15

App Router + TypeScript

🔐

Supabase

PostgreSQL + RLS

📊

MongoDB

Analytics Storage

🚀

Edge Functions

Serverless Computing

📋 Assignment Requirements

✅ Database & Security:

  • Classroom and progress tables linked by school_id
  • Row-level security policies implemented
  • Students see only their own records
  • Teachers see students in their classes
  • Head teachers see all school records

✅ Features & Integration:

  • Protected /teacher page for editing progress
  • Role-based authentication system
  • Edge Function calculates class averages
  • MongoDB integration for analytics
  • Comprehensive testing and deployment