commits

Table actions

5 rows where "author_date" is on date 2019-06-24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, committer, committer_date (date)

author_date (date) 1 ✖

  • 2019-06-24 · 5 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
34e292d24dc2b8376236472bec3cce1c556ddfe5 Porting Datasette to ASGI, and Turtles all the way down 2019-06-24T05:28:37Z 2019-06-24T05:28:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
6341f8cbc7833022012804dea120b838ec1f6558 Better coverage of sqlite-utils in FTS docs, closes #525 2019-06-24T16:28:42Z 2019-06-24T16:28:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a5591236c46f507b9e46b1b52e51d5f46ffd6913 Install test dependencies so deploy can work python tests/fixtures.py needs asgiref or it fails with an error 2019-06-24T03:23:07Z 2019-06-24T03:23:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
ba8db9679f3bd2454c9e76e7e6c352126848b57a Port Datasette from Sanic to ASGI + Uvicorn (#518) Datasette now uses ASGI internally, and no longer depends on Sanic. It now uses Uvicorn as the underlying HTTP server. This was thirteen months in the making... for full details see the issue: https://github.com/simonw/datasette/issues/272 And for a full sequence of commits plus commentary, see the pull request: https://github.com/simonw/datasette/pull/518 2019-06-24T03:13:09Z 2019-06-24T03:13:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
cdd24f3eaa207f67d948c1876725b0f84654a623 Added datasette-doublemetaphone to list of plugins 2019-06-24T04:23:24Z 2019-06-24T04:23:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 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]);