Peepskill

A sports-focused social networking platform with role-based profiles, feeds, connections, and content moderation, serving 2,000+ early users.

React.js
Next.js
Sequalize
Node.js
MySQL
Docker
GCP
Socket.io
Peepskill
Preview 1
Preview 2
Preview 3
Preview 4
+18

View Gallery

22 Images

Duration

Nov 2024 – Mar 2025

Team Size

2 Developer, 1 Designer, 1 PM

My Role

Full Stack Engineer

Project Overview

Key Highlights

Duration: Nov 2024 – Mar 2025
Team Size: 2 Developer, 1 Designer, 1 PM
My Role: Full Stack Engineer
Status: Completed

Peepskill is a niche social media platform designed to connect athletes, coaches, fans, and sports professionals through role-based profiles, media sharing, and real-time engagement. The platform emphasizes scalable feed delivery, secure role-based access, and rich interaction features, while maintaining performance and moderation capabilities for a safe community.

Key Features:

1. Authentication & User Management - Secure registration & login with JWT-based authentication. - Role-based access for ATHLETE, COACH, FAN, and ADMIN. - Email verification, password reset, and session management. - Role-specific permissions ensuring secure resource access. - Admin capabilities for onboarding, role reassignment, and deactivation. - Audit logging of user activities and access patterns.

2. Profiles & Networking - Rich user profiles with role-specific details (e.g., athletic stats, coaching credentials). - Profile editing with bio, profile picture, and sports preferences. - Follow/unfollow and connection request system. - Search and discovery with pagination and filtering. - Personalized feed aggregation based on connections and interests.

3. Media Feeds & Engagement - Post creation with text, images, and videos. - Nested comments, replies, and likes with pagination. - Reposting (share) functionality to boost content visibility. - Trending posts calculated from engagement metrics. - Background jobs for media upload, processing, and CDN delivery. - Optimized feed queries using indexes and joins.

4. Blogs & Content Publishing - Blog module for long-form content by athletes and coaches. - Rich text formatting with images and embedded media. - Categorization by sport, level, or region. - Admin moderation workflows for reported blogs.

5. Real-Time Chat & Messaging - One-to-one direct messaging between athletes, fans, and coaches. - Role-based chat rooms for group discussions (e.g., team-only rooms). - WebSocket-based infrastructure for real-time delivery. - Message persistence with seen/unseen tracking. - Push notifications for new messages when offline. - Secure architecture with access checks and encrypted message storage. - Multi-device sync ensuring conversations are available across sessions.

6. Notifications & Real-Time Updates - In-app and push notifications for follows, likes, comments, messages, and reports. - Real-time updates via WebSockets for critical events. - Batched notification delivery for performance optimization. - Unseen notification tracking with badge counters.

7. Admin & Moderation - Role-based admin dashboards for content and user management. - Moderation tools for reviewing reported posts, messages, users, and comments. - Ability to deactivate users, block content, or escalate issues. - Analytics dashboards for monitoring growth, activity, and trends. - Exportable reports for adoption and engagement metrics.

8. Sports Metadata & Categorization - CRUD for sports categories, leagues, and skill levels. - Tagging system for posts and blogs by sport type. - Search and filtering powered by sports metadata.

9. Security & Compliance - Secure APIs with input validation and rate limiting. - Role-based middleware preventing unauthorized access. - Media upload validation to prevent malicious files. - Audit logs for user actions, reports, and moderation events. - Containerized deployment on GCP with environment isolation.

10. Scalability & Performance - Paginated queries and caching strategies for feeds, comments, and chats. - Database indexing to reduce query load (~35% improvement). - Background workers for heavy tasks (media, notifications, chat). - Dockerized microservices deployed with CI/CD on GCP. - Load-tested to handle thousands of concurrent requests.

11. Developer Velocity & Deployment - Automated pipelines for testing, linting, and deployment. - Local development with Docker Compose for reproducibility. - Staging and production environments with feature flags. - Logging and monitoring with GCP Cloud Monitoring and Sentry. - GitHub-based code reviews and branching strategy.

Challenges
  • Secure role-based access for Athletes, Coaches, Fans, and Admins
  • Handling large media uploads and generating public URLs
  • Optimizing queries for feeds, nested comments, and search
  • Designing scalable admin dashboards and moderation tools
  • Building an MVP under tight deadlines
Solutions
  • Implemented JWT authentication with role-based access middleware
  • Integrated Google Cloud Storage for scalable media uploads with public sharing
  • Optimized DB queries with pagination, joins, and indexing for fast feeds
  • Developed modular REST APIs for posts, profiles, blogs, and connections
  • Delivered MVP in 6 weeks with Dockerized deployment on GCP
Results
  • Successful MVP adoption by 2,000+ early users
  • Reduced DB query load by ~35% through optimization
  • Enabled admins to moderate 100% of reported posts and users
  • Increased engagement via trending posts, notifications, and following system
  • Improved developer velocity with CI/CD pipelines and containerized environments