It’s been 5 years since we implemented version control on all of our projects at Cossette. We were way late to the party on this one but this wasn’t something that was really crucial at the time as we were a rather small team with rather small projects. We first started with Subversion in 2010 and finally switched over to Git in 2013.
I recently needed to identify which of our 200+ projects were still active or at least updated once in a while. I figured my best course of action was to review our Git logs and figure out which projects had received at least one update in the last 3 months.
When I started working with git-log things got a bit outta hand : I realized we had gathered a massive amount of data while working on our daily projects. Furthermore, there were some really cool learnings to draw from that like finding what period of the year we’re usually the most swamped, or what’s the biggest project we’ve ever delivered in the shortest amount of time, or figuring out our developers’ commit habits.
I imported all the logs into a MySQL database to facilitate the queries I was about to do. I then used Google Charts to display the results. Some things I found out we’re really interesting :
- Springs are busy : no doubt about it, always the craziest part of the year;
- Afternoon is where it’s at : I was kinda surprised about this one, but it looks like we do most of our work in the afternoon. I feel like I’m usually most productive in the morning, but the end of day last minute requests probably have something to do with this;
- Growth : each year that passes has more commits to it than the last one (with the exception of 2013, which was unusually crazy-busy). To me, that’s excellent news : we’ve been hiring developers and keeping them busy;
- Fast projects : our “Proud to build what matters” website for SNC-Lavalin this year was the fastest biggest project we’ve ever delivered. A simply division of number of commits per active work days help me reached that conclusion. Kinda skewed, but still indicative of how effective we were with this particular project;
All in all, most of the statistics I gathered were only proof of things we already assumed. But it’s always nice to put these thoughts into numbers.