Explore Deep in 4.6 Billion GitHub Events
Tags: tidb, discuss, github, ossinsight
Published: 2022-05-19 00:35:00

4.6 billion is literally an astronomical figure. The richest star map of our galaxy, brought by Gaia space observatory, includes just under 2 billion stars. What does a view of 4.6 billion GitHub events really look like? What secrets and values can be discovered in such an enormous amount of data?

Here you go: OSSInsight.io can help you find the answer. It’s a useful insight tool that can give you the most updated open source intelligence, and help you deeply understand any single GitHub project or quickly compare any two projects by digging deep into 4.6 billion GitHub events in real time. Here are some ways you can play with it.

**Compare any two GitHub projects**
Do you wonder how different projects have performed and developed over time? Which project is worthy of more attention? OSSInsight.io can answer your questions via the Compare Projects page.

Let’s take the Kubernetes repository (K8s) and Docker’s Moby repository as examples and compare them in terms of popularity and coding vitality.

**Popularity**
To compare the popularity of two repositories, we use multiple metrics including the number of stars, the growth trend of stars over time, and stargazers’ geographic and employment distribution.

**Number of stars**
The line chart below shows the accumulated number of stars of K8s and Moby each year. According to the chart, Moby was ahead of K8s until late 2019. The star growth of Moby slowed after 2017 while K8s has kept a steady growth pace.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/0y3m6ua67u21y56wcteo.png)
**Geographical distribution of stargazers**
The map below shows the stargazers’ geographical distribution of Moby and K8s. As you can see, their stargazers are scattered around the world with the majority coming from the US, Europe, and China.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/z022suv8tsth0gs4o0eb.png)
**Employment distribution of stargazers**
The chart below shows the stargazers’ employment of K8s (red) and Moby (dark blue). Both of their stargazers work in a wide range of industries, and most come from leading dotcom companies such as Google, Tencent, and Microsoft. The difference is that the top two companies of K8s’ stargazers are Google and Microsoft from the US, while Moby’s top two followers are Tencent and Alibaba from China.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5g0tw6e0xvh896usvp6y.png)
**Coding vitality**
To compare the coding vitality of two GitHub projects, we use many metrics including the growth trend of pull requests (PRs), the monthly number of PRs, commits and pushes, and the heat map of developers’ contribution time.

**Number of commits and pushes**
The bar chart below shows the number of commits and pushes submitted to K8s (top) and Moby (bottom) each month after their inception. Generally speaking, K8s has more pushes and commits than Moby, and their number grew stably until 2020 followed by a slowdown afterwards. Moby’s monthly pushes and commits had a minor growth between 2015 and 2017, and then barely increased after 2018.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qrwkftv023y7ujxewdxs.png)
**Number of PRs**
The charts below show the monthly and accumulated number of PRs of the two repositories. As you can see, K8s has received stable and consistent PR contributions ever since its inception and its accumulated number of PRs has also grown steadily. Moby had vibrant PR submissions before late 2017, but started to drop afterwards. Its accumulated number of PRs reached a plateau in 2017, which has remained the case ever since.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1pgrq2eiyj1ob6kshanu.png)
**Developers’ contribution time**
The following heat map shows developers’ contribution time for K8s (left) and Moby (right). Each square represents one hour in a day. The darker the color, the more contributions occur during that time. K8s has many more dark parts than Moby, and K8s’ contributions occur almost 24 hours a day, 7 days a week. K8s definitely has more dynamic coding activities than Moby.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/04k3iip4lzmsdtyvbqqd.png)
Taken together, these metrics show that while both K8s and Moby are popular across industries world-wide, K8s has more vibrant coding activities than Moby. K8s is continuously gaining popularity and coding vitality while Moby is falling in both over time.

Popularity and coding vitality are just two dimensions to compare repositories. If you want to discover more insights or compare other projects you are interested in, feel free to visit the Compare page and explore it for yourself.

Of course, you can use this same page to deeply explore any single GitHub project and gain the most up-to-date insights about them. The key metrics and the corresponding changes are presented in a panoramic view. More in-depth analytics such as code changes by PR size groups and PR lines are also available. Explore it for yourself and you’d be surprised. Have fun.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/s774916iuj3tozyv0qml.png)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/t23eznjtd4n5ogkfx67f.png)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/pluhn0arwslvthq21re8.png)
**Key open source insights**
OSSInsight.io does more than explore or compare repositories. It gives you historical, real-time, and custom open source insights. In this section, we’ll share some key insights in open source databases and programming languages. If you want to gain insights in other areas, you can explore the Insights page for yourself.

Note: If you want to get those analytical results by yourself, you can execute the SQL commands above each chart on TiDB Cloud with ease following this 10-minute tutorial.

**Rust: the most active programming language**
Rust was first released in 2012 and has been among the leading programming languages for 10 years. It has the most active repository with a total of 103,047 PRs at the time of writing.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/pflzgpiskx2caxyf8rti.png)
**Go: the new favorite and the fastest growing programming language**
According to OSSInsight.io, 10 programming languages dominate the open source community. Go is the most popular with 108,317 stars, followed by Node and TypeScript. Go is also the fastest growing language in popularity.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/i24nle60waqf5bzir3dz.png)
**Microsoft and Google: the top two programing languages contributors**
As world-renowned high-tech companies, Microsoft and Google take the lead in open source language contributions with a total of 1,443 and 947 contributors respectively at the time of writing.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hbaccgi7kl1visc01r3u.png)
**Elasticsearch draws the most attention**
Elasticsearch was one of the first open source databases. It is the most liked database with 64,554 stars, followed by Redis and Prometheus. From 2011 to 2016, Elasticseasrch and Redis shared the top spot until Elasticsearch broke away in 2017.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6rfxukpdhp95k54g1do9.png)
**China: the number one fan of open source databases**
China has the most open source database followers with 11,171 stargazers of database repositories, followed by the US and Europe.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/d0brvqmkzw60t8kt69tx.png)
OSSInsight.io also allows you to create your own custom insights into any GitHub repository created after 2011. You’re welcome to visit the Insights page to explore more.

**Run your own analytics with TiDB Cloud**
All the analytics on OSSInsight.io are powered by TiDB Cloud, a fully-managed database as a service. If you want to run your own analytics and get your own insights, sign up for a TiDB Cloud account and try it for yourself with this 10-minute tutorial.

**Contact us**
Do you find OSSInsight.io useful and fun to work with? Do you have any question or feedback to share with us? Feel free to file an issue on GitHub or follow us on Twitter to get the latest information. You’re also welcome to share this insight tool with your friends.

https://ossinsight.io/blog/explore-deep-in-4.6-billion-github-events/