commits

Table actions

6 rows where "author_date" is on date 2018-08-01

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committer_date (date)

author_date (date) 1 ✖

  • 2018-08-01 · 6 ✖
sha ▼ message author_date committer_date raw_author raw_committer repo author committer
0aa28293adedc488eb9107dc52b5e9a124887fbd Fix compatibility with SQLite prior to 3.16.0 pragma_index_info() and pragma_index_list() were introduced in 3.16.0 but the version of SQLite running in Travis CI is earlier than that, hence the test failures: https://travis-ci.com/simonw/sqlite-utils/jobs/137617744 2018-08-01T15:29:53Z 2018-08-01T15:29:53Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
4427d2d96f7197e25acee85643bcf02e758b8b1e table.create_index(columns, index_name) method 2018-08-01T15:20:44Z 2018-08-01T15:20:44Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
515d362ad60c3dc16272c4fdca932cf0a0e9dafa .table_names and .tables properties plus expanded docs 2018-08-01T00:35:36Z 2018-08-01T00:35:36Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
70e1f831a00ec97b724187025e35338becd2309a Typo 2018-08-01T01:32:03Z 2018-08-01T01:32:03Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
c611ed80d2e9f721fc7848fd74e6e6baebe5adde .indexes property for introspecting indexes 2018-08-01T01:31:29Z 2018-08-01T01:31:29Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 sqlite-utils 140912432 simonw 9599 simonw 9599
e04f509c518af01db5f3174ed662c3ac50320f58 Added docs on storing JSON 2018-08-01T00:48:32Z 2018-08-01T00:48:32Z Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 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]);