releases

5 rows where repo = 256834907

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), published_at (date)

id ▼ html_url author node_id tag_name target_commitish name draft prerelease created_at published_at body repo reactions mentions_count
25832422 https://github.com/dogsheep/dogsheep-photos/releases/tag/0.1a simonw 9599 MDc6UmVsZWFzZTI1ODMyNDIy 0.1a master 0.1a 0 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 simonw 9599 MDc6UmVsZWFzZTI1ODMyNDc1 0.2a master 0.2a 0 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 simonw 9599 MDc6UmVsZWFzZTI2MTk5MzQ4 0.3a master 0.3a 0 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 simonw 9599 MDc6UmVsZWFzZTI2Njk4NjYy 0.4 master 0.4 0 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 simonw 9599 MDc6UmVsZWFzZTI2ODczNjk4 0.4.1 master 0.4.1 0 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

CSV options: 

CREATE TABLE [releases] (
   [html_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [author] INTEGER REFERENCES [users]([id]),
   [node_id] TEXT,
   [tag_name] TEXT,
   [target_commitish] TEXT,
   [name] TEXT,
   [draft] INTEGER,
   [prerelease] INTEGER,
   [created_at] TEXT,
   [published_at] TEXT,
   [body] TEXT,
   [repo] INTEGER REFERENCES [repos]([id])
, [reactions] TEXT, [mentions_count] INTEGER);
CREATE INDEX [idx_releases_repo]
    ON [releases] ([repo]);
CREATE INDEX [idx_releases_author]
    ON [releases] ([author]);