commits

Table actions

6 rows where "author_date" is on date 2021-02-19 sorted by committer_date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo, committer_date (date)

author_date (date) 1 ✖

  • 2021-02-19 · 6 ✖
sha message author_date committer_date ▼ raw_author raw_committer repo author committer
a4239309b1ddf86b48f329279447a06cf0800aa7 Bump Dockerfile to using Python 3.7.10, closes #1235 2021-02-19T01:48:20Z 2021-02-19T01:48:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
cb8a293bd7ec54e868d702871b39c550465c0521 Release 0.55 Refs #1205, #1207, #1214, #1221, #1226, #1227, #1232, #1235 2021-02-19T02:01:06Z 2021-02-19T02:01:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
999f099cbe267554f679963a3964042f09c1c159 db.attach(alias, filepath) method, closes #113 Will also be useful for #236 2021-02-19T04:56:32Z 2021-02-19T04:56:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
2ba558888131b58ed13bccea29e0db20c9c01087 sqlite-utils --attach option, closes #236 2021-02-19T05:08:39Z 2021-02-19T05:08:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
806c21044ac8d31da35f4c90600e98115aade7c6 Release 3.6 Refs #113, #236 2021-02-19T05:18:02Z 2021-02-19T05:18:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
1f9cca33b41cc93357f9eb347d70ff20b2a4d0d5 Resizable SQL editor using cm-resize, refs #1236 2021-02-19T23:47:52Z 2021-02-19T23:47:52Z 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]);