commits

Table actions

2 rows where "author_date" is on date 2019-04-20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: author_date (date)

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
2b11948d7c5f4548325c941d92eaf428852a19d8 New ConnectedDatabase.mtime_ns property I plan to use this for some clever table count caching tricks 2019-04-20T17:50:45Z 2019-04-20T17:50:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
31f36e1b97ccc3f4387c80698d018a69798b6228 Added some guidelines Mainly to remind me that master needs to be releasable at all times! 2019-04-20T18:32:40Z 2019-04-20T18:32:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447

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