ClickHouse Source Code Analytics Using ClickHouse

Student: Shirin Nikita

Educational Programme: Applied Mathematics and Information Science (Bachelor)

Year of Graduation: 2019

GitHub is the most popular hosting service for open source code. GitHub allows developers to collaborate on projects. As of November 2018, there are more than 31 million users and more than 100 million repositories on GitHub. Many projects require a collaboration of developers, which can lead to complication of a development process. In this work we try to build a tool, which analyses a particular repository, saves all the data on a repository into database working on ClickHouse database management system and provides users with an interface, which allows them to write custom SQL-queries and get many valuable statistics extracted from a repository code and metadata, which will lead analysts and developers working on a project to gain insights into their work. Crawler written in Python, using libraries pydriller, git and clickhouse-driver. User interface is implemented as a web-service, written in TypeScript and React, using python flask web-server and PostgreSQL as a service storage.

Student Theses at HSE must be completed in accordance with the University Rules and regulations specified by each educational programme.

Summaries of all theses must be published and made freely available on the HSE website.

The full text of a thesis can be published in open access on the HSE website only if the authoring student (copyright holder) agrees, or, if the thesis was written by a team of students, if all the co-authors (copyright holders) agree. After a thesis is published on the HSE website, it obtains the status of an online publication.

Student theses are objects of copyright and their use is subject to limitations in accordance with the Russian Federation’s law on intellectual property.

In the event that a thesis is quoted or otherwise used, reference to the author’s name and the source of quotation is required.

Search all student theses