feat: automatic VOD ID resolution for stream sessions and historical pending streams

feat: smart gap detection and user roles sync backfill improvements

feat: smart gap detection with coverage windows - track exact time ranges captured per stream

fix: logRolesBatch always updates roles, only preserves newer last_seen

feat: global roles migration, VIP badges, role backfiller script

Optimize KPI cards to request overall stats summary from /api/stats/summary and display true totals.

Optimize message ingestion with logChatMessagesBatch: bulk upsert to database.

Optimize moderation logging: fix duplicate collisions, auto-refresh streamer OAuth tokens, and implement IRC keep-alive timeouts. Add unit tests.

fix: add pagination to unpaginated Supabase queries to bypass 1000 row limit

fix: polyfill WebSocket for Supabase client on Node.js 20 and add Hugging Face metadata

feat: prepare transition to decoupled hosting (Render + Netlify + Supabase)