commits

Table actions

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

✎ View and edit SQL

This data as json, CSV (advanced)

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

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
2e4ba71b53a45a7d2273afd30e400002c7f39755 Optimize create table calls using executescript=True Refs #1555, #1569 2021-12-18T18:30:53Z 2021-12-18T18:34:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
359140cedaf69242d6356479fb8a9d3aa591e618 Datasette() constructor no longer requires files=, closes #1563 2021-12-18T02:09:00Z 2021-12-18T02:09:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
3a0cae4d7f77b5c2a103ea74ca7fa7a0d9ff2e66 Fix bug introduced by refactor in c35b84a2aabe2f14aeacf6cda4110ae1e94d6059 2021-12-18T02:19:09Z 2021-12-18T02:19:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
5cadc244895fc47e0534c6e90df976d34293921e db.execute_write_script() and db.execute_write_many(), closes #1570 Refs #1555 2021-12-18T18:57:22Z 2021-12-18T18:57:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7c8f8aa209e4ba7bf83976f8495d67c28fbfca24 Documentation for Datasette() constructor, closes #1563 2021-12-18T02:19:36Z 2021-12-18T02:19:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
83bacfa9452babe7bd66e3579e23af988d00f6ac Call _prepare_connection() on write connections, closes #1564 2021-12-18T01:58:39Z 2021-12-18T01:58:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
85c22f4fbccb7b35fbc16d3ef035ca71b1a5a20a Corrected Datasette(files=) example from #1563 2021-12-18T18:10:37Z 2021-12-18T18:10:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 simonw 9599 web-flow 19864447
9e094b7c9d575320a2f0c956eb547bfcf6d64d39 db.execute_write(executescript=True) option, closes #1569 2021-12-18T18:28:25Z 2021-12-18T18:34:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
c35b84a2aabe2f14aeacf6cda4110ae1e94d6059 Remove undocumented sqlite_functions mechanism, closes #1567 2021-12-18T01:54:39Z 2021-12-18T01:54:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
d637ed46762fdbbd8e32b86f258cd9a53c1cfdc7 Use execute_write_many to optimize internal DB, refs #1555, #1570 2021-12-18T19:11:08Z 2021-12-18T19:11:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
f81d9d0cd9f567e73a1a54be34b653db8ae2c1cf Trace write SQL queries in addition to read ones, closes #1568 2021-12-18T02:42:29Z 2021-12-18T02:42:29Z 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]);