commits

Table actions

12 rows where "author_date" is on date 2021-11-14

✎ View and edit SQL

This data as json, CSV (advanced)

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

author_date (date) 1 ✖

  • 2021-11-14 · 12 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
030390fd4abcecf1ab80d0528e32d7dbc50d1b5f .readthedocs.yaml configuration, refs #1507 2021-11-14T05:29:43Z 2021-11-14T05:29:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
12b8c9de256ba907d4fa8e134bf9ce9bc012302e sqlite-utils memory --flatten, closes #332 2021-11-14T23:05:00Z 2021-11-14T23:05:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
13195d8747764df3952ed1117e0fd2152f1899e7 Test demonstrating fix for #335 2021-11-14T22:55:42Z 2021-11-14T22:55:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
1c13e1af0664a4dfb1e69714c56523279cae09e4 Ensure query columns are included too, ref #1503 2021-11-14T05:08:33Z 2021-11-14T05:08:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
502c02fa6dde6a8bb840af6c4c8cf858aa1db687 Pin to docutils<0.18 in ReadTheDocs, refs #1507 2021-11-14T05:37:40Z 2021-11-14T05:37:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
73e214a9760c5dc32ed3c5429cb04d4d471ce014 py.typed file so mypy picks up the types, closes #331 2021-11-14T23:21:04Z 2021-11-14T23:21:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
adea5bc3965c80684f219b12299f708f2f422ca1 flake8 fix, refs #331 2021-11-14T23:24:15Z 2021-11-14T23:24:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
bc4c42d68879c710c851dba3c98deda96ca6caa8 Use python-dateutil package instead of dateutils (#324) 2021-11-14T23:25:40Z 2021-11-14T23:25:40Z Denys Pavlov 64b848f51063b81fd138f806322b4add4b5f1afd GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 meatcar 191622 web-flow 19864447
c306b696de0a582e322f9eb7cb4125c83301e3a9 Correct facet links for columns with a leading underscore, closes #1506 2021-11-14T04:44:54Z 2021-11-14T04:44:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c9e3cfecc8e966e5137d72e3f2150be9602d55f5 Columns in filters now ignore ?_nocol, closes #1503 2021-11-14T04:53:00Z 2021-11-14T04:53:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
de1e031713f47fbd51eb7239db3e7e6025fbf81a Release 0.59.2 Refs #1497, #1503, #1506 2021-11-14T05:14:43Z 2021-11-14T05:14:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
e8d958109ee290cfa1b44ef7a39629bb50ab673e create_index(..., find_unique_name=True) option, refs #335 2021-11-14T22:49:19Z 2021-11-14T22:49:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 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]);