commits

Table actions

8 rows where "author_date" is on date 2022-03-07

✎ View and edit SQL

This data as json, CSV (advanced)

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

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
020effe47bf89f35182960a9645f2383a42ebd54 Preserve query string in % to - redirects, refs #1650 2022-03-07T16:18:07Z 2022-03-07T16:18:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
1baa030eca375f839f3471237547ab403523e643 Switch to dash encoding for table/database/row-pk in paths * Dash encoding functions, tests and docs, refs #1439 * dash encoding is now like percent encoding but with dashes * Use dash-encoding for row PKs and ?_next=, refs #1439 * Use dash encoding for table names, refs #1439 * Use dash encoding for database names, too, refs #1439 See also https://simonwillison.net/2022/Mar/5/dash-encoding/ 2022-03-07T15:38:29Z 2022-03-07T15:38:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
644d25d1de78a36b105cca479e7b3e4375a6eadc Redirect old % URLs to new - encoded URLs, closes #1650 Refs #1439 2022-03-07T16:01:03Z 2022-03-07T16:01:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
bb499942c15c4e2cfa4b6afab8f8debe5948c009 Fixed tests for urlsafe_components, refs #1650 2022-03-07T19:33:31Z 2022-03-07T19:33:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c10cd48baf106659bf3f129ad7bfb2226be73821 Min pytest-asyncio of 0.17 So that the asyncio_mode in pytest.ini does not produce a warning on older versions of that library. 2022-03-07T19:56:59Z 2022-03-15T15:43:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c5791156d92615f25696ba93dae5bb2dcc192c98 Code of conduct, refs #1654 2022-03-07T22:04:10Z 2022-03-07T22:04:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
c85d669de387b40e667fd6942c6cc1c15b4f5964 Fix bug with percentage redirects, close #1650 2022-03-07T19:26:08Z 2022-03-07T19:26:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d714c67d656c46e012b24ccca53b59409440334f asyncio_mode = strict to avoid pytest warnings 2022-03-07T16:09:15Z 2022-03-07T16:09: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]);