Skip to content

💡[Feature]: Leaderboard Update #1362

@sanjay-kv

Description

@sanjay-kv

Is there an existing issue for this?

  • I have searched the existing issues

Feature Description

I feel we shouldn't embed all the logic in the frontend. Scraping leaderboard data directly from the frontend and displaying it there would be poor practice.

Instead, let's create a dedicated backend that updates every 2-3 hours. We created before for gssoc program and hosted the backend on railway which work as a job and update it every 3 hours.

right now whats happening is when user do a PR and get merged instantly it appear in on the frontend , when we have more user it will use all our API usage limits on github.

So we can have a seperate repo in the repository named backend and pull data from there to front end.

This backend can handle all the complexity, including how to scrape GitHub PRs and manage the data.

By keeping the complexity in the backend, we can send simple, clean data to the frontend. This approach prevents unnecessary repetitive API calls imagine scaling to 100 active users; they'd exhaust the API limits in just 1-2 days.

In the backend, we can implement a simple mechanism to scrape data every 2 hours and serve a cached version to the frontend. This will eliminate a lot of redundant API calls and make the frontend much cleaner, faster and easier to maintain.

If you're okay with this approach, I have backend folder in the repository, move all the logic there, and clean up the frontend accordingly.

Use Case

backedn code base: https://github.com/recodehive/leaderboard

Dashboard live view: https://gssoc-new-dashboard-two.vercel.app/leaderboard

Benefits

Watch the explanation video

https://www.loom.com/share/acff412de5894a869368623996cdefde

Add ScreenShots

No response

Priority

High

Record

  • I have read the Contributing Guidelines
  • Are you a WSOC'25 contributor
  • I want to work on this issue

Metadata

Metadata

Assignees

Labels

area:backend-sqlfor issues related to the experimintal support of MsSql as backendenhancementNew feature or requestlevel 230 pointsrecodethis is label for leaderboard

Type

Projects

Status

Todo

Status

Q3 2026 – July-Sept

Relationships

None yet

Development

No branches or pull requests

Issue actions