Update: v0.7.0 - Leaderboards & User Profiles

Released: November 8, 2025

Major feature update focused on competition and recognition for active voters.

What's New

Leaderboards

• 📊 Per-matchup leaderboards - Top 10 voters per side
• 🌍 Global leaderboard - All-time top voters across all matchups
• 🔥 Trending voters - Most active in last 24 hours
• 🏆 Rank badges - Visual indicators for top 3 positions
• ⚡ Real-time updates - Rankings update live as votes come in

User Profiles

• 👤 Public profiles - View anyone's voting history
• 📈 Personal stats - Total votes, matchups participated, win rate
• 🎯 Favorite side - Which side you vote for most
• 📅 Member since - Account creation date
• 🔗 Shareable profile URL - tuggy.io/@username

Achievements

• 🏅 First Vote - Cast your first vote
• 🔥 100 Club - Vote 100 times in one matchup
• ⚡ Speed Demon - Vote 10 times in 10 seconds
• 🎯 Loyal Voter - Vote on same side 50 times
• 🌟 Top 10 - Reach top 10 on any leaderboard
• 👑 Champion - Reach #1 on any matchup

Rank System

• Bronze (0-99 votes): New voters
• Silver (100-999 votes): Active participants
• Gold (1,000-9,999 votes): Dedicated voters
• Platinum (10,000+ votes): Elite power voters

UI Improvements

• Redesigned matchup page with leaderboard sidebar
• Added profile dropdown in header
• Achievement toast notifications
• Rank progression indicators
• Mobile-optimized leaderboard view

Technical Changes

• Implemented efficient ranking queries with PostgreSQL window functions
• Added caching layer for leaderboard data (5-second TTL)
• Real-time rank updates via Supabase subscriptions
• Optimized profile page queries
• Added indexes on votes table for ranking performance

Bug Fixes

• Fixed vote counter overflow on matchups with 100K+ votes
• Improved realtime reconnection stability
• Fixed leaderboard not updating for anonymous users
• Resolved timezone issues in stat calculations
• Fixed profile page 404 for usernames with special characters

Performance

• Leaderboard query time: <50ms (down from 800ms)
• Profile page load: <100ms
• Real-time rank updates: <2 second delay
• Achievement checks: <5ms per vote

Breaking Changes

None - fully backward compatible

Migration Notes

For authenticated users:

• Existing votes automatically counted toward achievements
• Rank calculated based on historical vote data
• No action required

Metrics (First Week)

• Achievement completion rate: 45% of users earn ≥1 achievement
• Profile views: 12% of users visit other profiles
• Leaderboard engagement: 67% check rankings after voting
• Rank progression: Average user reaches Silver in 3 days

What's Next

v0.8.0 will add custom contestant images, image uploads, and moderation tools!