{"repo":"simonw/git-history","free":true,"listed":false,"github":"https://github.com/simonw/git-history","clone":"git clone https://github.com/simonw/git-history.git","description":"Tools for analyzing Git history using SQLite","language":"Python","stars":226,"topics":["git","sqlite"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"git-history Tools for analyzing Git history using SQLite For background on this project see git-history: a tool for analyzing scraped data collected using Git and SQLite. Measuring traffic during the Half Moon Bay Pumpkin Festival describes a project using this tool in detail. Installation Install this tool using uv : Or run it without installing it: Demos git-history-demos.datasette.io hosts three example databases created using this tool: - pge-outages shows a history of PG&E (the electricity supplier) outages, using data collected in simonw/pge-outages converted using pge-outages.sh - ca-fires shows a history of fires in California reported on fire.ca.gov/incidents, from data in simonw/ca-fires-history converted using ca-fires.sh The demos are deployed using Datasette on Google Cloud Run by this GitHub Actions workflow. Usage This tool can be run against a Git repository that holds a file that contains JSON, CSV/TSV or some other format and which has multiple versions tracked in the Git history. Read Git scraping: track changes over time by scraping to a Git repository to understand how you might create such a repository. The file command analyzes the history of an individual file within the repository, and generates a SQLite database table that represents the different versions of that file over time. The file is assumed to contain multiple objects - for example, the results of scraping an electricity outage map or a CSV file full of records. Assuming you have a file call","default_branch":null,"files":null,"tree":[],"storefront":"/r/simonw","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/simonw/git-history/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}