git-history converts historical versions of structured files stored in Git into a SQLite database. It is particularly useful when a repository acts as a record of recurring snapshots, such as regularly collected JSON or CSV datasets.
Instead of opening old commits one at a time, users can query changes across the whole recorded history. The database records revisions and item-level changes, allowing questions about when a record appeared, which fields changed and how data evolved to be answered with SQL.
A structured file often represents a set of records rather than a single document. Tracking identifiers across commits preserves a meaningful history when rows are reordered or only one field changes. Once represented in SQLite, the data can be combined with other tables and inspected with familiar query tools.
This is free and open source software.
Key Features
- Extracts the history of a selected structured file from a Git repository.
- Handles JSON arrays and CSV or TSV documents, with controls for delimiters and encodings.
- Builds SQLite tables for commits, item versions and fields that changed over time.
- Can use one or more identifier columns to track individual records between successive revisions.
- Provides SQL-friendly views for inspecting the evolution of tracked records.
- Can work with a local repository or a specified remote repository.
- Offers conversion hooks for non-standard structured documents.
- Can ignore selected columns, choose a starting revision and skip commits where appropriate.
- Supports namespacing to keep several tracked file histories in one database.
Website: github.com/simonw/git-history
Support:
Developer: Simon Willison
License: Apache License 2.0
git-history is written in Python. Learn Python with our recommended free books and free tutorials.
Related Software
| Git Tools for Diff Review and Repository History | |
|---|---|
| difftastic | Structural diff tool that compares files based on their syntax |
| git-filter-repo | Quickly rewrite git repository history |
| onefetch | Displays information about a local Git repository |
| git-stats | Local git statistics including GitHub-like contributions calendars |
| diff-so-fancy | Attractive diffs with diff-highlight and more |
| BFG Repo-Cleaner | Clean unwanted data from Git repository history |
| git-delta | Viewer for git and diff output |
| gitlogue | Cinematic Git commit replay tool |
| git-quick-stats | Access various statistics in a git repository |
| git-who | Command-line Git analysis tool |
| git-standup | Recall what you did on the last working day |
| git-of-theseus | Analyze how a Git repo grows over time |
| git-sizer | Compute various size metrics for a git repository |
| diffnav | Git diff pager based on delta but with a file tree, à la GitHub |
| critique | Terminal UI for reviewing git diffs |
| git-big-picture | Visualization tool for Git repositories |
| hercules | Gain advanced insights from Git repository history |
| keifu | TUI that visualizes Git commit graphs |
| git-fame | Git repository collaborators sorted by contributions |
| needle | Highlights GitHub PRs |
| mergiraf | Git merge driver |
| git-history | Analyze Git history using SQLite |
| ec | Terminal Git mergetool |
| diffr | Word-by-word diff highlighting utility |
| git-scope | Fast TUI dashboard to view the git status of all your repositories |
| mamediff | Manages unstaged and staged Git diffs |
| deadbranch | Keep Git repositories tidy |
| GitTop | Lightweight desktop client for GitHub notifications |
| git-heatmap | Generates a customizable heatmap |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.