AIILP: Academic Industry Internship Linkage Platform
A unified ecosystem that bridges Universities, Software Houses, and Applicants—replacing a fragmented internship market with real-time, role-based workflows.
Designing multi-tenant, role-based routing and strict data boundaries (RLS) while delivering realtime status, notifications, and high-throughput bulk onboarding without breaking integrity.
Students and guest applicants are trapped in a fragmented internship landscape with no centralized access to vetted industry roles, while software houses face administrative bottlenecks and universities lack end-to-end visibility. AIILP closes the linkage gap with a single, auditable platform.
type StudentRow = { regNo: string; email: string; department: string };
export function parseAndValidate(rows: StudentRow[]) {
const errors: Array<{ row: number; message: string }> = [];
const seenReg = new Set<string>();
const seenEmail = new Set<string>();
rows.forEach((r, idx) => {
if (!r.regNo?.trim()) errors.push({ row: idx + 1, message: "Missing regNo" });
if (!r.email?.includes("@")) errors.push({ row: idx + 1, message: "Invalid email" });
const reg = r.regNo.trim().toLowerCase();
const em = r.email.trim().toLowerCase();
if (seenReg.has(reg)) errors.push({ row: idx + 1, message: "Duplicate regNo" });
if (seenEmail.has(em)) errors.push({ row: idx + 1, message: "Duplicate email" });
seenReg.add(reg);
seenEmail.add(em);
});
if (errors.length) return { ok: false as const, errors };
// Bulk insert runs behind RLS policies and admin-only routes.
return { ok: true as const, count: rows.length };
}A role-based ecosystem: Student/Guest Hub for applications, University Command for onboarding and oversight, Software House Portal for lifecycle management, and an Admin Command Center for vetting and auditability—backed by Supabase Auth, Postgres RLS, and Realtime notifications.
Used Supabase Auth + Postgres with fine-grained Row Level Security (RLS) and Realtime channels so every role sees the right data at the right time, with immutable audit logs for administrative actions.
Converted internship operations into a predictable pipeline: faster bulk onboarding, transparent application lifecycles, and executive-level monitoring across universities and industry partners.
- Supabase Realtime channels for live notifications across roles
- Scalable architecture designed for 1,000+ concurrent read operations