commits

Table actions

9 rows where "author_date" is on date 2020-03-20 sorted by committer_date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date (date)

author_date (date) 1 ✖

  • 2020-03-20 · 9 ✖
sha message author_date committer_date ▼ raw_author raw_committer repo author committer
d3887d1535c3edd59d3ebf6aea4495bacd82e59b Fix #34 by upgrading sqlite-utils 2020-03-20T19:20:22Z 2020-03-20T19:20:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
41221277af818552f766480120518b4a7bde6ec4 Release 0.17 2020-03-20T19:22:37Z 2020-03-20T19:22:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
bfcc1233f3f7b3f50b68971102a848adbcd5f53d user-timeline now takes --sql/--attach/--ids and multiple identifiers Refs #35, refs #8. Still needs documentation. 2020-03-20T20:12:51Z 2020-03-20T20:12:51Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
ad79a31a11de6c74cebe819fc6185b093a338e90 Fixed bug in #35 2020-03-20T20:14:37Z 2020-03-20T20:14:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
98729fd80a7b3f16d82752c6972c8d96c2f2f959 Docs for new user-timeline options, closes #35 2020-03-20T20:16:28Z 2020-03-20T20:16:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
2057fc2d2a9b86a2bd34ca4fc3bb1dde798bcd1a Release 0.18 2020-03-20T20:16:46Z 2020-03-20T20:16:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
b03674cc30991439c5320148a4a32de674f2896c Better progress bar formatting for user-timeline Closes #38 2020-03-20T22:36:46Z 2020-03-20T22:36:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
04c1d2cc54c71d4c6e795d174c7bb52f91739627 followers/friends --sql/--attach options, closes #36 2020-03-20T23:12:30Z 2020-03-20T23:12:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
810cb2af5a175837204389fd7f4b5721f8b325ab Release 0.19 2020-03-20T23:14:02Z 2020-03-20T23:14:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 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]);