eduVerse is a sophisticated, role-based e-learning platform engineered with modern web technologies: Next.js 16.2, React 19.2, and PostgreSQL. It delivers a seamless educational experience for Students, Instructors, and Administrators, featuring AI-powered tools, adaptive video streaming, and secure localized payments.
https://eduverse2026.vercel.app/
erDiagram
%% ========================
%% USER & ROLE SYSTEM
%% ========================
USER {
int user_id PK
string name
string email
string phone_no
datetime created_at
}
ROLE {
int role_id PK
string name
}
PERMISSION {
int perm_id PK
string name
}
USER ||--o{ USER_ROLE : has
ROLE ||--o{ USER_ROLE : assigned
ROLE ||--o{ ROLE_PERM : grants
PERMISSION ||--o{ ROLE_PERM : included
%% ========================
%% STUDENT & INSTRUCTOR
%% ========================
STUDENT {
int student_id PK
}
INSTRUCTOR {
int instructor_id PK
string bio
}
USER ||--|| STUDENT : "User_Std"
USER ||--o| INSTRUCTOR : "User_Inst"
%% ========================
%% COURSE STRUCTURE
%% ========================
COURSE {
int course_id PK
string title
string description
float price
}
SUBJECT {
int subject_id PK
string subject_name
}
MODULE {
int module_id PK
string title
string description
}
MATERIAL {
int material_id PK
string name
string url
}
MATERIAL_TYPE {
int type_id PK
string type_name
}
COURSE ||--o{ MODULE : has
COURSE ||--o{ SUBJECT : categorized
MODULE ||--o{ MATERIAL : contains
MATERIAL ||--o{ MATERIAL_TYPE : typed
INSTRUCTOR ||--o{ COURSE : instructs
%% ========================
%% ENROLLMENT & PAYMENT
%% ========================
ENROLLMENT {
int enrollment_id PK
date date
float progress
}
ORDER {
int order_id PK
datetime placed_at
}
PAYMENT {
int payment_id PK
float amount
string status
string method
datetime time
string transaction_id
}
STUDENT ||--o{ ENROLLMENT : enrolls
COURSE ||--o{ ENROLLMENT : contains
STUDENT ||--o{ ORDER : places
ORDER ||--|| PAYMENT : generates
ORDER ||--o{ COURSE : course_order
%% ========================
%% EXAM SYSTEM
%% ========================
EXAM {
int exam_id PK
string title
int marks
int duration
}
QUESTION {
int ques_id PK
string ques_statement
string options
string correct_ans
}
ATTEMPT {
int attempt_id PK
datetime time
float score
}
RESPONSE {
int response_id PK
string response_text
}
MODULE ||--o{ EXAM : has
EXAM ||--o{ QUESTION : contains
STUDENT ||--o{ ATTEMPT : makes
EXAM ||--o{ ATTEMPT : attempted
ATTEMPT ||--o{ RESPONSE : has
QUESTION ||--o{ RESPONSE : answered
%% ========================
%% REVIEW SYSTEM
%% ========================
REVIEW {
int review_id PK
int rating
string review_text
}
STUDENT ||--o{ REVIEW : writes
COURSE ||--o{ REVIEW : receives
%% ========================
%% COMMENT SYSTEM
%% ========================
COMMENT {
int comment_id PK
string comment_text
datetime time
}
REPLY {
int reply_id PK
}
USER ||--o{ COMMENT : writes
MODULE ||--o{ COMMENT : has
COMMENT ||--o{ REPLY : has
- 🤖 AI-Powered Intelligence:
- Auto Exam Builder: Instantly generate high-quality MCQ exams from any text prompt using Google Gemini.
- Intelligent Chatbot: A persistent AI assistant to help students and instructors navigate the platform and course content.
- 🛡️ Robust RBAC (Role-Based Access Control):
- Centralized security via
proxy.tsenforcing role-specific access for Students, Instructors, and Admins. - Dedicated authentication middleware for API and Page routes.
- Centralized security via
- 📽️ Adaptive Video Streaming:
- Integrated with Mux for buffer-free, adaptive bitrate playback.
- Automatic asset synchronization via Mux Webhooks.
- 💳 Secure Local Payments:
- Seamless integration with SSLCommerz for BDT transactions.
- Schema-first validation (Zod) for all payment gateway responses.
- 🎓 Comprehensive Learning Management:
- Full lifecycle management of Courses, Modules, and Materials.
- Support for diverse materials: Videos, PDFs, Slides, and external links.
- 👨🏫 Subject-Specialized Instructors: Instructors are assigned specific academic domains (Subjects), filtering their dashboard and course views to their area of expertise.
- 📊 Real-time Dashboard & Analytics: Dynamic stats for tracking student enrollment, exam attempts, and course performance metrics.
- ✨ Premium UX/UI Transitions: Specialized
PageTransitionProvider,HeroReveal, andScrollRevealcomponents powered by GSAP 3 and Framer Motion 12. - 🛡️ Secure Exams: Automated proctoring via DB-level constraints, ensuring students are enrolled before accessing exam sessions.
- 🌑 Dark Mode Architecture: Premium UI built with Tailwind CSS 4 and native dark mode support across every module.
- Framework: Next.js 16.2.1 (App Router & Server Actions)
- AI Integrations: Google Gemini Pro AI, Vercel AI SDK
- Streaming: Mux (HLS Adaptive Streaming)
- Payments: SSLCommerz (Sandbox & Live)
- Frontend: React 19.2.3, Tailwind CSS 4, shadcn/ui, Framer Motion 12, GSAP 3
- Database: PostgreSQL (Raw SQL via
pgpool — No ORM) - Storage: Supabase Storage for course materials (Videos, Thumbnails, PDFs)
- Authentication: Custom session management with HTTP-only cookies and cryptographic security.
- Validation: Zod for robust schema-first data integrity.
- Explore the course catalog with advanced price and rating filters.
- Secure enrollment and track learning progress dynamically (0-100%).
- Engage with an AI-powered personal tutor via real-time chat.
- Take interactive exams with instant grading and performance history.
- Subject Specialization: Mandatory subject assignment to focus content creation and analytics.
- Course Studio: Manage modules, upload materials (HLS Videos via Mux), and create rich course descriptions.
- AI Exam Builder: Generate diverse exams instantly via AI or build them manually using the MCQ editor.
- Analytics Hub: Track recent student activity, average scores, and individual course enrollment trends.
- Platform Governance: Full oversight of users, instructors, subjects, and platform-wide course catalog.
- System Metrics: High-level reporting on platform growth and user engagement.
- Administrative Setup: Controlled bootstrap mechanism for specialized roles.
app/ # App Router: Dashboards, Exams, Courses, and Auth
components/ # Premium, theme-aware UI components and GSAP animations
ui/ # Low-level primitives (Radix, HeroReveal, ScrollReveal)
top-loader.tsx # NavigationProgressBar for platform transitions
db/ # Database access layer organized by entity
schemas.ts # Central Zod validation repository
schema.psql # Raw SQL table definitions
lib/ # Core utilities: Mux, SSLCommerz, Session, and AI Logic
public/ # Static assets and media
migrations/ # Raw SQL migration scripts
proxy.ts # Central security gate and Middleware for RBAC enforcement
- Node.js 20+
- PostgreSQL instance (Supabase recommended)
- Mux Account (for Video)
- SSLCommerz Sandbox (for Payments)
Create a .env file in the root directory:
# Database & Storage
DATABASE_URL="postgresql://user:pass@host:5432/db"
NEXT_PUBLIC_SUPABASE_URL="https://your-proj.supabase.co"
SUPABASE_SERVICE_ROLE_KEY="your-service-role-key"
# Admin & Instructor setup secrets
ADMIN_SETUP_SECRET="your-admin-key"
INSTRUCTOR_SIGNUP_SECRET="your-instructor-key"
# AI & LLMs
GOOGLE_GENERATIVE_AI_API_KEY="your-gemini-key"
# Mux (Video Streaming)
MUX_TOKEN_ID="..."
MUX_TOKEN_SECRET="..."
MUX_WEBHOOK_SECRET="..."
# SSLCommerz (Payments)
SSLCOMMERZ_STORE_ID="..."
SSLCOMMERZ_STORE_PASSWORD="..."
NEXT_PUBLIC_BASE_URL="http://localhost:3000"# Install dependencies
npm install
# Initialize Database
# 1. Run /db/schema.psql and /db/analytics_functions.sql in your DB console
# 2. Run migrations in /migrations selectively
# Start Development Server
npm run devVisit http://localhost:3000 to explore the platform.
- Custom Auth: Direct session-to-DB mapping avoids third-party latency and keeps data sovereign.
- SQL Optimization: Parallel query execution using
pgPool and optimized PostgreSQL functions for analytics. - Cache Strategy: Extensive use of
unstable_cacheand Reactcacheto minimize database hits on read-heavy dashboards. - Streaming Webhooks: Reliable status synchronization between Mux and the local DB via signed webhooks.
Copyright © 2026 eduVerse. All rights reserved.