LAUNCHED

APSU 16 — Alumni Member Portal

Member portal for St. Augustine's College Past Students Organisation (Year Group 16), live at apsu16.com.

Next.js 15TypeScriptSupabaseSupabase Edge FunctionsPaystackPWA

// problem

Business Problem

Alumni associations lack a centralised digital home — members have no easy way to stay connected, pay dues, track community projects, or access a directory of peers after leaving school.

// constraints

Constraints

OTP-only auth (no passwords) — email OTP via Supabase with magic link fallback
Must sync with GroupFund's financial data for live project progress
Progressive Web App support so members can install it on mobile

// architecture

Architecture

frontend

Next.js 15 App Router (migrated from Vite, May 2026) with CSS Modules; deployed to Vercel

backend

Supabase Edge Functions for member sync and invite flows; Next.js API routes for Paystack integration

database

Supabase PostgreSQL with RLS — verified_members, profiles, sessions; 201+ members onboarded

deployment

Live at apsu16.com on Vercel; Supabase for auth, DB, and storage

Scalability Strategy

Edge Functions for member sync keep verified_members enriched with occupation, house, class year, and location
Projects page pulls live GroupFund financial data — progress bars, collected/target, expenses
PWA manifest and iOS meta tags for home screen installation
Supabase Realtime ready for messages and push notifications

Security Decisions

OTP email login — no password storage; 2-step flow (email → OTP)
Server-side RPC gate verifies membership before granting portal access
Row Level Security on all Supabase tables
HMAC-SHA512 Paystack webhook verification for payment events

Target Outcomes

Live community portal at apsu16.com with 201+ verified members onboarded
Projects page wired to live GroupFund financial data with real-time progress
Streamlined invite flow with rich member data (house, class year, location, occupation)
PWA-ready with manifest, iOS meta tags, and home screen install support