releases
5 rows where repo = 511787166
This data as json, CSV (advanced)
Suggested facets: prerelease, created_at (date), published_at (date)
| id ▼ | html_url | author | node_id | tag_name | target_commitish | name | draft | prerelease | created_at | published_at | body | repo | reactions | mentions_count |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71538641 | https://github.com/simonw/sqlite-comprehend/releases/tag/0.1a0 | simonw 9599 | RE_kwDOHoFAns4EQ5fR | 0.1a0 | main | 0.1a0 | 0 | 1 | 2022-07-08T06:29:13Z | 2022-07-08T06:30:05Z | - Initial prototype. [#1](https://github.com/simonw/sqlite-comprehend/issues/1) | sqlite-comprehend 511787166 | ||
| 71598985 | https://github.com/simonw/sqlite-comprehend/releases/tag/0.1 | simonw 9599 | RE_kwDOHoFAns4ERIOJ | 0.1 | main | 0.1 | 0 | 0 | 2022-07-08T19:58:49Z | 2022-07-08T20:01:38Z | - Documentation, in the [README](https://github.com/simonw/sqlite-comprehend/blob/main/README.md). [#3](https://github.com/simonw/sqlite-comprehend/issues/3) - New schema design, with a separate `comprehend_entities` table. [#4](https://github.com/simonw/sqlite-comprehend/issues/4) - Running the command multiple times will not re-submit rows that have already been processed. [#7](https://github.com/simonw/sqlite-comprehend/issues/7) - Errors from the Comprehend API are now logged to standard error. [#8](https://github.com/simonw/sqlite-comprehend/issues/8) | sqlite-comprehend 511787166 | ||
| 71737577 | https://github.com/simonw/sqlite-comprehend/releases/tag/0.2 | simonw 9599 | RE_kwDOHoFAns4ERqDp | 0.2 | main | 0.2 | 0 | 0 | 2022-07-11T19:11:57Z | 2022-07-11T19:13:02Z | - `sqlite-comprehend entities --strip-tags` option for stripping HTML tags before sending content to the entity extraction API. [#9](https://github.com/simonw/sqlite-comprehend/issues/9) | sqlite-comprehend 511787166 | ||
| 71738941 | https://github.com/simonw/sqlite-comprehend/releases/tag/0.2.1 | simonw 9599 | RE_kwDOHoFAns4ERqY9 | 0.2.1 | main | 0.2.1 | 0 | 0 | 2022-07-11T19:32:54Z | 2022-07-11T19:33:28Z | - Fixed bug where commands failed to be correctly registered on Linux systems. [#11](https://github.com/simonw/sqlite-comprehend/issues/11) | sqlite-comprehend 511787166 | ||
| 71808412 | https://github.com/simonw/sqlite-comprehend/releases/tag/0.2.2 | simonw 9599 | RE_kwDOHoFAns4ER7Wc | 0.2.2 | main | 0.2.2 | 0 | 0 | 2022-07-12T14:21:22Z | 2022-07-12T14:21:43Z | - Improvements to the documentation. | sqlite-comprehend 511787166 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [releases] (
[html_url] TEXT,
[id] INTEGER PRIMARY KEY,
[author] INTEGER REFERENCES [users]([id]),
[node_id] TEXT,
[tag_name] TEXT,
[target_commitish] TEXT,
[name] TEXT,
[draft] INTEGER,
[prerelease] INTEGER,
[created_at] TEXT,
[published_at] TEXT,
[body] TEXT,
[repo] INTEGER REFERENCES [repos]([id])
, [reactions] TEXT, [mentions_count] INTEGER);
CREATE INDEX [idx_releases_repo]
ON [releases] ([repo]);
CREATE INDEX [idx_releases_author]
ON [releases] ([author]);