issue_comments
8 rows where "created_at" is on date 2019-05-19 sorted by updated_at
This data as json, CSV (advanced)
id | html_url | issue_url | node_id | user | created_at | updated_at ▼ | author_association | body | reactions | issue | performed_via_github_app |
---|---|---|---|---|---|---|---|---|---|---|---|
493728476 | https://github.com/simonw/datasette/issues/421#issuecomment-493728476 | https://api.github.com/repos/simonw/datasette/issues/421 | MDEyOklzc3VlQ29tbWVudDQ5MzcyODQ3Ng== | simonw 9599 | 2019-05-19T05:32:37Z | 2019-05-19T05:32:37Z | OWNER | https://datasette.readthedocs.io/en/latest/performance.html#http-caching | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Documentation for ?_hash=1 and Datasette's hashed URL caching 421985685 | |
493781417 | https://github.com/simonw/datasette/issues/473#issuecomment-493781417 | https://api.github.com/repos/simonw/datasette/issues/473 | MDEyOklzc3VlQ29tbWVudDQ5Mzc4MTQxNw== | simonw 9599 | 2019-05-19T18:45:15Z | 2019-05-19T18:45:15Z | OWNER | This expands on the refactoring work from https://github.com/simonw/datasette/commit/6da567dda953c7ac0e5500f17d8e220467a3499e | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Plugin hook: filters_from_request 445850934 | |
493784506 | https://github.com/simonw/datasette/issues/470#issuecomment-493784506 | https://api.github.com/repos/simonw/datasette/issues/470 | MDEyOklzc3VlQ29tbWVudDQ5Mzc4NDUwNg== | simonw 9599 | 2019-05-19T19:28:43Z | 2019-05-19T19:28:43Z | OWNER | Demo: https://latest.datasette.io/-/databases | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | /-/databases showing currently attached database details 444997937 | |
493785170 | https://github.com/simonw/datasette/issues/474#issuecomment-493785170 | https://api.github.com/repos/simonw/datasette/issues/474 | MDEyOklzc3VlQ29tbWVudDQ5Mzc4NTE3MA== | simonw 9599 | 2019-05-19T19:36:25Z | 2019-05-19T19:36:25Z | OWNER | This needs to happen in two places: https://github.com/simonw/datasette/blob/260085838887ee343f4d3b177c422e7aef5ade9d/datasette/templates/database.html#L59-L61 https://github.com/simonw/datasette/blob/260085838887ee343f4d3b177c422e7aef5ade9d/datasette/views/database.py#L75-L80 Plus new unit test. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Do not allow downloads of mutable databases 445855789 | |
493793021 | https://github.com/simonw/datasette/issues/463#issuecomment-493793021 | https://api.github.com/repos/simonw/datasette/issues/463 | MDEyOklzc3VlQ29tbWVudDQ5Mzc5MzAyMQ== | simonw 9599 | 2019-05-19T21:24:44Z | 2019-05-19T21:24:44Z | OWNER | https://datasette.readthedocs.io/en/latest/changelog.html#v0-28 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Write release notes for 0.28 443034003 | |
493794975 | https://github.com/simonw/datasette/issues/478#issuecomment-493794975 | https://api.github.com/repos/simonw/datasette/issues/478 | MDEyOklzc3VlQ29tbWVudDQ5Mzc5NDk3NQ== | simonw 9599 | 2019-05-19T21:53:04Z | 2019-05-19T21:53:04Z | OWNER | Example build that's taking ages to push the release: https://travis-ci.org/simonw/datasette/builds/534573406 Here's the relevant Travis CI configuration: https://github.com/simonw/datasette/blob/e518f76c5f5dd0138032bfb26387f5bb91086a3f/.travis.yml#L31-L52 | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Make it so Docker build doesn't delay PyPI release 445868234 | |
493797127 | https://github.com/simonw/datasette/issues/451#issuecomment-493797127 | https://api.github.com/repos/simonw/datasette/issues/451 | MDEyOklzc3VlQ29tbWVudDQ5Mzc5NzEyNw== | simonw 9599 | 2019-05-19T22:23:43Z | 2019-05-19T22:23:43Z | OWNER | Done - and shipped a release! See https://simonwillison.net/2019/May/19/datasette-0-28/ | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Update README 440313209 | |
493799012 | https://github.com/simonw/datasette/issues/469#issuecomment-493799012 | https://api.github.com/repos/simonw/datasette/issues/469 | MDEyOklzc3VlQ29tbWVudDQ5Mzc5OTAxMg== | simonw 9599 | 2019-05-19T22:53:18Z | 2019-05-19T22:53:18Z | OWNER | I manually tested this against heroku, cloud run and nowv1 and all three worked as expected - in particular they all offered working "download this database" links. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | publish commands should use new -i option 444749373 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [issue_comments] ( [html_url] TEXT, [issue_url] TEXT, [id] INTEGER PRIMARY KEY, [node_id] TEXT, [user] INTEGER REFERENCES [users]([id]), [created_at] TEXT, [updated_at] TEXT, [author_association] TEXT, [body] TEXT, [reactions] TEXT, [issue] INTEGER REFERENCES [issues]([id]) , [performed_via_github_app] TEXT); CREATE INDEX [idx_issue_comments_issue] ON [issue_comments] ([issue]); CREATE INDEX [idx_issue_comments_user] ON [issue_comments] ([user]);
updated_at (date) 1 ✖