commits

Table actions

7 rows where "author_date" is on date 2021-02-18

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_date (date) 1 ✖

  • 2021-02-18 · 7 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
2c1b9f2445d0ca4ca9f30a1433b7cde8cc0f42a2 Create FUNDING.yml 2021-02-18T18:22:43Z 2021-02-18T18:22:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
36a44bffbf5185a58fcd2548e8de94e9490a7aea Validation for --port, closes #1226 2021-02-18T18:05:27Z 2021-02-18T18:05:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
4df548e7668b5b21d64a267964951e67894f4712 Update documentation, refs #1226 2021-02-18T18:27:12Z 2021-02-18T18:32:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
5af2b99111abd4dcf99a197ca96da036e8384fa4 Create FUNDING.yml 2021-02-18T18:22:01Z 2021-02-18T18:22:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
6f41c8a2bef309a66588b2875c3e24d26adb4850 --crossdb option for joining across databases (#1232) * Test for cross-database join, refs #283 * Warn if --crossdb used with more than 10 DBs, refs #283 * latest.datasette.io demo of --crossdb joins, refs #283 * Show attached databases on /_memory page, refs #283 * Documentation for cross-database queries, refs #283 2021-02-18T22:09:12Z 2021-02-18T22:09:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
73bed175631a79e13a521eee82f8451dd0477eb3 Corrected documentation for datasette.urls.static_plugins 2021-02-18T23:25:01Z 2021-02-18T23:25:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
d2d53a5559f3014cccba2cba7e1eab1e5854c759 New :issue: Sphinx macro, closes #1227 2021-02-18T01:20:15Z 2021-02-18T01:20:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 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]);