commits

Table actions

6 rows where "author_date" is on date 2019-11-01 sorted by message

✎ View and edit SQL

This data as json, CSV (advanced)

committer_date (date) 1 ✖

author_date (date) 1 ✖

  • 2019-11-01 · 6 ✖
sha message ▼ author_date committer_date raw_author raw_committer repo author committer
ffae2f0ecde1ca92e78d097665df820d3b7861e6 Better documentation of --host, closes #574 2019-11-01T21:57:49Z 2019-11-01T21:57:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
7152e76eda9049574643261e7a471958cc16d0b9 Don't suggest array facet if column is only [], closes #610 2019-11-01T21:45:59Z 2019-11-01T21:45:59Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ba5414f16b49781261d0f41a16f2210d5fa3976f Only inspect first 100 records for #562 2019-11-01T19:38:15Z 2019-11-01T19:38:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
50287e7c6bb0987536e5515f05945721c4515e9a Only suggest array facet for arrays of strings - closes #562 2019-11-01T19:37:46Z 2019-11-01T19:37:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
ed57e4f99018c1d520858f55f6eee4eb1cc2af3d Plugin static assets support both hyphens and underscores in names Closes #611 2019-11-01T22:15:10Z 2019-11-01T22:15:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 datasette 107914493 simonw 9599 simonw 9599
937828f946238c28e77ba50e0b2e649c874560f7 Use distinfo.project_name for plugin name if available, closes #606 2019-11-01T05:39:59Z 2019-11-01T05:39:59Z 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]);