Campus Exchange is a full‑stack web application that enables students to list, lend, sell, and borrow academic resources (textbooks, lab kits, stationery, notes) within a campus network. The platform delivers secure authentication, transaction workflows, and realtime messaging backed by a normalized PostgreSQL schema and cloud storage. It is built for production deployment on Vercel with Supabase as the backend platform.
The app connects students as owners and requesters to streamline peer‑to‑peer exchanges with transparency and auditability.
- Secure account system with Supabase Auth and protected dashboard
- Resource listings with images, categories, pricing/type, and availability
- Transaction workflow with owner actions (Accept/Reject) and automatic inventory state updates
- Realtime, transaction‑scoped messaging using Supabase Realtime
- Activity logging (activity_log) to capture key user actions
- Responsive dashboard UI with collapsible sidebar and consistent layouts
- Application: https://campus-exchange-zghc.vercel.app/
- Requirements and UX flows for listing, messaging, and transactions
- Database schema design (6 tables) and storage buckets
- Authentication integration and route protection
- Resource CRUD with image uploads and category taxonomy
- Transaction lifecycle with availability sync and activity logs
- Realtime messaging UI with scroll‑synced panes
- Vercel deployment with environment‑driven configuration
- Frontend: Next.js (App Router), React, Tailwind CSS, shadcn/ui
- Server: Next.js server components and route handlers
- Backend: Supabase (Auth, PostgreSQL, Storage, Realtime)
- Infra: Vercel hosting and CDN
High‑level flow:
- Users sign in via Supabase Auth
- Owners create resources with images and availability
- Requesters initiate transactions; owners Accept/Reject
- On Accept, the linked resource availability_status → “unavailable”
- Parties chat in realtime within the transaction thread
Architecture diagram :
Tables (Supabase PostgreSQL):
- users
- resources
- categories
- transactions
- messages
- Authentication: email/password with persistent sessions
- Resources: create/edit/delete, upload images to Storage, assign categories, manage availability
- Transactions: requester → owner flow, Accept/Reject, automatic availability updates
- Messages: realtime chat per transaction with scrollable conversation and fixed input
- Dashboard: sidebar navigation, overview metrics, recent activity
Built using Next.js and Supabase. Thanks to the Supabase and shadcn communities for excellent tooling and documentation.