Edulinks.ng

Nigerian students needed a platform to ask and get answers to their pressing educational questions, serving as a knowledge base for the student community. The platform required Q&A functionality, group collaboration, moderation, and analytics to support a growing user base.

Deliver a full-stack platform with robust auth (OAuth + passkeys), role-based administration, and admin dashboards powered by PostgreSQL analytics to support the student community's knowledge-sharing needs.

I built a comprehensive Q&A platform with voting, tags, reputation, and accepted answers. I implemented group management with private/public groups, member roles, invitations, and group guidelines. I created user profiles with reputation tracking, activity feeds, and notification preferences. I built a moderation system with reporting, violation tracking, moderation queues, and audit logs. I delivered an admin dashboard with analytics for users, content, groups, moderation, and system metrics. I implemented multi-provider authentication (GitHub, Google, Facebook, Twitter OAuth plus WebAuthn/Passkeys) and an activity-driven notification system. I used Prisma with typedSql for type-safe SQL queries, fullTextSearchPostgres for search, and relationJoins for optimized queries across a complex relational schema.

This project demonstrated the importance of building features that serve real user needs first, then optimizing for scale. The combination of Q&A, groups, moderation, and analytics required careful data modeling to support complex relationships while maintaining query efficiency.