commits

Table actions

3,284 rows sorted by raw_author

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: raw_committer, repo, committer, committer_date (date)

sha message author_date committer_date raw_author ▼ raw_committer repo author committer
b37f55549461cfe0731b57623f315860b3db49d0 github-to-sqlite pull-requests command (#48) Thanks, @adamjonas 2020-11-29T23:51:08Z 2020-11-29T23:51:08Z Adam Jonas 04fb3d52db4bd9bf23ce52c5cc72fda2068a1fce GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 adamjonas 755825 web-flow 19864447
0f41db1ba8a8a49a4adc1046a25ccf32790e863f Avoid error sorting by relationships if related tables are not allowed Refs #1306 2021-06-02T04:25:27Z 2021-06-02T04:25:27Z Guy Freeman 0645c24f7846578adea9d68f3e37a7e15a9bd1dd GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 slygent 416374 web-flow 19864447
f045d8559a6d2cb922a2de30fbcc896a4486b82f Allow iterables other than lists in m2m records (#189) * Allow iterables other than Lists in m2m records * Add test for iterable m2m records Thanks, @adamwolf! 2020-10-27T16:24:21Z 2020-10-27T16:24:21Z Adam Wolf 0bb6015e7b1a787517bbd1a604bb2c91a8a4e321 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f sqlite-utils 140912432 adamwolf 35681 web-flow 19864447
3041c6b6412bbe317f8b9afd6529a15954f2c47e Use inspect-file, if possible, for total row count (#666) For large tables, counting the number of rows in the table can take a significant amount of time. Instead, where an inspect-file is provided for an immutable database, look up the row-count for a plain count(*). Thanks, @kevindkeogh 2020-02-25T20:19:29Z 2020-02-25T20:19:29Z Kevin Keogh 0f68d17313c6f4ccbf0c24a3883444b5263f5648 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 kevindkeogh 13896256 web-flow 19864447
49f317752cfe89c5641165a490eef49e025752a7 Move version info back to separate module 2018-05-22T17:33:57Z 2018-05-22T19:35:21Z Robert Gieseke 106fe7fbf8b80a01038e265a137b3b703422db48 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 rgieseke 198537 simonw 9599
fc47dacbbd4c4d245d7144e4cc014d3303f84b9a Add `__version_info__` derived from `__version__` This might be tuple of more than two values (major and minor version) if commits have been made after a release. 2018-05-22T17:18:00Z 2018-05-22T19:35:21Z Robert Gieseke 106fe7fbf8b80a01038e265a137b3b703422db48 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 rgieseke 198537 simonw 9599
6d39429daa4655e3cf7a6a7671493292a20a30a1 Don't prevent tabbing to `Run SQL` button (#117) See comment in #115 2017-11-18T00:53:42Z 2017-11-18T00:53:42Z Robert Gieseke 106fe7fbf8b80a01038e265a137b3b703422db48 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 rgieseke 198537 simonw 9599
eda848b37f8452dba7913583ef101f39d9b130ba Add keyboard shortcut to execute SQL query (#115) 2017-11-17T14:22:55Z 2017-11-17T14:22:55Z Robert Gieseke 106fe7fbf8b80a01038e265a137b3b703422db48 Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 datasette 107914493 rgieseke 198537 simonw 9599
772f9a07ce363869e0aaa7600617454dc00e6966 Add scientists to target groups (#1455) 2021-09-04T16:31:38Z 2021-09-04T16:31:38Z Robert Gieseke 106fe7fbf8b80a01038e265a137b3b703422db48 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 rgieseke 198537 web-flow 19864447
baf986c871708c01ca183be760995cf306ba21bf New get_metadata() plugin hook for dynamic metadata The following hook is added: get_metadata( datasette=self, key=key, database=database, table=table, fallback=fallback ) This gets called when we're building our metdata for the rest of the system to use. We merge whatever the plugins return with any local metadata (from metadata.yml/yaml/json) allowing for a live-editable dynamic Datasette. As a security precation, local meta is *not* overwritable by plugin hooks. The workflow for transitioning to live-meta would be to load the plugin with the full metadata.yaml and save. Then remove the parts of the metadata that you want to be able to change from the file. * Avoid race condition: don't mutate databases list This avoids the nasty "RuntimeError: OrderedDict mutated during iteration" error that randomly happens when a plugin adds a new database to Datasette, using `add_database`. This change makes the add and remove database functions more expensive, but it prevents the random explosion race conditions that make for confusing user experience when importing live databases. Thanks, @brandonrobertz 2021-06-26T22:24:54Z 2021-06-26T22:24:54Z Brandon Roberts 121af5c26cc703f7b3d7219091a8e71dc39db899 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f datasette 107914493 brandonrobertz 2670795 web-flow 19864447
2972bb001ab5f675eced62f7ba5adef2d3eba2ad Added pinboard-to-sqlite 2019-11-07T20:44:09Z 2019-11-07T20:44:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f dogsheep.github.io 214746582 simonw 9599 web-flow 19864447
68df9bf80627d8608a82480ea016de32ebb29ce7 Added goodreads-to-sqlite 2019-10-13T02:27:04Z 2019-10-13T02:27:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f dogsheep.github.io 214746582 simonw 9599 web-flow 19864447
01b7a6a71ca121ec91ca4cc18f46a565098441fd List of all current Dogsheep tools 2019-10-13T02:23:10Z 2019-10-13T02:23:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f dogsheep.github.io 214746582 simonw 9599 web-flow 19864447
5e3bd8c176345c0ae11a2c988be9e03152d0db0a Initial commit 2019-10-13T02:10:13Z 2019-10-13T02:10:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f dogsheep.github.io 214746582 simonw 9599 web-flow 19864447
6894c8bc767b4c0375ddb8b2f0d2fed857667ff5 First release 2019-09-19T15:38:10Z 2019-09-19T15:38:10Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 genome-to-sqlite 209590345 simonw 9599 simonw 9599
630bdba68a23c0ac453e015518ef0bf41107a952 Just pull for dogsheep repos + sqlite-utils and datasette I accidentally started pulling everything from the dependent repos as well. Commit messages with REFRESH_DB in now trigger a rebuild from scratch. 2020-05-01T16:02:55Z 2020-05-01T16:02:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
61f53476eb3f147231093ab9339c3d7713190f34 --install=datasette-json-html 2020-05-01T03:04:03Z 2020-05-01T03:04:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
80f63b1fc50d9945e01df00e72200db091f9d284 Fetch previous copy of database Also installed missing bs4 dependency 2020-04-30T23:39:22Z 2020-04-30T23:39:22Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
26fd45f4bdae7b2c884a2c9120ca2f54ba7bf3e7 Scrape dependents demo, refs #34 2020-04-30T23:27:03Z 2020-04-30T23:27:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
9d7aed336c8e62bf372caa800cb4aae3985cbae9 Release 2.1, refs #34 2020-04-30T23:02:24Z 2020-04-30T23:02:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
719f3d8ed93783f796a0d9f7c4df25227de65a23 Install test dependencies, refs #34 2020-04-30T23:01:02Z 2020-04-30T23:01:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
c9f48404481882e8b3af06f35e4801a80ac79ed6 New scrape-dependents command, refs #34 2020-04-30T22:58:37Z 2020-04-30T22:58:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
c34d5a18bfc41fa08755ba3d5cf9fe09ff204238 Default milestones facets are now repo and state 2020-04-22T01:26:57Z 2020-04-22T01:26:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
44611df1524a03ce305405e5902c9615e3c73a72 Release 2.0 Backwards incompatible schema change, refs #31 2020-04-22T01:20:52Z 2020-04-22T01:20:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
6237994433d9c5518ea6295e79d6f400fdc78aa2 Removed debug output, refs #32 2020-04-22T01:16:17Z 2020-04-22T01:16:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
37eedc06c0e23ecbe3bbfb666a243b17f29a47ff Added missing issue-comments.json, refs #32 2020-04-22T01:15:34Z 2020-04-22T01:15:34Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
89e3d9260d2edaf066a1a3b7722bbff0265ce477 Debug list of files in tests, for #32 2020-04-22T01:14:17Z 2020-04-22T01:14:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
717ac2a715f12444aad48cbe339d3a5c98214d75 Fix for issue_comments bug #32 Refs #31 2020-04-21T20:25:35Z 2020-04-21T20:25:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
2cf75a0a036719eb7e57fdc7c5c2ea0f4c26978a Fix for creator foreign key on milestones, refs #31 2020-04-21T19:14:23Z 2020-04-21T19:14:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
02e38b363ed2211fd32f7d97bef36512b5ebf294 Foreign keys for milestones table, refs #31 2020-04-21T18:58:21Z 2020-04-21T18:58:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
7757a417c266f311152e3ccf359e35e3c2f1e063 Use foreign key to repos table on issues and milestones, refs #31 2020-04-21T18:44:43Z 2020-04-21T18:44:43Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
e0e8d8caa9657b04bfb8a2cf16c9b580f38b1805 milestones now has FK to creator, plus repo column - closes #29 2020-04-21T00:43:52Z 2020-04-21T00:43:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
befb6fec28828394c42af546ea0d738fb02cfec9 Ensure issues.milestone/assignee are integers, closes #30 2020-04-21T00:36:15Z 2020-04-21T00:36:15Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
92a72e540479123c78207a68984a2a4a41fbc17b Ignore *.json and *.db and .DS_Store 2020-04-21T00:28:55Z 2020-04-21T00:30:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
5cd34bd07d704487d48ac741ee5da5317afe88d2 Release 1.1 2020-04-18T15:07:04Z 2020-04-18T15:07:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
87d4bcfff4babcb17c1125884cce5791054b5cca Note that demo includes datasette and sqlite-utils now 2020-04-18T15:06:46Z 2020-04-18T15:06:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
13f8868fb5efa01c263b24f6dd91c617e6e938e1 Demo also pulls datasette and sqlite-utils 2020-04-18T14:56:47Z 2020-04-18T14:56:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
9ca6dc835ca6da948ee5f766024ad0734cc69db8 Handle 204 No Content from GitHub API, refs #28 2020-04-18T14:53:39Z 2020-04-18T14:53:39Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
4fa33ffcf138e50125d8d04dcaa34ea32413151e New contributors command, refs #28 2020-04-18T01:19:56Z 2020-04-18T01:19:56Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
0ad3ce5e2d664c227d7045afafec46704f251a10 Use INTEGER for organization column, fixes #27 2020-04-18T00:18:45Z 2020-04-18T00:18:45Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
da5beb2f94eb21454a71fb364aec562ec7c221d7 Updated foreign keys test, refs #27 2020-04-16T19:19:38Z 2020-04-16T19:19:38Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
47686c7c3d2eee7f9e5425af8922970967ffb379 Extract organizaion to users table, refs #27 2020-04-16T19:03:44Z 2020-04-16T19:03:44Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
539e8a86ba53decf26cd6bd9e53cffb80396719b Add datasette-pretty-json to demo 2020-04-16T19:03:08Z 2020-04-16T19:03:08Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
3b7ab5685de89fcb6fc92d320c0e24b17be05570 Release 1.0.1 With bug fix for #26 2020-04-16T17:41:47Z 2020-04-16T17:41:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
85a09a9966ab1aff36c83083243ab6985ec60084 Send topic Accept header in fetch_repo() too, closes #26 2020-04-16T17:40:47Z 2020-04-16T17:41:01Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
c4aaa50e167cfa9021c7c94260bc3e89e10947bf Also pull issue comments, refs #25 2020-04-16T17:31:04Z 2020-04-16T17:31:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 GitHub cd792325681cbad9f663f2879d8b69f1edbb678f github-to-sqlite 207052882 simonw 9599 web-flow 19864447
c3f7fc6925c6c34d64c26d436356ab917da0917d --install=py-gfm 2020-03-25T05:17:20Z 2020-03-25T05:17:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
c53bd21b66b24558b0e219f93eceed4021c36939 --service github-to-sqlite 2020-03-25T05:09:04Z 2020-03-25T05:09:04Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
267efaf75f2f9a09a721d568916460b2bbc20c38 Configure demo with demo-metadata.json This includes datasette-render-markdown 2020-03-25T05:03:35Z 2020-03-25T05:03:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
1ea30c8fb1d080bd5e38c577e3ad20bb527a2fe6 Release 1.0, refs #23 2020-03-24T00:07:47Z 2020-03-24T00:07:47Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
867f352fc1aedfd8abf00711ecb638e3529c0000 Link to demo from README, refs #13 and #23 2020-03-24T00:07:25Z 2020-03-24T00:07:25Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
471cf4f045d25bc319d61b9de3a698beaf1a6c96 datasette-search-all plugin, refs #13 2020-03-23T23:58:24Z 2020-03-23T23:58:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
f78c4e9baaf0970ffab266ba780df7240aae9f32 Install datasette (for datasette publish) - refs #13 2020-03-23T23:33:28Z 2020-03-23T23:33:28Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
5ecf6e6b5aee904176bd50c7be4a1ffa84e40edb Install sqlite3 in action, refs #13 2020-03-23T23:29:40Z 2020-03-23T23:29:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
8d1ec675fa7e64cbcb214e6e1ddc23ac79fcd8f5 Redact email addresses before publishing 2020-03-23T23:25:48Z 2020-03-23T23:25:48Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
d723211163d0d0906b8e7906ade5b31ef90f87dc Explicit title/description columns on milestone, refs #13 2020-03-23T23:23:35Z 2020-03-23T23:23:35Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
9693e733ae22a8d8a5e7e2046315b03a3cb03636 Handle repos with no commits, closes #22 Refs #21 2020-03-23T23:13:03Z 2020-03-23T23:13:03Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
c4c7fc3ae60e5dfdf97ef9328e75ea22c311b1c7 Raise GitHub API errors as exceptions, refs #21 2020-03-23T22:47:24Z 2020-03-23T22:47:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
12046c32207f35d2260268e3ab52f313835df6e7 Fixed bad bash syntax, refs #13 2020-03-23T22:41:36Z 2020-03-23T22:41:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
df9e2b41f2f9fdedfc75d686587725b253737eef Expose GITHUB_ACCESS_TOKEN env variable, refs #13 2020-03-23T22:35:57Z 2020-03-23T22:35:57Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
7fb03a8880d163e40e31ab81c0ac9c5f636002cd Cat auth.json - revoke token immediately after this run, refs #13 2020-03-23T22:31:40Z 2020-03-23T22:31:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
67396e16a9f1711334c8fa68099c5c5065d3ebbb Cat auth.json - revoke token immediately after this run, refs #13 2020-03-23T22:30:34Z 2020-03-23T22:30:34Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
1818f611fcb1f567b430bba8954e7c3b3b1eb8f1 Removed some debugging, refs #13 2020-03-23T22:28:29Z 2020-03-23T22:28:29Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
87e431e961cb3b0041b09027431a62f7e3224efd No need for explicit auth.json if I get the key right, refs #13 2020-03-23T22:24:54Z 2020-03-23T22:24:54Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
59f98ecae20f77f22a20349d4897f6543d594ba7 Revert "More debugging for actions, refs #13" This reverts commit aca2823f1987fafd1dfead79a275ce3819168f2a. 2020-03-23T22:14:21Z 2020-03-23T22:14:26Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
aca2823f1987fafd1dfead79a275ce3819168f2a More debugging for actions, refs #13 2020-03-23T22:14:09Z 2020-03-23T22:14:09Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
3c3296a6ba38d97708d400699c61a40dd5b4a97b Debug assertion, refs #13 2020-03-23T22:12:02Z 2020-03-23T22:12:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
bb747b3f71250e63f287efffa2fec48f2b4f4acb Just run against dogsheep repos, refs #13 Otherwise the demo will leak my private simonw repos 2020-03-23T22:10:13Z 2020-03-23T22:10:13Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
fa77a1fa3ab20c7b44887c3a8f8c17319063c5f3 Explicit auth.json, refs #13 2020-03-23T22:07:31Z 2020-03-23T22:07:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
34878d1579b8b460f6aa5b0bd53d6ac9008a118f More action debugging, refs #13 2020-03-23T22:05:46Z 2020-03-23T22:05:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
551515d8a3fb2587f0f14a07151defc88419f678 Some actions debugging output, refs #13 2020-03-23T22:03:59Z 2020-03-23T22:04:02Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
2cae2a754231e35f0714f45d4d362762acb70c38 Write auth.json with plain echo, refs #13 2020-03-23T21:57:54Z 2020-03-23T21:58:00Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
53d4473ce5015299eed679b4375a44c6f17155d8 Use jq to create auth.json Refs #13 2020-03-23T21:50:12Z 2020-03-23T21:50:12Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
ef538da58f24826e16ff7b4fa7690bf23da13721 Deploy demo using Actions, refs #13 2020-03-23T21:43:31Z 2020-03-23T21:43:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
f39c98a9c706a1e5c59ed0b2ced234bbf9325174 raw_authors plus handle null authors, closes #18 2020-03-23T20:43:52Z 2020-03-23T20:43:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
0057c087a1d467b1770bebf3206e2cb008bc2b7f Upgrade to sqlite-utils 2.x, closes #20 2020-03-23T19:22:46Z 2020-03-23T19:22:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
219ffc2493cf7400c279d0fd15d5eed73f2cd402 assets in a separate table, closes #15 2020-03-23T19:17:25Z 2020-03-23T19:17:25Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
b7f6accec89c0deecb8fec6cc49fa4dd4d2afb47 Full-text search for more tables, closes #19 2020-03-23T19:06:31Z 2020-03-23T19:06:31Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
e35eec4343aa560c58c1634cc228d0d46c442304 Release 0.7 2020-03-11T02:47:32Z 2020-03-11T02:47:32Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
f12e26f78f5f3165b257caa6addcc29266da3888 Docs for commits command, closes #17 2020-03-11T02:47:20Z 2020-03-11T02:47:20Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
56c351893cb4d443a812de4470f0617f4f6c8aa8 commits now only gets new commits unless --all, refs #17 2020-03-11T02:42:55Z 2020-03-11T02:42:55Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
0cdceb9244a21fbd1e70a6ca0a76b2ed2ce4dd3f github-to-sqlite commits command, refs #17 2020-03-10T21:55:36Z 2020-03-10T21:55:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
9eb737090fafd0e5a7e314be48402374d99e9828 Release 0.6 2019-11-11T05:31:46Z 2019-11-11T05:31:46Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
1e6995a362e5b8f23331aafb84e631392eb81492 --auth is now optional, closes #9 2019-11-11T05:30:41Z 2019-11-11T05:30:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
0a2dddccd7eb6cedae128c08931f14f12d5bce70 'github-to-sqlite repos' now accepts multiple usernames 2019-11-11T05:02:33Z 2019-11-11T05:02:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
9c86d05f90bfe08b6d1cbc281cd5a76d4d120b81 Fetch repo topics using Accept header 2019-11-11T05:00:40Z 2019-11-11T05:00:40Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
1eb04e2ecb764d2e76a0e5731e16c3833df04c93 'releases' command to fetch releases, closes #11 2019-11-09T22:56:53Z 2019-11-09T22:56:53Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
50dc86acc2df6bb7246d14fb2fd016c75924d20f Rename test file so it actually runs 2019-11-09T22:39:21Z 2019-11-09T22:39:21Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
ae9035f8fe5aff1c54bff4c6b4c2e808a44f0f2a Release 0.5 2019-10-13T05:28:24Z 2019-10-13T05:28:24Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
8c9b5558a1549803ac0cb648c78a21767cccce86 issue-comments command, closes #7 Also added --issue option to issues command, for fetching one specific issue. 2019-10-13T05:24:25Z 2019-10-13T05:24:25Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
552543a74970f8a3a3f87f887be23a0c6eb1cb5b alter=True when upserting users 2019-10-07T04:01:41Z 2019-10-07T04:01:41Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
8c6251c31a05c58c2bfbef114247642d1b3dbb44 Release 0.4 2019-09-17T00:18:37Z 2019-09-17T00:18:37Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
8c9a9498159c4dfa1dff0593427cc3ee7df9a83c 'github-to-sqlite repos' command, closes #3 2019-09-17T00:17:42Z 2019-09-17T00:17:42Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
f697f247468516aa4ee13b1862b59e0dba18d00f Release 0.3 2019-09-14T21:49:27Z 2019-09-14T21:49:27Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
a4e0dc3407058b05966a1c37b48c8b8cb4bbad05 Extract license from repos table, closes #2 2019-09-14T21:46:49Z 2019-09-14T21:46:49Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
0fe96bc50fb3d7b1c7e4577db0ddf207eaeebbb9 Release 0.2 2019-09-14T21:31:17Z 2019-09-14T21:31:17Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
f1fa627a744f740a31b19dae812718838c3a6f6b github-to-sqlite starred' command, closes #1 2019-09-14T21:30:30Z 2019-09-14T21:30:36Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
321e0284c64dc48b2143311009886293c05edb07 Release 0.1.1 2019-09-14T19:19:33Z 2019-09-14T19:19:33Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
d3a0e4cedaa965061c6aa1a38ceffa0a3f00210e Removed accidental debugging code 2019-09-14T19:19:16Z 2019-09-14T19:19:16Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599
7387c88a3f84704548e81d43b91615c02b61a957 Implemented 'issues' OAuthed data fetching 2019-09-08T03:06:52Z 2019-09-08T03:06:52Z Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 github-to-sqlite 207052882 simonw 9599 simonw 9599

Next page

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]);