VolvoxLLC / volvox-bot / 23515356542

91%

push

github

feat: expand Redis caching across bot API routes and web dashboard (#346)

* Initial plan

* feat: add Redis caching to guild stats, analytics, moderation stats, member enrichment, and web proxy ISR

Co-authored-by: BillChirico <13951316+BillChirico@users.noreply.github.com>
Agent-Logs-Url: https://github.com/VolvoxLLC/volvox-bot/sessions/f3047b02-6585-493d-81d1-b6bd1738ec63

* perf: batch engagement DB writes into a 10-second write-back buffer

Co-authored-by: BillChirico <13951316+BillChirico@users.noreply.github.com>
Agent-Logs-Url: https://github.com/VolvoxLLC/volvox-bot/sessions/8587ef61-e1a6-4f09-b846-18ea93a1f737

* fix(analytics,engagement): fix stale activeAiConversations in realtime, fix comment precision, guard concurrent interval flushes

* fix(analytics,engagement): move realtime fields outside cache, guard concurrent interval flushes, sync lockfiles

* fix(engagement,analytics,tests): fix comment, propagate flush errors, add AI-conversation fallback, fix test mock order, fix lint

* fix(lint,docker): fix moderation import order, regenerate web/pnpm-lock.yaml

* fix(engagement,analytics,cache,moderation): address all review comments

- engagement.js: add MAX_BUFFER_SIZE (50k) with backpressure, batch inserts (BATCH_SIZE 10k),
  in-flight guard to prevent overlapping flushes, rate-limited error logging (1st + every 30th),
  fix comment (FLUSH_INTERVAL_MS -> DEFAULT_FLUSH_INTERVAL_MS), rethrow on flush failure
- guilds.js: validate channelId as snowflake (digits, max 20 chars) before cache key,
  wrap activeAiConversations query in try/catch with null fallback
- moderation.js: use dedicated TTL.MOD_STATS instead of TTL.LEADERBOARD
- cache.js: add TTL.MOD_STATS, add bot:stats:* to cacheClear() prefixes
- guilds.test.js: fix mock sequence for moved activeAiConversations query,
  update channelId fixtures to valid snowflakes
- reviewHandler.test.js: fix flatMapIdentity lint (biome)

---------

Co-authored-by: copilot-swe-agent[bot] <198982749+... (continued)

6372 of 7462 branches covered (85.39%)

Branch coverage included in aggregate %.

186 of 200 new or added lines in 5 files covered. (93.0%)

10835 of 11623 relevant lines covered (93.22%)

224.29 hits per line