Hacktoberfest 2020 👩‍💻👨‍💻 in insights and statistics 📊

TL;DR: I've built hacktoberfest.cube.dev. Have a look, it's fascinating.

Hey devs! 👋

I guess that you should've definitely heard about Hacktoberfest 2020 even if you didn't have a chance to participate in it. Indeed, this year was quite special. Oh, wait, who said Spamtoberfest? 😂

Lots of people joined Hacktoberfest to make positive contributions to open source (or just get a T-shirt 🤷), so organizers needed to introduce additional rules along the way to fight against spammy pull requests.

So I thought it's a good excuse to tinker with Hacktoberfest data and build yet another interactive analytical website. Especially because I'm quite familiar with Cube.js, an open source tool which makes building such apps a breeze.

Here comes hacktoberfest.cube.dev:

Have a look and you'll know:

how many pull requests were submitted in total (a lot, but less than in 2019)
what's the 3rd most popular programming language (okay, it's actually a markup language)
how many commits a single pull request contained, on average (though it's rumored that most of them were punctuation fixes)
and much more.

And that's not all 🙋‍♀️

I'm going to write a series of posts and tell how to build such an analytical website from scratch. Here're the topics I'm going to cover:

how to collect data via GitHub API
how to transform JSON records into an SQL storage with Amazon Athena
how to spin up an analytical backend and explore the data with Cube.js
how to build a frontend for an analytical app with React

So, if you're interested in these topics, make sure to follow me and leave a comment about the details you want me to cover and your previous experience with analytical apps, if any.