releases
2 rows where repo = 167759846
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36411778 | https://github.com/simonw/markdown-to-sqlite/releases/tag/0.2 | simonw 9599 | MDc6UmVsZWFzZTM2NDExNzc4 | 0.2 | main | 0.2 | 0 | 0 | 2021-01-14T20:20:24Z | 2021-01-14T20:21:19Z | - Upgraded tests for latest dependencies - Switched CI to GitHub Actions | markdown-to-sqlite 167759846 | ||
| 44529864 | https://github.com/simonw/markdown-to-sqlite/releases/tag/1.0 | simonw 9599 | MDc6UmVsZWFzZTQ0NTI5ODY0 | 1.0 | main | 1.0 | 0 | 0 | 2021-06-13T04:15:14Z | 2021-06-13T04:17:15Z | - **BREAKING CHANGE**: The option order for this command is now `markdown-to-sqlite database.db tablename file1.md file2.md` - prior to version 1.0 the order was `markdown-to-sqlite file1.md file2.md database.db tablename`. This change was made for improved consistency with other `x-to-sqlite` tools. | markdown-to-sqlite 167759846 |
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]);