The story about how we build the ossinsight project, including how we deal with the historical and real-time huge data, the database solutions and so on.

Alex Patterson

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

OSS Insight can analyze popular GitHub collections by many metrics including the number of stars, issues, and contributors. This is an analytical query that includes aggregation and ranking. To get the order of issue creators, we need to get to issue creators. In the statement above, the collections and collection_items tables store the data of all GitHub repository collections.

Build a Better GitHub Insight Tool in a Week? A True Story

Headache 1: we need both historical and real-time data. ​

How we deal with analytical queries with SQL ​

Really interesting and an actually helpful site!

That’s insane! Such a great solution and prototype in just a week!

Our team is now also thinking about developing an open-source solution. Very interesting to hear about the experiences of others! Thanks for sharing