This web app can scrape HackClub's Summer of Making website and gather every single project along with every user who has created at least one project.

The projects are stored in a PostgreSQL database. The entire list of projects is sent to the frontend which then does the required processing (sorting, filtering, etc.).

Clone the repo:

git clone https://github.com/BirdRoad1/summerofmaking-data.git

Install yarn if necessary:

npm i -g yarn

Install dependencies:

yarn install

Rename .env.sample to .env and adjust variables as needed

Start the web app:

yarn dev

This project allows you to see the users with the most hours and the projects with the most hours logged. Therefore, by checking the top ranked users, you can easily spot cases of fraud. For example, users with simple projects who log hundreds of hours are most likely faking their hours.

The more valuable Summer of Making prizes are limited in stock, so it may be useful to see how others are doing relative to you. With this project, you can see how you rank in the global leaderboard and exactly who the top rankers are and how many hours they have logged.

You will need a PostgreSQL database and Node.js 22 or higher.