One month of Google Summer of Code with FOSSi

It has been a month since I have been working on my Google Summer of Code Project with Free and Open Source Sillicon Foundation. And in this month I have been working to extract and display statistics about code of projects listed in

1st and the 2nd Week

The extraction of commits has been added as a step to the reopsitory update pipeline. Commits are extracted and stored in the database as per their commit ID and user identity. To detect history rewrites, we check the presence of last commit in the current tree. If it is absent, then the commit history present in our database is rewritten — we drop all the commit records from our database and recreate all commit entries, from the beginning.

3rd Week

This week was the most challenging of all. Extracting time-series data from SQL database is not a easy task. Sorting the values, filling the missing data with zero values, complicated GROUP BY clauses etc. These things deserve their own standalone article.

Additionally, for each project, top five contributors and their Gravataar images are also displayed.

4th week

Structured Query meets Unstructured Data

However, Doctrine, the ORM used in our project does not support this natively (support is coming soon), we have to drop into PHP Serialization for now.

This month’s work has been full of interesting observations and experiences. I am eagerly looking forward for the next months GSoC work, which will largely involve, making full use of Github APIs to avoid a full repository clones which is mildly risky.


Originally published at on July 2, 2017.

Computer Whisperer. Open-source contributor. Find me at

Computer Whisperer. Open-source contributor. Find me at