Микросервисы / распределенные системы

Не совсем по теме канала, но это просто бомба 😍



askgit is a command-line tool for running SQL queries on git repositories. It's meant for ad-hoc querying of git repositories on disk through a common interface (SQL), as an alternative to patching together various shell commands. It can execute queries that look like:



-- how many commits have been authored by [email protected]?

SELECT count(*) FROM commits WHERE author_email = '[email protected]'



-- Returns author emails with lines added/removed, ordered by total number of commits in the history (excluding merges):

SELECT count(DISTINCT commits.hash) AS commits, SUM(additions) AS additions, SUM(deletions) AS deletions, author_email

FROM commits LEFT JOIN stats('', commits.hash)

WHERE commits.parents < 2

GROUP BY author_email ORDER BY commits



…..



https://github.com/askgitdev/askgit