commits

Table actions

5 rows where "author_date" is on date 2020-03-22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo, committer_date (date)

author_date (date) 1 ✖

  • 2020-03-22 · 5 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
236aa065b2ecfbe5a77870689bae432b89a48b23 "sort" and "sort_desc" metadata properties, closes #702 2020-03-22T02:28:35Z 2020-03-22T02:28:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
3d656f4b31e95047e0ffc1eaa7417a303ccce3c1 Updated documentation formatting 2020-03-22T01:31:49Z 2020-03-22T01:31:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a498d0fe6590f9bdbc4faf9e0dd5faeb3b06002c Fix bug with over-riding default sort, closes #702 2020-03-22T02:40:29Z 2020-03-22T02:40:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c8697b3e4ef044412209b52c70548fedbcb346c7 clarification in README 2020-03-22T15:44:45Z 2020-03-22T15:44:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 hacker-news-to-sqlite 248903544 simonw 9599 simonw 9599
e1a817411a20e3120943ee407503e53a7445c0db Bump to click 7.1.1 to fix flaky tests 2020-03-22T01:47:51Z 2020-03-22T01:47:51Z 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]);