commits

Table actions

3 rows where "author_date" is on date 2019-05-09

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, committer_date (date)

committer 2 ✖

author_date (date) 1 ✖

  • 2019-05-09 · 3 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
b80b03ac9a9b8fc676ae17570b32f5439545198e datasette publish cloudrun --service=x, closes #457 2019-05-09T16:45:01Z 2019-05-09T16:45:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
bfa2ae0d16d39bb82dbe4da4f3fdc3c7f6257418 Promote Glitch instead of Datasette Publish Datasette Publish is currently broken due to Zeit API and platform changes. 2019-05-09T00:02:47Z 2019-05-09T00:02:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
f825e2012109247fa246e2b938f8174069e574f1 Run black and update docs for #457 2019-05-09T16:47:58Z 2019-05-09T16:48:13Z 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]);