commits

Table actions

8 rows where "author_date" is on date 2020-04-17

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_date (date) 1 ✖

  • 2020-04-17 · 8 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
279f2ba0652221bb4a542603f0846e9754e1632f New command: twitter-to-sqlite lists, refs #43 2020-04-17T22:02:59Z 2020-04-17T22:02:59Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
2ab62bcd54f8aa73a7a77d209133f0da6c73f3ea New columns= parameter for over-riding column types, closes #100 2020-04-17T23:53:25Z 2020-04-17T23:53:25Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
537587823a81c96b863c5db9cddae89c4fbec4aa Release 0.21 2020-04-17T23:44:31Z 2020-04-17T23:44:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
73947d50115257b15e4a687ddf41cbf60ba942cb Better error for non-existing user, closes #37 2020-04-17T23:43:35Z 2020-04-17T23:43:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
7ce07705ed5ba4f54015cb1a5cea4b97c54bd45f Improved README. Fixes #101 2020-04-17T23:59:47Z 2020-04-17T23:59:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
9d61313a98569f693dd1ec9ce516b28d0f931b8d Fix for TypeError, closes #42 2020-04-17T23:34:34Z 2020-04-17T23:34:34Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 twitter-to-sqlite 206156866 simonw 9599 simonw 9599
cd146bbbfa43c501adb9edd57f231c653aaa2397 Fixed RST underlines 2020-04-17T17:58:08Z 2020-04-17T17:58:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
faefa30fff03a9e88fc60e646ea6e7be97646dc1 Handle blank tweet[source], closes #44 2020-04-17T19:29:58Z 2020-04-17T19:29:58Z 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]);