recent_releases (view)
4 rows where "published_at" is on date 2020-09-03
This data as json, CSV (advanced)
Suggested facets: date (date), topics (array)
rowid | repo | release | date | body_markdown | published_at | topics |
---|---|---|---|---|---|---|
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4.1 | 2020-09-03 | - Fixed support for [advanced FTS query syntax](https://www.sqlite.org/fts5.html#full_text_query_syntax). #13 | 2020-09-03T21:41:52Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4 | 2020-09-03 | - Working faceted search interface at `/-/beta` #3 - `is_public` column for filtering between public and private data. #11 - New `received` category. #10 | 2020-09-03T21:11:28Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4a1 | 2020-09-03 | - Added `received` category. #10 - New `is_public` column. #11 | 2020-09-03T18:03:50Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
197431109 | https://github.com/dogsheep/dogsheep-beta | https://github.com/dogsheep/dogsheep-beta/releases/tag/0.4a0 | 2020-09-03 | - Incomplete preview of the `/-/beta` search interface. #3 #9 | 2020-09-03T03:54:23Z | ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] |
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;