TS
Back to Projects

GDG@PSU Website

Complete digital ecosystem for Google Developer Groups at Penn State - member management, events, email system, blog, analytics, and admin panel

ReactTypeScriptTailwind CSSSupabaseViteVercelPostgreSQLResend
View on GitHub

The Problem

GDG@PSU needed more than just a website - we needed a complete digital ecosystem to manage a growing tech community. Generic website builders couldn't handle member registration, event management, email campaigns, analytics, and content management all in one place.

The Approach

Built a production-grade platform from scratch over 2 months with 100+ commits:

Core Features:

  • Modern UI/UX with dark/light themes and responsive design
  • Complete member management with registration, profiles, and role-based access control
  • Event management system with registration, tracking, and calendar integration
  • Professional email system for newsletters, event notifications, and bulk communications
  • Full-featured blog with markdown support and engagement tracking
  • Custom Linktree integration for social media links

Admin Panel:

  • Comprehensive dashboard with real-time analytics
  • User and member management with role assignments
  • Event creation and management tools
  • Communication hub for email campaigns
  • Content management system
  • Security audit logging

Technical Excellence:

  • Auto-deploys to Vercel with global CDN
  • Serverless functions for email and API endpoints
  • Supabase for PostgreSQL database, auth, and storage
  • PWA support for mobile installation
  • Enterprise-grade security with audit logging
  • Optimized performance with caching and real-time updates

The Impact

Helped grow GDG@PSU chapter from 0 to 10+ members in the first month. Serves as the central hub for all chapter communications, event registrations, member engagement, and content distribution. Production-ready platform handling real users and events.

Build Notes

Database Schema:

  • Core Tables: profiles, members, roles
  • Content Management: blog_posts, pages, media
  • Communication: newsletters, email_logs, subscribers
  • Events: events, registrations, attendance
  • Admin: audit_logs, settings, permissions
  • Linktree: links, link_clicks, social_profiles

Key Technical Decisions:

  • Supabase for real-time subscriptions and row-level security
  • Vercel for edge deployment and serverless functions
  • Resend for transactional and marketing emails
  • Tailwind for rapid UI development with design system

Development Stats:

  • 100+ commits over 2 months
  • Full test coverage for critical paths
  • CI/CD pipeline with automatic deployments