releases
5 rows where repo = 256834907
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25832422 | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.1a | MDc6UmVsZWFzZTI1ODMyNDIy | 0.1a | master | 0.1a | 0 | simonw 9599 | 0 | 2020-04-19T00:15:55Z | 2020-04-24T00:40:57Z | * First alpha release | dogsheep-photos 256834907 | |
| 25832475 | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.2a | MDc6UmVsZWFzZTI1ODMyNDc1 | 0.2a | master | 0.2a | 0 | simonw 9599 | 0 | 2020-04-24T00:42:43Z | 2020-04-24T00:44:21Z | * Only upload photos not already in S3. #9 | dogsheep-photos 256834907 | |
| 26199348 | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.3a | MDc6UmVsZWFzZTI2MTk5MzQ4 | 0.3a | master | 0.3a | 0 | simonw 9599 | 0 | 2020-05-05T20:16:53Z | 2020-05-05T20:17:00Z | * Upload photos to S3 in a thread pool #11 * New `--dry-run` option to `upload` command * New `photos-to-sqlite apple-photos` command for importing Apple Photos metadata #1 * Apple Photos quality scores are imported into `apple_photos_scores` table #15 * Machine learning labels imported from Apple Photos into `labels` table #16 | dogsheep-photos 256834907 | |
| 26698662 | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.4 | MDc6UmVsZWFzZTI2Njk4NjYy | 0.4 | master | 0.4 | 0 | simonw 9599 | 0 | 2020-05-20T04:22:26Z | 2020-05-20T04:24:28Z | - Renamed this project to `dogsheep-photos`. #26 - `apple-photos` command now works even if you haven't yet run `upload`. #19 - `--image-url-prefix` and `--image-url-suffix` options to `apple-photos`. #24 - New `create-subset` command. #23 | dogsheep-photos 256834907 | |
| 26873698 | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.4.1 | MDc6UmVsZWFzZTI2ODczNjk4 | 0.4.1 | master | 0.4.1 | 0 | simonw 9599 | 0 | 2020-05-25T20:11:20Z | 2020-05-25T20:13:23Z | - Documentation now explains how to use this with the [datasette-media](https://github.com/simonw/datasette-media), [datasette-json-html](https://github.com/simonw/datasette-json-html) and [datasette-template-sql](https://github.com/simonw/datasette-template-sql) plugins. #20 | dogsheep-photos 256834907 |
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]);