commits

Table actions

7 rows where "author_date" is on date 2019-01-28 sorted by committer

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo, committer_date (date)

author_date (date) 1 ✖

  • 2019-01-28 · 7 ✖
sha message author_date committer_date raw_author raw_committer repo author committer ▼
b5dd83981a7dbff571284d4d90a950c740245b05 Export option: _shape=array&_nl=on for newline-delimited JSON 2019-01-28T01:40:23Z 2019-01-28T01:40:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
79a0f9cc96788f615810dced89f79b8e3ccc51ed Releasing 0.9 2019-01-28T06:34:33Z 2019-01-28T06:34:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
50589f8523751191559e8d812c2ee0889da06e50 CLI insert tool now uses generators, closes #7 Also cleaned up the logic so we commit rows in batches too. 2019-01-28T06:26:45Z 2019-01-28T06:26:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f0afa5646b596885a9c030f00596d9228ad23994 insert_all() now accepts generator, closes #7 2019-01-28T06:12:18Z 2019-01-28T06:12:18Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
225cf7299f0a9ef7c37caac656a8e0d8731c6cad Docs example chaining --nl together 2019-01-28T02:28:02Z 2019-01-28T02:28:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
a22607699400468aa9c50faa47d0058663d80741 Fixed RST bug 2019-01-28T02:18:55Z 2019-01-28T02:18:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
5309c5c7755818323a0f5353bad0de98ecc866be sqlite-utils insert ... --nl option, closes #6 2019-01-28T02:17:38Z 2019-01-28T02:17:38Z 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]);