releases

9 rows where repo = 175321497

✎ View and edit SQL

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
16076041 https://github.com/simonw/csv-diff/releases/tag/0.1 simonw 9599 MDc6UmVsZWFzZTE2MDc2MDQx 0.1 master csv-diff: first release 0 0 2019-03-13T02:07:57Z 2019-03-13T02:12:08Z   csv-diff 175321497    
16077684 https://github.com/simonw/csv-diff/releases/tag/0.2 simonw 9599 MDc6UmVsZWFzZTE2MDc3Njg0 0.2 master csv-diff 0.2 0 0 2019-03-13T05:06:23Z 2019-03-13T05:09:03Z Changed the order of the human text output: it's now changed, added, removed I did this so that [this commit message](https://github.com/simonw/sf-tree-history/commit/ca66d9a5fdd632549301d249c487004a5b68abf2) would be more interesting to read once GitHub truncated it. csv-diff 175321497    
16607056 https://github.com/simonw/csv-diff/releases/tag/0.3.1 simonw 9599 MDc6UmVsZWFzZTE2NjA3MDU2 0.3.1 master csv-diff 0.3.1 0 0 2019-04-07T19:42:59Z 2019-04-07T19:46:22Z Added and deleted rows now display in a more human-friendly format than raw JSON: ``` $ csv-diff one.csv two.csv --key=id 1 row changed, 1 row added, 1 row removed 1 row changed Row 1 age: "4" => "5" 1 row added id: 3 name: Bailey age: 1 1 row removed id: 2 name: Pancakes age: 2 ``` Example commit here: https://github.com/simonw/sf-tree-history/commit/184efa - compare with https://github.com/simonw/sf-tree-history/commit/dd08cc which demonstrates the previous behaviour. csv-diff 175321497    
17019573 https://github.com/simonw/csv-diff/releases/tag/0.4 simonw 9599 MDc6UmVsZWFzZTE3MDE5NTcz 0.4 master csv-diff 0.4 0 0 2019-04-12T02:41:00Z 2019-04-27T18:27:55Z ` --singular` and `--plural` options, closes #2 csv-diff 175321497    
17019577 https://github.com/simonw/csv-diff/releases/tag/0.5 simonw 9599 MDc6UmVsZWFzZTE3MDE5NTc3 0.5 master csv-diff 0.5 0 0 2019-04-27T18:18:24Z 2019-04-27T18:29:19Z Handle columns being added and removed My [sf-tree-history project](https://github.com/simonw/sf-tree-history) unexpectedly broke because the columns in the CSV file changed. https://circleci.com/gh/simonw/sf-tree-history/110 `csv-diff` can now detect and handle this without crashing. Example commit: https://github.com/simonw/sf-tree-history/commit/781d7c4abf5d0022609a2b20cd3d5f5616826835 csv-diff 175321497    
17019592 https://github.com/simonw/csv-diff/releases/tag/0.5.1 simonw 9599 MDc6UmVsZWFzZTE3MDE5NTky 0.5.1 master csv-diff 0.5.1 0 0 2019-04-27T18:24:28Z 2019-04-27T18:30:33Z Tweaked output formatting of added/removed columns for better consistency with added/removed/changed rows. csv-diff 175321497    
24102156 https://github.com/simonw/csv-diff/releases/tag/0.6 simonw 9599 MDc6UmVsZWFzZTI0MTAyMTU2 0.6 master csv-diff 0.6 0 0 2020-02-29T19:56:36Z 2020-02-29T19:58:53Z - Support for TSV files. The tool will automatically detect if the input is CSV or TSV, or you can use the new `--format=tsv` or `--format=csv` options to over-ride the automatic detection. Thanks, Thomas Sibley for contributing this new feature. (#4) csv-diff 175321497    
32650127 https://github.com/simonw/csv-diff/releases/tag/1.0 simonw 9599 MDc6UmVsZWFzZTMyNjUwMTI3 1.0 main 1.0 0 0 2020-10-16T01:29:09Z 2020-10-16T01:31:05Z - New `--show-unchanged` option for outputting the unchanged values of rows that had at least one change. #9 - Fix for bug with column names that contained a `.` character. #7 - Fix for error when no `--key` provided - thanks, @MainHanzo. #3 - CSV delimiter sniffer now `;` delimited files. #6 csv-diff 175321497    
38459286 https://github.com/simonw/csv-diff/releases/tag/1.1 simonw 9599 MDc6UmVsZWFzZTM4NDU5Mjg2 1.1 main 1.1 0 0 2021-02-23T01:13:35Z 2021-02-23T01:14:25Z - Tool now also works against inputs that are JSON files consisting of a list of objects with identical keys, using `--format=json`. [#12](https://github.com/simonw/csv-diff/issues/12) csv-diff 175321497    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);