releases
9 rows where repo = 427128866
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53209605 | https://github.com/simonw/git-history/releases/tag/0.1 | simonw 9599 | RE_kwDOGXV4Is4DK-oF | 0.1 | main | 0.1 | 0 | 0 | 2021-11-12T00:56:10Z | 2021-11-12T00:56:49Z | - Initial release. `git-history file db.db filepath.json` command, see README for details. | git-history 427128866 | ||
| 53212955 | https://github.com/simonw/git-history/releases/tag/0.2 | simonw 9599 | RE_kwDOGXV4Is4DK_cb | 0.2 | main | 0.2 | 0 | 0 | 2021-11-12T02:38:08Z | 2021-11-12T02:40:45Z | - `--csv` option can now be used to process CSV or TSV data - the dialect is detected automatically. [#6](https://github.com/simonw/git-history/issues/6) - Implemented reserved column names: `id`, `item`, `version` and `commit`. If your data includes any of these column names they will be renamed to `id_`, `item_`, `version_` and `commit`_ respectively. [#8](https://github.com/simonw/git-history/issues/8) | git-history 427128866 | ||
| 53213250 | https://github.com/simonw/git-history/releases/tag/0.2.1 | simonw 9599 | RE_kwDOGXV4Is4DK_hC | 0.2.1 | main | 0.2.1 | 0 | 0 | 2021-11-12T02:50:23Z | 2021-11-12T02:50:49Z | - Improved usage documentation in the README | git-history 427128866 | ||
| 53215121 | https://github.com/simonw/git-history/releases/tag/0.3 | simonw 9599 | RE_kwDOGXV4Is4DK_-R | 0.3 | main | 0.3 | 0 | 0 | 2021-11-12T03:38:20Z | 2021-11-12T03:39:34Z | - `git-history file` command now shows a progress bar, unless run with the `--silent` option. [#9](https://github.com/simonw/git-history/issues/9) | git-history 427128866 | ||
| 53221725 | https://github.com/simonw/git-history/releases/tag/0.3.1 | simonw 9599 | RE_kwDOGXV4Is4DLBld | 0.3.1 | main | 0.3.1 | 0 | 0 | 2021-11-12T07:29:39Z | 2021-11-12T07:30:25Z | - Fixed bug where files with a `"rowid"` column would fail to import correctly. [#10](https://github.com/simonw/git-history/issues/10) | git-history 427128866 | ||
| 53785795 | https://github.com/simonw/git-history/releases/tag/0.4 | simonw 9599 | RE_kwDOGXV4Is4DNLTD | 0.4 | main | 0.4 | 0 | 0 | 2021-11-21T05:05:38Z | 2021-11-21T05:08:43Z | - Major changes to the database schema. Foreign keys now use integer primary key IDs rather than using lengthy item or commit hashes, which reduces the database size for large repositories by almost half. [#12](https://github.com/simonw/git-history/issues/12) - Python generators can now be used in `--convert` functions. [#16](https://github.com/simonw/git-history/issues/16) - Reserved columns are now marked by an underscore prefix, for example `_id` and `_commit`. [#14](https://github.com/simonw/git-history/issues/14) | git-history 427128866 | ||
| 54549932 | https://github.com/simonw/git-history/releases/tag/0.5 | simonw 9599 | RE_kwDOGXV4Is4DQF2s | 0.5 | main | 0.5 | 0 | 0 | 2021-12-03T04:04:40Z | 2021-12-03T04:05:15Z | - The `item_version` table now only records values that have changed since the previous item version. A new `item_changed` many-to-many table records exactly which columns were changed in which item version, to compensate for ambiguous `null` values. [#21](https://github.com/simonw/git-history/issues/21) - New `--full-versions` option for storing full copies of each version instead of storing just the columns that have changed. - Major backwards-incompatible schema changes - see README for details of the new schema. - New `--dialect` option for specifying a CSV dialect if you don't want to use auto-detection. [#27](https://github.com/simonw/git-history/issues/27) - The history for multiple files can now be stored in the same database, using the new `--namespace` option. [#13](https://github.com/simonw/git-history/issues/13) - `--skip HASH`, `--start-at HASH` and `--start-after HASH` options for skipping specific Git commits or starting processing at or after a specific hash. [#26](https://github.com/simonw/git-history/issues/26), [#28](https://github.com/simonw/git-history/issues/28) | git-history 427128866 | ||
| 54812967 | https://github.com/simonw/git-history/releases/tag/0.6 | simonw 9599 | RE_kwDOGXV4Is4DRGEn | 0.6 | main | 0.6 | 0 | 0 | 2021-12-07T17:14:23Z | 2021-12-07T17:15:07Z | - Fixed critical bug where columns were incorrectly recorded as consistently toggling between null and their current value. [#33](https://github.com/simonw/git-history/issues/33) - Documentation now includes links to live examples of databases created using this tool. [#30](https://github.com/simonw/git-history/issues/30) - `--wal` option for turning on SQLite WAL mode - useful if you want to safely run queries against the database file while it is still being built. [#31](https://github.com/simonw/git-history/issues/31) - Fixed bug where list and dict values were not correctly compared for equality. [#32](https://github.com/simonw/git-history/issues/32) - The `item_version_detail` SQL view now includes a `_changed_column` JSON array of column names that changed in each version. [#37](https://github.com/simonw/git-history/issues/37) - Nested packages such as `--import xml.etree.ElementTree` can now be imported. [#39](https://github.com/simonw/git-history/issues/39) - `item_version._item` is now an indexed column. [#38](https://github.com/simonw/git-history/issues/38) | git-history 427128866 | ||
| 54903203 | https://github.com/simonw/git-history/releases/tag/0.6.1 | simonw 9599 | RE_kwDOGXV4Is4DRcGj | 0.6.1 | main | 0.6.1 | 0 | 0 | 2021-12-08T20:27:34Z | 2021-12-08T20:29:19Z | - Fixed bug where databases containing multiple file histories created using the `--namespace` option could have later commits applied to them in subsequent runs. [#42](https://github.com/simonw/git-history/issues/42), [#43](https://github.com/simonw/git-history/issues/43) | git-history 427128866 |
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]);