# gitqlite - Git Repo에 SQL 쿼리 하기

> Clean Markdown view of GeekNews topic #2388. Use the original source for factual precision when an external source URL is present.

## Metadata

- GeekNews HTML: [https://news.hada.io/topic?id=2388](https://news.hada.io/topic?id=2388)
- GeekNews Markdown: [https://news.hada.io/topic/2388.md](https://news.hada.io/topic/2388.md)
- Type: news
- Author: [xguru](https://news.hada.io/@xguru)
- Published: 2020-07-05T09:39:53+09:00
- Updated: 2020-07-05T09:39:53+09:00
- Original source: [github.com](https://github.com/augmentable-dev/gitqlite)
- Points: 5
- Comments: 0

## Topic Body

- go-git 을 이용해서 Repo 내용을 SQLite 의 Virtual Table 로 구현

- gitqlite "SELECT * from commits" 처럼 사용 가능

- 테이블 & 필드 :

ㅤ→ commits : id, message, summary, author, commiter, parent_id..

ㅤ→ files : commit_id, name, type, contents..

ㅤ→ refs : name, type, hash

- SELECT count(*) AS commits, SUM(additions) AS additions, SUM(deletions) AS  deletions, author_email FROM commits GROUP BY author_email ORDER BY commits

## Comments



_No public comments on this page._