commits

Table actions

9 rows where repo = 611552758

✎ View and edit SQL

This data as json, CSV (advanced)

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

sha ▼ message author_date committer_date raw_author raw_committer repo author committer
12ab0122798c1b3847c7cfcaefd2607b0aaaa89d --help output in README 2023-03-09T20:52:10Z 2023-03-09T20:52:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 apple-notes-to-sqlite 611552758 simonw 9599 simonw 9599
193138be32043534891d3cd74b6d699c665f4586 Moved it to dogsheep 2023-03-09T05:11:00Z 2023-03-09T05:11:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 apple-notes-to-sqlite 611552758 simonw 9599 simonw 9599
5376b04dfb0eef2e2e2d9f320cc6efa2493cab1a Include schema in README, closes #10 Also added a new --schema option for just creating the schema. 2023-03-09T20:48:05Z 2023-03-09T20:48:05Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 apple-notes-to-sqlite 611552758 simonw 9599 simonw 9599
7ab475a5d32ea6f62736f8536395d7e10cb1724c First working version, refs #2 2023-03-09T04:29:33Z 2023-03-09T04:29:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 apple-notes-to-sqlite 611552758 simonw 9599 simonw 9599
b77bb2ef9d0eb7be38c167824ef2e444520856db Folder support, closes #7 2023-03-09T20:38:37Z 2023-03-09T20:38:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 apple-notes-to-sqlite 611552758 simonw 9599 simonw 9599
d18998fb46363d9cdfb8d00d56a7a7b9624e8b77 Prevent cog --check from breaking on Linux The lack of osascript meant that the README was calculated to have a blank schema in it. Refs #10 2023-03-09T20:57:39Z 2023-03-09T20:57:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 apple-notes-to-sqlite 611552758 simonw 9599 simonw 9599
d33ba2fef59873a1d9ee3777509e77b57458f594 Documentation for --dump, refs #3 2023-03-09T05:23:57Z 2023-03-09T05:23:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 apple-notes-to-sqlite 611552758 simonw 9599 simonw 9599
e55a802d37a896475b6cf475c1ba947af63cca73 Better --help text 2023-03-09T20:59:22Z 2023-03-09T20:59:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 apple-notes-to-sqlite 611552758 simonw 9599 simonw 9599
ebe6aa6cc937d766abccdd5d389848724ef2d7e6 Tests, plus new --dump option, refs #2, closes #3 2023-03-09T05:05:21Z 2023-03-09T05:05:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 apple-notes-to-sqlite 611552758 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]);