commits

Table actions

8 rows where "author_date" is on date 2020-10-17 sorted by message

✎ 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 ✖

  • 2020-10-17 · 8 ✖
sha message ▼ author_date committer_date raw_author raw_committer repo author committer
568bd7bbf590861687db8c318f3d8cfcd1dfb47a Fix broken link in publish docs (#1029) 2020-10-17T20:05:03Z 2020-10-17T20:05:03Z Taylor Hodge 3110693b4efacece57b372eb3e20d7a4896b52d8 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 jthodge 17075617 web-flow 19864447
3eb2b06bfe3b4faaf10e9cf9dfcb28e3d16c14ff Handle export.xml in other languages, closes #11 2020-10-17T21:14:02Z 2020-10-17T21:14:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 simonw 9599 simonw 9599
4890ec87b5e2ec48940f32c9ad1f5aae25c75a4d Release 0.9 Refs #16, #28 2020-10-17T23:01:38Z 2020-10-17T23:01:38Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f dogsheep-beta 197431109 simonw 9599 web-flow 19864447
bb16655ecd6c856c14499fc15c2a0a84edf09e63 Release 1.0 Refs #11 2020-10-17T21:14:30Z 2020-10-17T21:15:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 simonw 9599 simonw 9599
71e36e1cf034b96de2a8e6652265d782d3fdf63b Suggest using AirDrop 2020-10-17T21:23:26Z 2020-10-17T21:23:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f healthkit-to-sqlite 197882382 simonw 9599 web-flow 19864447
eb114d40e8b143f82dc5ce1a0dfccb0119165976 Switch CI to GitHub Actions 2020-10-17T20:56:07Z 2020-10-17T20:56:07Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 simonw 9599 simonw 9599
9a759e9ddf36dc834f6a91158910fef041be5679 Use datasette.client, closes #28 Also refs https://github.com/simonw/datasette/issues/1020 2020-10-17T23:00:41Z 2020-10-17T23:00:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 dogsheep-beta 197431109 simonw 9599 simonw 9599
c1b8f21113ba73a960832877045253cdca839f34 master => main 2020-10-17T20:53:58Z 2020-10-17T20:53:58Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 healthkit-to-sqlite 197882382 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]);