[PERFORMANCE] GitHub API responses not cached server-side, causing repeated identical requests on every dashboard page load

[anshul23102]

Problem

Each time the dashboard page loads, the server fires fresh API requests to GitHub for stats (commit counts, PR metrics, streak data) even when the underlying data has not changed. GitHub's REST API has a rate limit of 5,000 requests per hour per authenticated token. A user who refreshes the dashboard frequently, or a deployment with many active users sharing one token, will hit the rate limit and receive degraded responses (HTTP 403) until the window resets.

Steps to Reproduce

1. Open the dashboard
2. Observe the network panel: GitHub API calls fire on every page load
3. Refresh the page 60-70 times in quick succession
4. Observe HTTP 403 responses with X-RateLimit-Remaining: 0

Proposed Fix

Cache GitHub API responses server-side with a short TTL (5-15 minutes) using Redis or the existing Supabase instance:

const CACHE_TTL = 10 * 60; // 10 minutes in seconds

export async function getCachedGitHubStats(username: string) {
  const cached = await redis.get(`gh:stats:${username}`);
  if (cached) return JSON.parse(cached);
  const fresh = await fetchGitHubStats(username);
  await redis.setex(`gh:stats:${username}`, CACHE_TTL, JSON.stringify(fresh));
  return fresh;
}

Also display the last-refreshed timestamp in the UI so users understand they are viewing cached data.

Complexity: Level 2/3 | Program: GSSOC '26

[Tanisha-sharma7302]

Hi @Priyanshu-byte-coder , I'd like to work on this issue as part of GSSoC '26.

I reviewed the issue and understand that repeatedly fetching GitHub statistics on every dashboard load can quickly exhaust the GitHub API rate limit. I plan to implement server-side caching with an appropriate TTL (using the existing caching infrastructure such as Redis or Supabase, depending on the project's setup), ensure cached data is served efficiently while refreshing when necessary, and add a "Last updated" timestamp to improve transparency for users.

Could you please assign this issue to me? Thank you!

[github-actions]

Assigned to @Tanisha-sharma7302! You have 7 days to open a PR. No PR after 7 days = auto-unassigned so others can pick it up. Good luck!

[anshul23102]

/assign

Claiming this issue for GSSoC '26. Please assign it to me, I'll start working on it right away.