recent_releases (view)
5 rows where topics contains "pocket" and topics contains "sqlite"
This data as json, CSV (advanced)
Suggested facets: date (date), published_at (date), topics (array)
rowid | repo | release | date | body_markdown | published_at | topics |
---|---|---|---|---|---|---|
213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.3 | 2023-07-09 | - Progress bar now includes a count of the total number of items to fetch. - Now packaged using `pyproject.toml`. [#12](https://github.com/dogsheep/pocket-to-sqlite/issues/12) | 2023-07-09T01:15:03Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] |
213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.2 | 2022-08-22 | - `-a` is now the shortcut for `--auth` - previously it was duplicated as a shortcut for `--all`. Thanks, [Thomas Lockney](https://github.com/tlockney). [#7](https://github.com/dogsheep/pocket-to-sqlite/issues/7) - `pocket-to-sqlite auth` command now updates the existing `auth.json` file rather than over-writing it. [#10](https://github.com/dogsheep/pocket-to-sqlite/issues/10) | 2022-08-22T16:21:34Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] |
213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.1 | 2020-10-22 | - Tweaked dependencies for compatibility with new PyPI resolver. | 2020-10-22T00:08:24Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] |
213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2 | 2020-03-27 | * Defaults to only retrieving updated items, unless you use `--all`. #2 * Now displays a progress bar for initial data import and `--all`. * Data is now fetched 500 items at a time using API pagination. #1 * Now depends on `sqlite-utils 2.x`. * `auth.json` now uses `pocket_` prefix on each stored key. #4 | 2020-03-27T22:26:30Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] |
213286752 | https://github.com/dogsheep/pocket-to-sqlite | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.1 | 2019-10-07 | Initial release | 2019-10-07T05:18:20Z | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "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;