Stats for Spotify: Music Analytics Platform

Production-ready music analytics platform built with Next.js 16 App Router and Supabase. Tracks users' top 50 artists, tracks, and albums across multiple time ranges (4 weeks, 6 months, all time) with automated snapshot collection respecting 24-hour intervals. Features include historical trend visualization with Recharts-powered line graphs and sparklines, color-coded rank change badges (↑5, ↓3, NEW, —), and progressive enhancement that works with or without historical data. Social features enable friend discovery through mutual Spotify followers, privacy controls (public/friends-only/private), Discord-style usernames with discriminators, and the ability to browse friends' listening history. Built with Row Level Security (RLS) ensuring users can only access their own data and authorized friend data. Includes comprehensive data management with JSON/CSV export, profile customization, and full data deletion capability for Spotify API compliance. Vercel Analytics and Speed Insights provide performance monitoring, while Framer Motion powers smooth animations and transitions. Auto-generated TypeScript types from Supabase schema ensure type safety across all database operations.

Implemented auto-snapshot trigger component that checks last snapshot timestamp before initiating collection, with 24-hour interval enforcement at both client and API levels. Friend system uses a cached follow verification table with configurable TTL to minimize Spotify API calls while keeping data fresh. Row Level Security policies enforce privacy settings at database level, with helper functions checking user relationships and permissions. Recharts visualizations detect presence of historical data and gracefully degrade to current-only views when snapshots are unavailable. Database types are auto-generated from Supabase schema using CLI and synchronized daily via GitHub Actions, ensuring type safety without manual maintenance.

Delivered a production-ready music analytics platform with 50+ UI components, automated data collection respecting API limits, comprehensive social features with privacy controls, and full Spotify API compliance. Achieved optimal performance through parallel data fetching, React Query caching, and Server Components. Type safety maintained across entire stack with automated schema synchronization. Successfully deployed on Vercel with Analytics and Speed Insights integration, providing users with historical music taste tracking, friend discovery, and detailed listening statistics while maintaining data privacy and security through Row Level Security.