commits

Table actions

8 rows where "author_date" is on date 2021-11-15

✎ View and edit SQL

This data as json, CSV (advanced)

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

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
07044bd130542870d5eb2e545988d0a24eb573ec SQL view-friendly arraycontains/arraynotcontains implementation, refs #448 2021-11-15T23:41:07Z 2021-11-15T23:41:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
271b894af52eb6437ae6cd84eba9867ad8dd43f6 Map dict to TEXT Thanks, @minaeid90 2021-11-15T00:27:40Z 2021-11-15T00:27:40Z Mina Rizk 354fc054391e109f21a593b971cebb96f0dab254 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 minaeid90 2496189 web-flow 19864447
3b8abe608796e99e4ffc5f3f4597a85e605c0e9b Release 3.18 Refs #324, #329, #330, #331, #332, #335, #338, #339 2021-11-15T03:15:23Z 2021-11-15T03:15:23Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
54a2269e91ce72b059618662ed133a85f3d42e4a Optional second argument to .lookup() to populate extra columns, closes #339 2021-11-15T02:01:56Z 2021-11-15T02:01:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
84007dffa8fd2fcdf4ff24abe6ee90c01c3d08ae Applied Black, refs #322, #328 2021-11-15T00:28:53Z 2021-11-15T00:28:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
9cda5b070f885a7995f0c307bcc4f45f0812994a Handle dict/tuple/list mapping to TEXT, closes #338 2021-11-15T00:36:00Z 2021-11-15T00:36:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
fb9d61754a9088a4efafce490db01e2999dea2d2 Better type signature for hash_id, closes #341 2021-11-15T02:19:28Z 2021-11-15T02:19:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 sqlite-utils 140912432 simonw 9599 simonw 9599
ffb54427d3c5944ea4ed83d138d3917309cc5242 insert now replaces square braces in column name with underscore, closes #341 2021-11-15T02:56:35Z 2021-11-15T02:56:35Z 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]);