commits

Table actions

15 rows where "author_date" is on date 2020-05-02

✎ View and edit SQL

This data as json, CSV (advanced)

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

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
10fb34de41aaa35681f08b5991540d65bfcf2e2e Option to auth with GITHUB_TOKEN env var, closes #33 2020-05-02T18:45:31Z 2020-05-02T18:45:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
143c3c5e2c5cf2c608742297d00cac6d499aa9ed Add dependent_repos view, closes #36 Also refs #37 2020-05-02T16:29:47Z 2020-05-02T16:29:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
3aed64240fdc5db06700a80304f15afd03d07172 --install=datasette-vega So I can plot graphs using stargazers from #4 2020-05-02T20:14:58Z 2020-05-02T20:14:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
45c1dee0c280ff49ae59c0105b29dada762a4d07 github-to-sqlite stargazers command, refs #4 2020-05-02T20:01:14Z 2020-05-02T20:01:14Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
4a0c4efba834ae43e2971969f69f75c32eab4f11 Indexes on foreign keys, closes #35 2020-05-02T18:26:15Z 2020-05-02T18:26:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
4fe69783b55465e7692a807d3a02a710f69c9c42 Release 2.2 Refs #36, #10, #12, #35, #33, #4 2020-05-02T21:23:11Z 2020-05-02T21:23:11Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
5c1d27fbf75ec01bd1cbb90e416818fbbf6d42c5 datasette-render-markdown>=1.1.2 https://github.com/simonw/datasette-render-markdown/issues/6 2020-05-02T08:34:17Z 2020-05-02T08:34:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
5c1df4e3063cf47229a305fbe75757a8d412a8af replace=True and ignore=True parameters for create_view(), closes #106 2020-05-02T16:02:04Z 2020-05-02T16:02:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
79541d3a6d71a9f888628686c3236eb0205bad35 Release 2.7.2, refs #106 2020-05-02T16:05:27Z 2020-05-02T16:05:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
841fd2de6ebbdf555b04cebafb51f9a7c8972652 Added recent_releases view, closes #12 2020-05-02T16:48:46Z 2020-05-02T16:48:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
98b93dc5371ae462b9d0c6509a7855d5d919917f Unit tests for stargazers, refs #4 2020-05-02T21:17:20Z 2020-05-02T21:21:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
a8eb56d4b7c7d36534b736be0db38122d4c788e4 Added repos_starred view, closes #10 2020-05-02T16:37:30Z 2020-05-02T16:37:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
ad4dd30d040f5d025a48cbbca1e0e4ba63233415 Documentation for stargazers command, refs #4 2020-05-02T21:21:16Z 2020-05-02T21:21:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
b3aa5f4313a5bc41c9e83f3a4778d4b0794ea4a8 Added 'not like' table filter, refs #750 2020-05-02T19:04:54Z 2020-05-02T19:04:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d00a53061556dc403c166b443d141c4e1adbd64a Add rowid column to recent_releases view, refs #12 2020-05-02T18:49:06Z 2020-05-02T18:49:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 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]);