ETLab+
A multi-tenant college laboratory management platform with role-based access control and database isolation.
01. Overview & Description
Built to eliminate paper-based lab sign-in sheets at Sahrdaya College of Engineering and give department heads real-time lab utilization analytics.
02. System Architecture Diagram
Next.js Client -> Node.js REST API -> PostgreSQL Row-Level Security
Click any node below to inspect its operational role in the pipeline.
Handles user prompt input, interval charts, SSE streaming data rendering, and dark-theme state management.
03. Database Schema & API Specifications
PostgreSQL database containing normalized tables for students, faculty, labs, schedules, and reservations linked via Foreign Key constraints.
- • POST /api/auth/login
- • GET /api/labs/attendance
- • POST /api/reservations
04. Codebase Folder Structure
etlab-plus/
├── server/
│ ├── src/routes/attendance.ts
│ ├── src/db/schema.sql (PostgreSQL RLS policies)
│ └── src/middleware/auth.ts
├── client/
│ └── app/dashboard/page.tsx
└── README.md05. Visual Evidence & Artifacts
$ etlab-plus --status active
[OK] System pipeline initialized
Real-time laboratory seat occupancy matrix
$ etlab-plus --status active
[OK] System pipeline initialized
Indexed query execution under 4ms for 10,000+ attendance logs
06. Engineering Challenges
07. Key Lessons Learned
Technologies Used
Explore Related Engineering Context
Recommended Projects, Articles & Credentials