commits

Table actions

7 rows where "author_date" is on date 2022-12-18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_author, author, author_date (date), committer_date (date)

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
0ea139dfe59b5c02a119c2d16ad5784b1644c42f Run new HTTPS test in CI, refs #1955 2022-12-18T02:38:26Z 2022-12-18T02:38:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
23335e123b5debd86160509086bf42386987bb33 Release notes for 0.63.3 Refs #1963 2022-12-18T03:06:03Z 2022-12-18T03:26:25Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
8b73fc6b47dffd8836f5c58aae1e57c1f66a5754 Put AsgiLifestyle back so server starts up again, refs #1955 2022-12-18T01:22:00Z 2022-12-18T01:22:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a21c00b54dd6e0ecb17c60024fb1b55729c5d21e .select-wrapper:focus-within for accessibility, closes #1771 2022-12-18T06:28:07Z 2022-12-18T06:28:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a27c0a01240c5857626eff21e79b9b38e7a3ac99 Deploy docs on publish using Python 3.9 A workaround for gcloud setup, see: https://til.simonwillison.net/googlecloud/gcloud-error-workaround Refs #1963 2022-12-18T03:24:34Z 2022-12-18T03:24:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d1d369456a7319b9de39175605568cbc9b852478 Move HTTPS test to a bash script See https://github.com/simonw/datasette/issues/1955#issuecomment-1356627931 2022-12-18T02:33:07Z 2022-12-18T02:33:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
e03aed00026cc2e59c09ca41f69a247e1a85cc89 Detect server start/stop more reliably. This is useful, especially in testing, since your test hosts might not reliabliy start the server within two seconds, so we do a definite check before progressing. By the same token, after `kill $server_pid` wait for the pid to be gone from the process list. Since now the script can end prematurely, I also added a cleanup function to make sure the temporary certs are removed in any case. n.b. this could also be done with the use of `trap 'fn' ERR` but that felt like a bit too much magic for this short a script. 2022-12-18T09:40:06Z 2022-12-18T16:01:51Z Jan Lehnardt f333c00958a658720cd93e305aac71711b88e52b Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 janl 11321 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]);