commits

Table actions

9 rows where "author_date" is on date 2020-09-24 sorted by raw_author

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_date (date) 1 ✖

  • 2020-09-24 · 9 ✖
sha message author_date committer_date raw_author ▼ raw_committer repo author committer
9a6d0dce282e7fb58c5610e24c74098c923abfdc datasette-json-html as render_cell example 2020-09-24T05:25:06Z 2020-09-24T05:25:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
94fc62857ee2655a21d85f6dae84b67bbfa5956d Demonstrate extract= creates correct foreign keys Closes #138 2020-09-24T22:46:46Z 2020-09-24T22:46:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
cda559f8353ea65d7db031fa57ea25b515b5fa24 Include --column-order in combined example, refs #176 2020-09-24T20:33:19Z 2020-09-24T20:33:19Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
a57acf84f77aac01fd6b8aaa2ce089145ff3c3e7 Release 2.21 Refs #172, #175, #176, #177 2020-09-24T16:44:30Z 2020-09-24T16:44:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
5a63b9e88c5887432eb1d7df39f304ea55038437 Simplify drop-foreign-key, and drop_foreign_keys, closes #177 2020-09-24T16:19:07Z 2020-09-24T16:19:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
d13c123100bddbe53b56cad6f9f0e7a0e50c4e0d sqlite-utils transform --column-order option, closes #176 2020-09-24T16:11:53Z 2020-09-24T16:11:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
725f206949441e4679ef4d1c5995c1cf7015a83e Documentation for .transform(column_order=), closes #175 2020-09-24T16:00:50Z 2020-09-24T16:00:50Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
022cdd97a9ddab1a152e23e1e1c42e78c1ed0fa9 Much, much faster extract() implementation Takes my test down from ten minutes to four seconds! * Removed unnecessary update() optimization * Added column_order= to .transform() and .transform_sql() * Tests for reusing lookup table in extract() Closes #172 2020-09-24T15:43:55Z 2020-09-24T15:43:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
5eb14d1c1f2e76d67fb70128a61ad22a7b38cd6a Added several missing 'return self' to support chaining 2020-09-24T14:51:36Z 2020-09-24T14:51:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 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]);