commits

Table actions

5 rows where "author_date" is on date 2021-08-13

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_date (date) 1 ✖

  • 2021-08-13 · 5 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
2883098770fc66e50183b2b231edbde20848d4d6 Fixed config_dir mode, refs #1432 2021-08-13T05:10:07Z 2021-08-13T05:17:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
77f46297a88ac7e49dad2139410b01ee56d5f99c Rename --help-config to --help-settings, closes #1431 2021-08-13T01:01:57Z 2021-08-13T01:01:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
b966c44ef81bc6acbc4be95942afcf33b31e876f Minor markup fix 2021-08-13T11:32:40Z 2021-08-13T11:32:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
bbc4756f9e8180c7a40c57f8a35e39dee7be7807 Settings fix, refs #1433 2021-08-13T03:54:25Z 2021-08-13T03:54:25Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
ca4f83dc7b1d573b92a8921fca96d3ed490614c3 Rename config= to settings=, refs #1432 2021-08-13T01:10:36Z 2021-08-13T01:10:36Z 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]);