commits

Table actions

10 rows where "author_date" is on date 2020-06-12 sorted by repo

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_date (date) 1 ✖

  • 2020-06-12 · 10 ✖
sha message author_date committer_date raw_author raw_committer repo ▼ author committer
b906030235efbdff536405d66078f4868ce0d3bd Release Datasette 0.44 Refs #395, #519, #576, #699, #706, #774, #777, #781, #784, #788, #790, #797, #798, #800, #802, #804, #819, #822, #825, #826, #827, #828, #829, #830, #833, #836, #837, #839 Closes #806. 2020-06-12T01:19:30Z 2020-06-12T01:19:30Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
9ae0d483ead93c0832142e5dc85959ae3c8f73ea Get "$file": "../path" mechanism working again, closes #839 2020-06-12T00:48:20Z 2020-06-12T00:48:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
793a52b31771280a6c8660efb9e48b9b763477ff Link to datasett-auth-tokens and datasette-permissions-sql in docs, refs #806 2020-06-12T00:43:51Z 2020-06-12T00:43:51Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1d2e8e09a00a4b695317627483f352464ea8a105 Some last touches to the 0.44 release notes, refs #806 2020-06-12T00:33:16Z 2020-06-12T00:33:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
308bcc8805236b8eb5a08d8045c84f68bd0ddf0e Fixed test_permissions_debug 2020-06-12T00:25:12Z 2020-06-12T00:25:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fba8ff6e76253af2b03749ed8dd6e28985a7fb8f "$env": "X" mechanism now works with nested lists, closes #837 2020-06-12T00:21:48Z 2020-06-12T00:21:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
4d9a3204361d956440307a57bd18c829a15861db Release 2.10 Refs #115 2020-06-12T17:43:45Z 2020-06-12T17:43:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
03ee97d2258254581bea72842518904fc1cbe60f CLI now supports upsert/insert - closes #115 2020-06-12T17:40:53Z 2020-06-12T17:40:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
8703eb0b24d6e73ebb9b40d95711a5aa740f3f21 Install sqlite-utils a bit earlier, confirm version Refs #40 2020-06-12T17:57:40Z 2020-06-12T17:57:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
947dd916eda3d6f65fd9602f27f7a9bb106523d8 Fix for broken sqlite3 install Refs #40, uses https://github.com/simonw/sqlite-utils/issues/115 2020-06-12T17:48:33Z 2020-06-12T17:48:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447

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]);