commits

Table actions

8 rows where "author_date" is on date 2022-01-10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date (date)

author_date (date) 1 ✖

  • 2022-01-10 · 8 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
0142c2a3c2772cc370c734e7e6049e8cc2343a5f Improved test_create_index_analyze test, refs #378 2022-01-10T20:02:08Z 2022-01-10T20:02:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
046e5246c9698a6fc9901ca265ae47c68fcf5d13 Longer delay to hopefully get test to pass, refs #364 2022-01-10T04:51:07Z 2022-01-10T04:51:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
0d10402f7b0428c6bb275a106b628298c6d0201d table.create_index(..., analyze=True), refs #378 2022-01-10T20:00:24Z 2022-01-10T20:00:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
541f64ddb0513cd8fe7a84abc8ee218e36ef9ca6 db.analyze() and table.analyze() methods, refs #366 2022-01-10T19:48:38Z 2022-01-10T19:48:38Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
b6dad08a8389736b7e960cfe9bc719cfc21a98f5 Keep trying up to ten times, refs #364 2022-01-10T05:04:51Z 2022-01-10T05:04:51Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
cfb3f1235848d000ba8609bf84e634bf56ac8291 Only buffer input if --sniff, closes #364 2022-01-10T04:39:58Z 2022-01-10T04:39:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
d2a79d200f9071a86027365fa2a576865b71064f --nl now ignores blank lines, closes #376 2022-01-10T04:12:39Z 2022-01-10T04:12:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
e6ae643497803e51379f82881f4df2c734ef97f3 Did not need WAL after all, refs #364 2022-01-10T04:41:00Z 2022-01-10T04:41:00Z 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]);