releases
5 rows where repo = 213286752
This data as json, CSV (advanced)
Suggested facets: target_commitish, created_at (date), published_at (date)
| id ▼ | html_url | node_id | tag_name | target_commitish | name | draft | author | prerelease | created_at | published_at | body | repo | reactions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20506896 | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.1 | MDc6UmVsZWFzZTIwNTA2ODk2 | 0.1 | master | 0.1 | 0 | simonw 9599 | 0 | 2019-10-07T05:07:37Z | 2019-10-07T05:18:20Z | Initial release | pocket-to-sqlite 213286752 | |
| 24950669 | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2 | MDc6UmVsZWFzZTI0OTUwNjY5 | 0.2 | master | 0.2 | 0 | simonw 9599 | 0 | 2020-03-27T22:23:16Z | 2020-03-27T22:26:30Z | * 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 | pocket-to-sqlite 213286752 | |
| 32891952 | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.1 | MDc6UmVsZWFzZTMyODkxOTUy | 0.2.1 | master | 0.2.1 | 0 | simonw 9599 | 0 | 2020-10-22T00:06:50Z | 2020-10-22T00:08:24Z | - Tweaked dependencies for compatibility with new PyPI resolver. | pocket-to-sqlite 213286752 | |
| 75010827 | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.2 | RE_kwDODLZ_YM4EeJML | 0.2.2 | main | 0.2.2 | 0 | simonw 9599 | 0 | 2022-08-22T16:18:16Z | 2022-08-22T16:21:34Z | - `-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) | pocket-to-sqlite 213286752 | |
| 111513749 | https://github.com/dogsheep/pocket-to-sqlite/releases/tag/0.2.3 | RE_kwDODLZ_YM4GpZCV | 0.2.3 | main | 0.2.3 | 0 | simonw 9599 | 0 | 2023-07-09T01:14:06Z | 2023-07-09T01:15:03Z | - 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) | pocket-to-sqlite 213286752 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [releases] (
[html_url] TEXT,
[id] INTEGER PRIMARY KEY,
[node_id] TEXT,
[tag_name] TEXT,
[target_commitish] TEXT,
[name] TEXT,
[draft] INTEGER,
[author] INTEGER REFERENCES [users]([id]),
[prerelease] INTEGER,
[created_at] TEXT,
[published_at] TEXT,
[body] TEXT,
[repo] INTEGER REFERENCES [repos]([id])
, [reactions] TEXT);
CREATE INDEX [idx_releases_repo]
ON [releases] ([repo]);
CREATE INDEX [idx_releases_author]
ON [releases] ([author]);