commits

Table actions

12 rows where "author_date" is on date 2021-08-09 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 ✖

  • 2021-08-09 · 12 ✖
sha message author_date committer_date raw_author raw_committer repo ▼ author committer
b1fed48a95516ae84c0f020582303ab50ab817e2 derive_named_parameters falls back to regex on SQL error, refs #1421 2021-08-09T03:26:08Z 2021-08-09T03:26:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
fc4846850fffd54561bc125332dfe97bb41ff42e New way of deriving named parameters using explain, refs #1421 2021-08-09T03:21:13Z 2021-08-09T03:21:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ad90a72afa21b737b162e2bbdddc301a97d575cd Release 0.59a1 Refs #1425 2021-08-09T01:13:03Z 2021-08-09T01:13:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
a390bdf9cef01d8723d025fc3348e81345ff4856 Stop using firstresult=True on render_cell, refs #1425 See https://github.com/simonw/datasette/issues/1425#issuecomment-894883664 2021-08-09T00:38:42Z 2021-08-09T00:38:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ee469e3122d6f5973ec2584c1580d930daca2e7c Corrected tiny mistake in --flatten examples 2021-08-09T22:50:53Z 2021-08-09T22:50:59Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
8757de84b27cedf494ee917ce2daf773d2c3f877 Link to stable docs, not latest 2021-08-09T22:44:26Z 2021-08-09T22:44:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 simonw 9599 web-flow 19864447
d5ef91212022ea3ed85258af605bdc28e5799ff1 Release 3.15 Refs #309, #310 2021-08-09T22:42:06Z 2021-08-09T22:42:06Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
a6567ec507e235fd4d313c6b1570d5a4f45e4b86 Capture parameters= not params=, refs #309 2021-08-09T22:33:33Z 2021-08-09T22:33:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
14f643d9e91f5557d5e46251dadac481f4b41021 Better error messages in CLI, closes #309 2021-08-09T22:25:52Z 2021-08-09T22:25:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
3fb1034e869090876cab0247146a312be993210f option, not object, refs #310 2021-08-09T21:46:47Z 2021-08-09T21:46:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
15758d02fd437004fd9f84c9d4a8bf49f0793e13 Fixed spelling of objects, refs #310 2021-08-09T21:45:39Z 2021-08-09T21:45:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
f67327abf0a9f018e1764660e190c5bbf9556ec2 sqlite-utils insert --flatten option, closes #310 2021-08-09T21:44:03Z 2021-08-09T21:44:03Z 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]);