releases
22 rows where repo = 207052882
This data as json, CSV (advanced)
Suggested facets: target_commitish, created_at (date), published_at (date)
| id ▼ | html_url | node_id | tag_name | target_commitish | name | draft | author | prerelease | created_at | published_at | body | repo | reactions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19993251 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.1.1 | MDc6UmVsZWFzZTE5OTkzMjUx | 0.1.1 | master | 0.1.1 | 0 | simonw 9599 | 0 | 2019-09-14T19:19:33Z | 2019-09-14T19:42:08Z | * Fix bug in authentication handling code | github-to-sqlite 207052882 | |
| 19993751 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.2 | MDc6UmVsZWFzZTE5OTkzNzUx | 0.2 | master | 0.2 | 0 | simonw 9599 | 0 | 2019-09-14T21:31:17Z | 2019-09-14T21:32:34Z | * Added the `github-to-sqlite starred` command for retrieving starred repos, #1 | github-to-sqlite 207052882 | |
| 19993820 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.3 | MDc6UmVsZWFzZTE5OTkzODIw | 0.3 | master | 0.3 | 0 | simonw 9599 | 0 | 2019-09-14T21:49:27Z | 2019-09-14T21:50:01Z | * `license` is now extracted from the `repos` table into a separate `licenses` table with a foreign key, #2 | github-to-sqlite 207052882 | |
| 20031553 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.4 | MDc6UmVsZWFzZTIwMDMxNTUz | 0.4 | master | 0.4 | 0 | simonw 9599 | 0 | 2019-09-17T00:18:37Z | 2019-09-17T00:19:42Z | * Added `github-to-sqlite repos` command, #3 | github-to-sqlite 207052882 | |
| 20663605 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.5 | MDc6UmVsZWFzZTIwNjYzNjA1 | 0.5 | master | 0.5 | 0 | simonw 9599 | 0 | 2019-10-13T05:28:24Z | 2019-10-13T05:30:05Z | * New command: `github-to-sqlite issue-comments` for importing comments on issues - #7 * `github-to-sqlite issues` now accepts optional `--issue=1` argument * Fixed bug inserting users into already-created table with wrong columns - #6 | github-to-sqlite 207052882 | |
| 21354706 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.6 | MDc6UmVsZWFzZTIxMzU0NzA2 | 0.6 | master | 0.6 | 0 | simonw 9599 | 0 | 2019-11-11T05:31:46Z | 2019-11-11T05:34:06Z | - New `releases` command for fetching releases for a repo, #11 - Repository topics are now fetched by the `repos` command - `github-to-sqlite repos` now accepts multiple usernames - Command now works without `--auth` file (using anonymous API calls), #9 | github-to-sqlite 207052882 | |
| 24410477 | https://github.com/dogsheep/github-to-sqlite/releases/tag/0.7 | MDc6UmVsZWFzZTI0NDEwNDc3 | 0.7 | master | 0.7 | 0 | simonw 9599 | 0 | 2020-03-11T02:47:32Z | 2020-03-11T02:48:32Z | * New `github-to-sqlite commits my.db dogsheep/github-to-sqlite` command. #17 | github-to-sqlite 207052882 | |
| 24792596 | https://github.com/dogsheep/github-to-sqlite/releases/tag/1.0 | MDc6UmVsZWFzZTI0NzkyNTk2 | 1.0 | master | 1.0 | 0 | simonw 9599 | 0 | 2020-03-24T00:07:47Z | 2020-03-24T00:11:51Z | * Full-text search is configured for more tables. #19 * Release assets are now pulled out into a separate `assets` table. #15 * Now depends on sqlite-utils 2.x. #20 * Commit raw authors are now used to populate a new `raw_authors` able. #18 * New live demo at https://github-to-sqlite.dogsheep.net/ #13 * GitHub API errors are now raised as Pyton exceptions. #21 * Fixed bug running `commits` against repos with no commits. #22 | github-to-sqlite 207052882 | |
| 25583094 | https://github.com/dogsheep/github-to-sqlite/releases/tag/1.0.1 | MDc6UmVsZWFzZTI1NTgzMDk0 | 1.0.1 | master | 1.0.1 | 0 | simonw 9599 | 0 | 2020-04-16T17:41:47Z | 2020-04-16T18:09:29Z | * Fixed bug where repository topics were not being correctly fetched #26 * Live demo at https://github-to-sqlite.dogsheep.net/ now uses [datasette-render-markdown](https://github.com/simonw/datasette-render-markdown) and pulls in issue comments #25 | github-to-sqlite 207052882 | |
| 25640859 | https://github.com/dogsheep/github-to-sqlite/releases/tag/1.1 | MDc6UmVsZWFzZTI1NjQwODU5 | 1.1 | master | 1.1 | 0 | simonw 9599 | 0 | 2020-04-18T15:07:04Z | 2020-04-18T15:09:55Z | * New `github-to-sqlite contributors` command for fetching contributors to one or more repositories. #28 * The [live demo](https://github-to-sqlite.dogsheep.net/) now includes contributors, and pulls data from `simonw/datasette` and `simonw/sqlite-utils` in addition to the Dogsheep repositories. * The `organization` column in the `repos` table is now a foreign key to `users` as opposed to a big piece of JSON. #27 | github-to-sqlite 207052882 | |
| 25745723 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.0 | MDc6UmVsZWFzZTI1NzQ1NzIz | 2.0 | master | 2.0 | 0 | simonw 9599 | 0 | 2020-04-22T01:20:52Z | 2020-04-22T01:24:37Z | This release includes some backwards-incompatible schema changes: * The `milestone` and `assignee` columns on the `issues` table are now integers that are foreign keys to the `milestones` and `users` tables - previously they could be `text` columns instead. #30 * `milestones` now has an integer foreign key in the `creator` column, and a new `repo` column that is an integer foreign key to the `repos` table. #29 * The `repo` column in the `issues` table is now an integer foreign key to `repos`. Previously it was a string of the format `dogsheep/github-to-sqlite`. #31 | github-to-sqlite 207052882 | |
| 26067911 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.1 | MDc6UmVsZWFzZTI2MDY3OTEx | 2.1 | master | 2.1 | 0 | simonw 9599 | 0 | 2020-04-30T23:02:24Z | 2020-04-30T23:03:32Z | * New `github-to-sqlite scrape-dependents` command for importing the dependent repositories for a repo. #34 | github-to-sqlite 207052882 | |
| 26110434 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.2 | MDc6UmVsZWFzZTI2MTEwNDM0 | 2.2 | master | 2.2 | 0 | simonw 9599 | 0 | 2020-05-02T21:23:11Z | 2020-05-02T21:28:00Z | * New command: `github-to-sqlite stargazers` ([docs](https://github.com/dogsheep/github-to-sqlite/blob/2.2/README.md#fetching-users-that-have-starred-specific-repos)) for fetching all users who have starred the specified repositories. #4 * Added several views: [dependent_repos](https://github-to-sqlite.dogsheep.net/github/dependent_repos), [repos_starred](https://github-to-sqlite.dogsheep.net/github/repos_starred), [recent_releases](https://github-to-sqlite.dogsheep.net/github/recent_releases). #10 #12 #36 * Added indexes on all foreign key relationships. #35 * GitHub API token can now be read from `GITHUB_TOKEN` environment variable. #33 | github-to-sqlite 207052882 | |
| 28422716 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.3 | MDc6UmVsZWFzZTI4NDIyNzE2 | 2.3 | master | 2.3 | 0 | simonw 9599 | 0 | 2020-07-09T23:26:34Z | 2020-07-09T23:28:07Z | - New `github-to-sqlite repos my.db -r simonw/datasette` option for importing just specific repositories. #42 | github-to-sqlite 207052882 | |
| 28705938 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.4 | MDc6UmVsZWFzZTI4NzA1OTM4 | 2.4 | master | 2.4 | 0 | simonw 9599 | 0 | 2020-07-18T22:34:15Z | 2020-07-18T22:35:27Z | - New `github-to-sqlite tags github.db simonw/datasette` command for importing all tags for a repository. #43 | github-to-sqlite 207052882 | |
| 29822005 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.5 | MDc6UmVsZWFzZTI5ODIyMDA1 | 2.5 | main | 2.5 | 0 | simonw 9599 | 0 | 2020-08-18T15:05:50Z | 2020-08-18T15:08:20Z | - New `github-to-sqlite emojis` command for fetching emoji supported by GitHub. [Demo](https://github-to-sqlite.dogsheep.net/github/emojis). #47 - Added table of contents to README. - Switched to GitHub Actions for CI. - Switched default branch to `main` | github-to-sqlite 207052882 | |
| 31441882 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.6 | MDc6UmVsZWFzZTMxNDQxODgy | 2.6 | main | 2.6 | 0 | simonw 9599 | 0 | 2020-09-17T03:54:16Z | 2020-09-17T03:55:03Z | - New `github-to-sqlite get /gists` command for making authenticated API calls against any API path. #50 | github-to-sqlite 207052882 | |
| 32736481 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.7 | MDc6UmVsZWFzZTMyNzM2NDgx | 2.7 | main | 2.7 | 0 | simonw 9599 | 0 | 2020-10-19T05:36:32Z | 2020-10-19T05:38:34Z | - `github-to-sqlite repos` command now takes options `--readme` and `--readme-html`, which write the README or rendered HTML README into the `readme` or `readme_html` columns, respectively. #52 - New `--accept` option for `github-to-sqlite get`. #50 | github-to-sqlite 207052882 | |
| 34556308 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8 | MDc6UmVsZWFzZTM0NTU2MzA4 | 2.8 | main | 2.8 | 0 | simonw 9599 | 0 | 2020-11-30T01:40:37Z | 2020-11-30T01:41:38Z | - New command: `github-to-sqlite workflows`, for fetching the YAML configuration used by [GitHub Actions](https://github.com/features/actions) workflows and using it to populate new `workflows`, `jobs` and `steps` tables. #54 - New command: `github-to-sqlite pull-requests` - thanks, @adamjonas! #48 - `github-to-sqlite issues --issue` option can now be used multiple times. | github-to-sqlite 207052882 | |
| 34558928 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8.1 | MDc6UmVsZWFzZTM0NTU4OTI4 | 2.8.1 | main | 2.8.1 | 0 | simonw 9599 | 0 | 2020-11-30T04:16:41Z | 2020-11-30T04:18:21Z | - README now links to example database tables for each command. #56 - Added documentation for `github-to-sqlite releases`. | github-to-sqlite 207052882 | |
| 35374715 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8.2 | MDc6UmVsZWFzZTM1Mzc0NzE1 | 2.8.2 | main | 2.8.2 | 0 | simonw 9599 | 0 | 2020-12-16T19:20:36Z | 2020-12-16T19:21:58Z | - `--readme` now stores `null` if the README file does not exist, rather than throwing an error. #57 - README HTML is rewritten to fix broken internal links, e.g. for a table of contents. #58 | github-to-sqlite 207052882 | |
| 54439832 | https://github.com/dogsheep/github-to-sqlite/releases/tag/2.8.3 | RE_kwDODFdgUs4DPq-Y | 2.8.3 | main | 2.8.3 | 0 | simonw 9599 | 0 | 2021-12-01T19:36:52Z | 2021-12-01T19:37:19Z | - Minor documentation and inline help improvements. | github-to-sqlite 207052882 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [releases] (
[html_url] TEXT,
[id] INTEGER PRIMARY KEY,
[node_id] TEXT,
[tag_name] TEXT,
[target_commitish] TEXT,
[name] TEXT,
[draft] INTEGER,
[author] INTEGER REFERENCES [users]([id]),
[prerelease] INTEGER,
[created_at] TEXT,
[published_at] TEXT,
[body] TEXT,
[repo] INTEGER REFERENCES [repos]([id])
, [reactions] TEXT);
CREATE INDEX [idx_releases_repo]
ON [releases] ([repo]);
CREATE INDEX [idx_releases_author]
ON [releases] ([author]);