Blog

Reports, tutorials, and product stories

Helping dev teams adopt OSS technologies and practices. Written by software engineers and community analysts.

The Coding Agent Wars: Who's Actually Winning (And It's Not Who You Think)
·9 min read·
insightai

The Coding Agent Wars: Who's Actually Winning (And It's Not Who You Think)

We analyzed 14 coding agents across 600K+ GitHub events to find out who's really winning the coding agent wars. Stars tell one story — contributor data tells a very different one.

O
OSSInsight
Rebuilding OSSInsight: From Docusaurus to Next.js, Powered by AI
·7 min read

Rebuilding OSSInsight: From Docusaurus to Next.js, Powered by AI

How we migrated OSSInsight from a Docusaurus SPA to a Next.js App Router monorepo — and used Claude Code to ship 30+ SEO, SSR, and UX improvements in a single afternoon.

Claude Code
Claude Code
engineering
Configurations for building "Open Source Benchmark" GPTs
·18 min read

Configurations for building "Open Source Benchmark" GPTs

This blog contains all the configurations while building OSS Comparison GPTs.

sykp241095ChatGPT
sykp241095, ChatGPT
openai
How to Learn SQL Easily by Visualizing with ChatGPT
·2 min read

How to Learn SQL Easily by Visualizing with ChatGPT

SQL is a powerful language for managing and analyzing data, but it can be difficult to learn for beginners. That's where ChatGPT comes in.

PingCAPChatGPT
PingCAP, ChatGPT
openai
The Unsung Heroes of Open Source: The Dedicated Maintainers Behind Lesser-Known Projects
·8 min read

The Unsung Heroes of Open Source: The Dedicated Maintainers Behind Lesser-Known Projects

This article will take a closer look at a few of these unsung heroes of the open source world.

Mia ZhouNotion AI
Mia Zhou, Notion AI
Maintainer
Get insight from your own data by asking questions without SQL skills
·1 min read

Get insight from your own data by asking questions without SQL skills

Get insight of your own dataset by asking questions without writing sql with ease!

PingCAPChatGPT
PingCAP, ChatGPT
openai
Reducing Online Serving Latency from 1.11s to 123.6ms on a Distributed SQL Database
·11 min read

Reducing Online Serving Latency from 1.11s to 123.6ms on a Distributed SQL Database

This post tells how a GitHub data insight website on a distributed database reduced online serving latency from 1.11s to 123.6ms.

Mini256Caitin Chen
Mini256, Caitin Chen
tidbcloud
Open Source Highlights: Trends and Insights from GitHub 2022
·10 min read

Open Source Highlights: Trends and Insights from GitHub 2022

We analyzed 5 billion+ GitHub events and got interesting findings about open source software, including top programming languages, geographic distribution behavior, popular open source topics, and the most active repositories and developers.

Cheese WongJaggerhooopo
Cheese Wong, Jagger, hooopo, Vita Lu, Mia Zhou, Caitin Chen
insight
GitHub Events Are Booming! Are Bots the Reason?
·5 min read

GitHub Events Are Booming! Are Bots the Reason?

This post dives deeply into GitHub event trending, why GitHub events are surging, and whether GitHub's architecture can handle the increasing load.

Mia ZhouWink YaoCaitin Chen
Mia Zhou, Wink Yao, Caitin Chen
insight
Build a Better GitHub Insight Tool in a Week? A True Story
·10 min read

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

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.

Wink YaoFendy Feng
Wink Yao, Fendy Feng
tidb
Who works the longest hours on GitHub
·1 min read

Who works the longest hours on GitHub

Love, Code, and Robot — Explore robots in the world of code
·7 min read

Love, Code, and Robot — Explore robots in the world of code

This article describes the evolution of bots in the GitHub world, their behaviors and characteristics, and the impact they have brought to the open source world.

Mini256
Mini256
Deep Insights into JavaScript Frameworks
·3 min read

Deep Insights into JavaScript Frameworks

In this chapter, we will share with you some of the top JavaScript Framework repos(JSF repos) on GitHub in 2021 measured by different metrics including the number of stars, PRs, contributors, countries, regions and so on.

Jagger
Jagger
insight
Deep Insights into Low-code Development Tools
·2 min read

Deep Insights into Low-code Development Tools

In this chapter, we will share with you some of the top low-code development tools repos (LCDT repos) on GitHub in 2021 measured by different metrics including the number of stars, PRs, contributors, countries, regions and so on.

Jagger
Jagger
insight
Deep Insight Into Open Source Databases
·6 min read

Deep Insight Into Open Source Databases

On this page, we will share with you many deep insights into open source databases, such as the database popularity, database contributors, coding vitality, community feedback and so on.

Jagger
Jagger
insight
Deep Insights into Programming Languages
·2 min read

Deep Insights into Programming Languages

In this chapter, we will share with you some of the top programming language repos (PL repos) on GitHub in 2021 measured by different metrics including the number of stars, PRs, contributors, countries, regions and so on.

Jagger
Jagger
insight
Deep Insights into Web Frameworks
·3 min read

Deep Insights into Web Frameworks

In this chapter, we will share with you some of the top Web Framework repos (WF repos) on GitHub in 2021 measured by different metrics including the number of stars, PRs, contributors, countries, regions and so on.

Jagger
Jagger
insight
Explore Deep in 4.6 Billion GitHub Events
·10 min read

Explore Deep in 4.6 Billion GitHub Events

Here you can find the answer of what does a view of 4.6 billion Github events really look like and what secrets and values can be discovered in such an enormous amount of data.

Fendy Feng
Fendy Feng
tidbcloud
SaaS Insight for Building a Real-time CRM Application
·3 min read

SaaS Insight for Building a Real-time CRM Application

This article describes how to building a real-time CRM application in a better way. Includes the potential database solutions.

ilovesoup
ilovesoup
tidb
[Outdated] Use TiDB Cloud to Analyze GitHub Events in 10 Minutes
·5 min read

[Outdated] Use TiDB Cloud to Analyze GitHub Events in 10 Minutes

In this tutorial, we will provide you with a piece of sample data of all GitHub events occurring on January 1, 2022, and walk you through on how to use TiDB Cloud to analyze this data in 10 minutes.

Fendy Fenghooopo
Fendy Feng, hooopo
tidbcloud
Data Preparation for Analytics
·5 min read

Data Preparation for Analytics

In this section, we will explain step by step how we process the massive data archived by GH Archive which up to 4.7 billion rows.

hooopo
hooopo
tidbcloud