{"repo":"dogsheep/github-to-sqlite","free":true,"listed":false,"github":"https://github.com/dogsheep/github-to-sqlite","clone":"git clone https://github.com/dogsheep/github-to-sqlite.git","description":"Save data from GitHub to a SQLite database","language":"Python","stars":471,"topics":["sqlite","github-api","datasette","dogsheep","datasette-io","datasette-tool"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"github-to-sqlite Save data from GitHub to a SQLite database. - Demo - How to install - Authentication - Fetching issues for a repository - Fetching pull requests for a repository - Fetching issue comments for a repository - Fetching commits for a repository - Fetching releases for a repository - Fetching tags for a repository - Fetching contributors to a repository - Fetching repos belonging to a user or organization - Fetching specific repositories - Fetching repos that have been starred by a user - Fetching users that have starred specific repos - Fetching GitHub Actions workflows - Scraping dependents for a repository - Fetching emojis - Making authenticated API calls Demo https://github-to-sqlite.dogsheep.net/ hosts a Datasette demo of a database created by running this tool against all of the repositories in the Dogsheep GitHub organization, plus the datasette and sqlite-utils repositories. How to install $ pip install github-to-sqlite Authentication Create a GitHub personal access token: https://github.com/settings/tokens Run this command and paste in your new token: $ github-to-sqlite auth This will create a file called auth.json in your current directory containing the required value. To save the file at a different path or filename, use the --auth=myauth.json option. As an alternative to using an auth.json file you can add your access token to an environment variable called GITHUB TOKEN . Fetching issues for a repository The issues command retrieves all of the issues","default_branch":null,"files":null,"tree":[],"storefront":"/r/dogsheep","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/dogsheep/github-to-sqlite/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."}