recent_releases (view)
5 rows where topics = "["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"]"
This data as json, CSV (advanced)
Suggested facets: date, date (date), published_at (date), topics (array)
| rowid | repo | release | date | body_markdown | published_at | topics |
|---|---|---|---|---|---|---|
| 256834907 | https://github.com/dogsheep/dogsheep-photos | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.4.1 | 2020-05-25 | - 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 | 2020-05-25T20:13:23Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] |
| 256834907 | https://github.com/dogsheep/dogsheep-photos | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.4 | 2020-05-20 | - 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 | 2020-05-20T04:24:28Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] |
| 256834907 | https://github.com/dogsheep/dogsheep-photos | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.3a | 2020-05-05 | * 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 | 2020-05-05T20:17:00Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] |
| 256834907 | https://github.com/dogsheep/dogsheep-photos | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.2a | 2020-04-24 | * Only upload photos not already in S3. #9 | 2020-04-24T00:44:21Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] |
| 256834907 | https://github.com/dogsheep/dogsheep-photos | https://github.com/dogsheep/dogsheep-photos/releases/tag/0.1a | 2020-04-24 | * First alpha release | 2020-04-24T00:40:57Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW recent_releases AS select repos.rowid as rowid, repos.html_url as repo, releases.html_url as release, substr(releases.published_at, 0, 11) as date, releases.body as body_markdown, releases.published_at, coalesce(repos.topics, '[]') as topics from releases join repos on repos.id = releases.repo order by releases.published_at desc;