Find the oldest line in your repo(milofultz.com)
milofultz.com
Find the oldest line in your repo
https://milofultz.com/2025-01-26-find-the-oldest-line-in-your-repo.html
60 comments
Ugh. That is sooo Trygve.
Don't be too hard on him. For sufficiently large values of zero, you don't really need to check...
Incredible. This is like Graffiti from Pompeii.
You've got me beat... at a previous job, there were comments from 1991 complaining about how it was ported/rewritten from cobol.
A former job had a similarly old codebase. I made the mistake of asking where the docs were and someone pulled out this typewritten booklet of yellowed pages from 1981 that was the only remaining copy of the originals in the early 70s.
The code was on at least its 4th language by that point and is probably still running robots today.
The code was on at least its 4th language by that point and is probably still running robots today.
Ported to what?
Oracle Pro*C. You don't want to know.
I’ve never even heard of this before. Talk about old-school!
I forgot it existed, was using it at a couple of jobs circa 1989-1992. Completely blocked it out of my mind.
Yep. Huge limitation of this approach is the assumption the code has always lived in the same VCS. I remember migrating a monorepo for geointelligence processing algorithms years back to multiple repos, and its own history was it had been in Mercurial before Git, ClearCase before Mercurial, and God knows what earlier than that. But I was reviewing old Fortran code for handling specific vehicle missions and could see from the mission codes that some of these were satellites launched in the late 80s, so the code itself had to be even older than that.
You don't need to blame every file[1]. Use `git rev-list` to find your oldest commit:
https://git-scm.com/docs/git-rev-list
https://git-scm.com/docs/git-ls-tree
https://git-scm.com/docs/git-show
https://git-scm.com/docs/git-cat-file
https://git-scm.com/docs/gitrevisions
git rev-list --reverse --date-order HEAD | head -1 # or
git rev-list --reverse --author-date-order HEAD | head -1
git ls-tree -lr <commit-id>
git show <commit-id>:/path/to/file # or
git cat-file -p <commit-id>:/path/to/file
https://git-scm.com/docs/git-rev-list
https://git-scm.com/docs/git-ls-tree
https://git-scm.com/docs/git-show
https://git-scm.com/docs/git-cat-file
https://git-scm.com/docs/gitrevisions
Yes, your caveat is correct: it's possible that none of the lines present in your oldest commit have survived into the current head commit of your main branch.
Not sure how the article's algorithm deals with renames. If a file being renamed as a deletion and addition, then that conceals the age of the lines.
Not sure how the article's algorithm deals with renames. If a file being renamed as a deletion and addition, then that conceals the age of the lines.
> Not sure how the article's algorithm deals with renames
It's relying on `git blame`'s default behavior which is: "The origin of lines is automatically followed across whole-file renames (currently there is no option to turn the rename-following off). To follow lines moved from one file to another, or to follow lines that were copied and pasted from another file, etc., see the -C and -M options."
It's relying on `git blame`'s default behavior which is: "The origin of lines is automatically followed across whole-file renames (currently there is no option to turn the rename-following off). To follow lines moved from one file to another, or to follow lines that were copied and pasted from another file, etc., see the -C and -M options."
> I suppose this doesn't account for files which no longer exist or that have been completely re-written.
But... that's the point of this? Finding the initial commit is not nearly as fun as looking at the oldest code that is still running.
But... that's the point of this? Finding the initial commit is not nearly as fun as looking at the oldest code that is still running.
I like leaving something like gitlens on so I can see the super old lines ad-hoc when I naturally come across them. It's fun to get glimpses of the past.
Take my upvote :)
Similar oneliner to paste on MacOS terminal and get the eldest line for each file extension:
for ext in $(git ls-files | grep -vE 'node_modules|\.git' | awk -F. '{if (NF>1) print $NF}' | sort -u); do echo -e "\n.$ext:"; git ls-files | grep "\.$ext$" | xargs -I {} git blame -w {} 2>/dev/null | LC_ALL=C sort -t'(' -k2 | head -n1; done
for ext in $(git ls-files | grep -vE 'node_modules|\.git' | awk -F. '{if (NF>1) print $NF}' | sort -u); do echo -e "\n.$ext:"; git ls-files | grep "\.$ext$" | xargs -I {} git blame -w {} 2>/dev/null | LC_ALL=C sort -t'(' -k2 | head -n1; done
It's probably almost always going to be a boring config line(s) in the initial commit?
A section header in a pylintrc or Cargo.toml, a Django settings.py var, etc. Or even an import/var in a file that's core enough to still exist, import logging and LOGGER = ... for example.
A section header in a pylintrc or Cargo.toml, a Django settings.py var, etc. Or even an import/var in a file that's core enough to still exist, import logging and LOGGER = ... for example.
"Initial Commit", 9 years ago (transfered an at-the-time 15 year old SVN repo)
sigh..
sigh..
FWIW, when I ported SVN repos at work, I converted the commit history as well.
we hired contractors to move us from source gear to git and they said "moving the history would be too hard, so we didn't"
lost probably 10+ years of history
lost probably 10+ years of history
[deleted]
Renaming the company is also fun when its name is used for folders / package paths. The history isn't lost, just unusable.
There are a million files in the Meta monorepo starting with FB. I don't think they even changed the practice.
facepalm
yeah... wasn't me that did it though. Same group of people did it with a git repository they "recreated" more recently. They just don't know how to software.
I got my hands on the old SVN but it's a few TBs and so I had some trouble unzipping it. Maybe someday I'll patch a branch for blame archeology.
I got my hands on the old SVN but it's a few TBs and so I had some trouble unzipping it. Maybe someday I'll patch a branch for blame archeology.
Sigh indeed... at a previous job there was a project that was a port of an Algol project that began in 1992. I have no idea what version control systems were used in its history (wouldn't be surprised if it started with no version control) but the last version control migration was from Team Foundation Service to GitHub and of course it was just a single commit of the then current master. 23 years of history gone.
Our code base still has ghost comments about code being just so because the NeXT compiler won't accept it any other way. No one has the heart to remove them.
I picked up a project from 1999 a few years ago that still had far pointer macros - I didn't think they were still a thing in 1999 so I'm not sure why they were there to start with. I think I've left them though.
I imagine future engineers as archaeologists of software development, in a way, digging through ghost comments like fossils in the code.
future engineers?
archaeology is an essential part of virtually every real-world software project
In our monorepo (of 101470 Java files, according to
find . -name '*.java' | wc -l
If any of the lines form the repo's first commit happen to be untouched, then that's a huge short-cut: those lines are the oldest. Finding one of those lines manually is a pretty easy task. Enumerating them all accurately, less so.
Not sure why all the lines of code. This is much shorter:
git ls-files|xargs -n 1 git blame --date=format:%Y%m%d -f |grep -Eo '\d{8}.*' |sort -r | head -n 1 | sed 's/^[^)]*) \t//'
Get in the habit of using `ls-files -0` and `xargs -0` to prevent surprises. But there's no need to blame every file:
https://news.ycombinator.com/item?id=42883340
https://news.ycombinator.com/item?id=42883340
Good point. I fixed your null comment in https://news.ycombinator.com/item?id=42885601.
Hm, tried this on a Mac but something must be askew - it returned a commit by me in 2022 in a repo that has existed since at least 2017.
Whoops, it extracted the newest row :) Correction:
git ls-files -z|xargs -0 -n 1 git blame --date=format:%Y%m%d -f |grep -Eo '\d{8}.*' |sort -n | head -n 1 | sed 's/^[^)]*)*[ \t]//'
doesn't seem to work on macOS, I get:
find: illegal option -- t
usage: find [-H | -L | -P] [-EXdsx] [-f path] path ... [expression]
find [-H | -L | -P] [-EXdsx] -f path [path ...] [expression]I ran into that too. Turns out that you need to add in the path you want to search when invoking the command. If it's your current working directory, use `.`
[deleted]
I wrote a similar maybe hacky script using `git blame` on every file. In our main application, we still have a couple lines from the initial commit in 2011.
At my old job, I remember it was some time at the beginning of the 1990s. I was born like 8 years after the code I was working on was written.
Oldest file I ever had to fix was the same age as me: 1986. Found a bug in 2013. Timezone math.
> README.md 2021-01-28 17:27:57 +1100
Huh, TIL the birthdate of my business was actually a couple of days ago.
Huh, TIL the birthdate of my business was actually a couple of days ago.
I suspect it'll be index.php's <?php line, lol.
For the codebase I was working on today (in C). At first it was just } so filtered those out, then it was /* (no comment detail on that line) so again filter them. Then it was a bunch of #includes.
Not surprising but not insightful at all unfortunately
Not surprising but not insightful at all unfortunately
Always start your git repos with an empty commit, right?
Apparently not really helpful in the least anymore.
https://stackoverflow.com/questions/77446305/what-are-the-be...
https://stackoverflow.com/questions/77446305/what-are-the-be...
Maybe a readme.md with the initial name, a license file, and a .gitignore file. Whatever it is that all repos would have regardless of the language or application type.
Sep 30, 2008 at 5:03:58pm, revision 1.
It is SVN, though, and not Git.
It is SVN, though, and not Git.
What if my repo is older than git?
At $oldjob our Git repos had all been created by importing history from SVN, and that SVN repo had been created as an import from CVS, so there were some fairly old timestamps in the history. Only about a decade older than Git, though. Nothing from the era of SCCS or (bare) RCS.
Oldest I found?
1986-06-17: Trygve glemte å sjekke om vi deler på null. Fikset.
(Trygve forgot to check whether we divide by zero. Fixed.)