Feb 14, 2021Code Contributions by Email Domainby Patrick DeVivo Ever want to know what organizations are contributing to an open-source codebase? This AskGit query may be able to help: Or, in other words: show me the email domains of commit authors (excluding merge commits), ordered by the most frequently occurring domain. For instance, for the…Git1 min readGit1 min read
Dec 20, 2020Measuring Average Pull Request Merge Time With AskGit SQLby Patrick DeVivo AskGit recently added support for querying against data in the GitHub API. Repositories and pull requests can be listed by calling several table-valued functions in your SQL queries. More resource types from the GitHub API are planned and will be integrated soon! Using github_pull_requests('REPO_OWNER', REPO_NAME') in the…Git2 min readGit2 min read
Nov 28, 2020Identifying Code Churn With AskGit SQLby Patrick DeVivo AskGit is a tool we’ve been building that makes it possible to run SQL queries against data in git repositories. Recently, we added support for a stats table, which tracks lines of code added and removed to a file, for every commit (in the current history). …Git3 min readGit3 min read
Mar 8, 2020// TODO Comments Are a Joke, But They Don’t Have To Beby Patrick DeVivo Have you ever come across a TODO comment in some code and had a chuckle? Maybe it looked like: // TODO fix this, with no context. Maybe it was added years ago by a developer who’s quit the project. …Software Development4 min readSoftware Development4 min read
Feb 29, 2020Measuring the Health of Git Repositories 🧑⚕️by Patrick DeVivo As I work more on tickgit 🎟️, a question that repeatedly arises is whether TODO comments are a useful indicator of the health of a codebase. Generally, I think not — at least on their own. …Git4 min readGit4 min read
Dec 30, 2019A TODO Finder for Public Git RepositoriesAbout a week ago, we published an article looking at the (mostly forgotten) 2k+ TODO comments in the Kubernetes codebase. We chose to look at Kubernetes because of its high profile and “high scale” as a large, open-source project. What we found was interesting, but probably not all that surprising. …Github2 min readGithub2 min read
Dec 15, 2019Many of Kubernetes’ 2k+ TODO Comments seem to be Forgottenby Patrick DeVivo Kubernetes is a big project. Not only because it’s a big deal, but also in terms of its source code. At the time of writing, there are 86k+ commits, 2k+ contributors, 2k+ open issues, 1k+ open PRs, and 61k+ stars. …Golang4 min readGolang4 min read