recent_releases (view)
3 rows where "date" is on date 2019-10-16 sorted by release
This data as json, CSV (advanced)
Suggested facets: rowid, repo, topics, published_at (date), topics (array)
rowid | repo | release ▼ | date | body_markdown | published_at | topics |
---|---|---|---|---|---|---|
205429375 | https://github.com/dogsheep/swarm-to-sqlite | https://github.com/dogsheep/swarm-to-sqlite/releases/tag/0.2 | 2019-10-16 | * Added --since option, closes #3 | 2019-10-16T20:40:55Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.11 | 2019-10-16 | * Added `--since_id` and `--since` to `user-timeline` command, refs #20 * `--since` and `--since_id` options for `home-timeline`, closes #19 * `import` command now works on files and directories, closes #22 | 2019-10-16T19:38:42Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
206156866 | https://github.com/dogsheep/twitter-to-sqlite | https://github.com/dogsheep/twitter-to-sqlite/releases/tag/0.11.1 | 2019-10-16 | * Fix bugs running `home-timeline --since` from scratch. If tables were missing, script would throw an error. | 2019-10-16T22:31:51Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] |
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;