gitsql
Introduction
This is the project which helps to query Git info with SQL.
By default, it uses OpenMLDB to store data and visualize with OpenMLDB Lab.
Install
pip install gitsql
Usage
Initialize the database for git repository.
gitsql --repo ./gitsql init
Load the git data to database.
gitsql --repo ./gitsql load
Delete the database of the git repository.
gitsql --repo ./gitsql delete
Then we can use openmldb_lab to query with SQL in web browser.
pip install openmldb_lab
openmldb_lab --zk=0.0.0.0:2181 --zk_path=/openmldb
Use Cases
Query Large Insertions Commits
SELECT * FROM commit WHERE author = "tobe" AND insertions > 5000
Query Specified Commit
SELECT * FROM commit WHERE hexsha = "d039c6e74db30d4d7c423f7c24340192e1306d23"
Query Developers with Specified Email
SELECT * FROM commit WHERE email LIKE "%gmail.com"