releases
5 rows where repo = 175550127
This data as json, CSV (advanced)
Suggested facets: target_commitish, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18169270 | https://github.com/simonw/yaml-to-sqlite/releases/tag/0.2 | simonw 9599 | MDc6UmVsZWFzZTE4MTY5Mjcw | 0.2 | master | 0.2 | 0 | 0 | 2019-06-23T22:55:32Z | 2019-06-23T22:55:50Z | Better README | yaml-to-sqlite 175550127 | ||
| 21310374 | https://github.com/simonw/yaml-to-sqlite/releases/tag/0.2.1 | simonw 9599 | MDc6UmVsZWFzZTIxMzEwMzc0 | 0.2.1 | master | 0.2.1 | 0 | 0 | 2019-11-08T06:43:41Z | 2019-11-08T06:46:02Z | * Better help for `--pk` | yaml-to-sqlite 175550127 | ||
| 21864644 | https://github.com/simonw/yaml-to-sqlite/releases/tag/0.3 | simonw 9599 | MDc6UmVsZWFzZTIxODY0NjQ0 | 0.3 | master | 0.3 | 0 | 0 | 2019-11-29T20:06:25Z | 2019-11-29T20:07:05Z | * Now handles nested objects that contain dates, #1 | yaml-to-sqlite 175550127 | ||
| 34950211 | https://github.com/simonw/yaml-to-sqlite/releases/tag/0.3.1 | simonw 9599 | MDc6UmVsZWFzZTM0OTUwMjEx | 0.3.1 | master | 0.3.1 | 0 | 0 | 2020-12-07T21:11:08Z | 2020-12-07T21:12:55Z | - Updated for latest `sqlite-utils` library - Fixed bug where import failed if user did not provide a `--pk` option | yaml-to-sqlite 175550127 | ||
| 44530052 | https://github.com/simonw/yaml-to-sqlite/releases/tag/1.0 | simonw 9599 | MDc6UmVsZWFzZTQ0NTMwMDUy | 1.0 | main | 1.0 | 0 | 0 | 2021-06-13T04:44:00Z | 2021-06-13T04:45:52Z | - New feature: `yaml-to-sqlite dogs.db dogs.yaml --single-column=name` can be used to import YAML files consisting of a list of items into a single table with a single primary key column. [#5](https://github.com/simonw/yaml-to-sqlite/issues/5) - Importing YAML files with new columns will now alter the table to add those columns. [#4](https://github.com/simonw/yaml-to-sqlite/issues/4) | yaml-to-sqlite 175550127 |
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]);