VIT.alumni

VIT.alumni is a university-owned platform that connects students with alumni through a moderated anonymous Q&A board. This repository contains the MVP forum implementation built with Next.js, tRPC, Prisma, and Supabase.

What Works

• Student registration and login
• Student onboarding and anonymous name selection
• Alumni registration and profile setup
• Student question submission
• Moderator approval and rejection flow
• Public approved questions board
• Alumni answers on approved questions

Stack

• Next.js 14 App Router
• TypeScript
• tRPC v11
• Prisma
• Supabase Auth + Postgres
• Tailwind CSS + shadcn/ui

Local Setup

1. Create .env.local with:

DATABASE_URL=
DIRECT_URL=
NEXT_PUBLIC_SUPABASE_URL=
NEXT_PUBLIC_SUPABASE_ANON_KEY=
SUPABASE_SERVICE_ROLE_KEY=

2. Install dependencies if needed:

pnpm install

3. Run Prisma migration and generate the client:

npx prisma migrate dev --name init
npx prisma generate

4. Start the app:

pnpm dev

5. Open http://localhost:3000.

Main Routes

• / public approved questions board
• /login sign in
• /register sign up
• /student/dashboard
• /student/ask
• /student/setup
• /student/choose-name
• /alumni/dashboard
• /alumni/questions
• /alumni/setup
• /moderator/queue

Notes

• Moderator users must be promoted manually in the database.
• Local development depends on valid Supabase and Postgres credentials.