commits

Table actions

9 rows where "author_date" is on date 2020-09-30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, repo, author, committer, committer_date (date)

raw_author 2 ✖

author_date (date) 1 ✖

  • 2020-09-30 · 9 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
0f2626868bd635f44f2c04d57a5e8ced1229737e Much improved column menu display logic, refs #981 * Menu links now take into account existing querystring * No longer shows facet option for primary key columns * Conditionally displays sort/sort-desc if already sorted * Does not show facet option if already faceted by this 2020-09-30T23:01:19Z 2020-09-30T23:01:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
141544613f9e76ddb74eee38d6f8ee1e0e70f833 Extract out menu icon CSS, refs #981 2020-09-30T23:55:00Z 2020-09-30T23:55:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
64127a459349da956c447a51e419b4880fe7df1b Show not-blank rows column action, refs #981 2020-09-30T23:43:34Z 2020-09-30T23:43:34Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
765e8f0209a53507a00b77a20ef8e696a12e216e Close menu when clicked outside, refs #981 2020-09-30T23:21:44Z 2020-09-30T23:21:44Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7f4fe9190c1df7f0e72f9d7040327a43cf252c48 Configure code scanning, refs #183 2020-09-30T22:17:23Z 2020-09-30T22:17:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
97c71c3a3b2916bffa6081995ebccc2fa137c6d5 Fixed test for column sorting, refs #981 2020-09-30T21:51:10Z 2020-09-30T21:51:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ae1f7c3870001561392be85d2f4cd4d2aaf32d59 Column action menu for sort/faceting, refs #981 2020-09-30T21:43:39Z 2020-09-30T21:43:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
cada1017edcfa691c2314d7ad1b7c7576495317f Fixed incorrect example in README 2020-09-30T20:29:27Z 2020-09-30T20:29:27Z Shakeel Mahate d9a1cca675e8697c10ac5f4cbceac5ea7dc2a906 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 shakeel 19921 web-flow 19864447
fd0b00330fa9bc920185678b9dac8b97956138c4 Don't show cog on Link column, refs #981 Also show ascending option before descending option 2020-09-30T22:31:17Z 2020-09-30T22:31:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599

Advanced export

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

CSV options: 

CREATE TABLE [commits] (
   [sha] TEXT PRIMARY KEY,
   [message] TEXT,
   [author_date] TEXT,
   [committer_date] TEXT,
   [raw_author] TEXT REFERENCES [raw_authors]([id]),
   [raw_committer] TEXT REFERENCES [raw_authors]([id]),
   [repo] INTEGER REFERENCES [repos]([id]),
   [author] INTEGER REFERENCES [users]([id]),
   [committer] INTEGER REFERENCES [users]([id])
);
CREATE INDEX [idx_commits_committer]
                ON [commits] ([committer]);
CREATE INDEX [idx_commits_author]
                ON [commits] ([author]);
CREATE INDEX [idx_commits_repo]
                ON [commits] ([repo]);
CREATE INDEX [idx_commits_raw_committer]
                ON [commits] ([raw_committer]);
CREATE INDEX [idx_commits_raw_author]
                ON [commits] ([raw_author]);