issue_comments
5 rows where issue = 1296222572
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
| id ▼ | html_url | issue_url | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1176550192 | https://github.com/simonw/datasette/issues/1768#issuecomment-1176550192 | https://api.github.com/repos/simonw/datasette/issues/1768 | IC_kwDOBm6k_c5GILsw | simonw 9599 | 2022-07-06T18:39:11Z | 2022-07-06T18:39:11Z | OWNER | Relevant Twitter thread: https://twitter.com/simonw/status/1544710944462254080 Looks like `python:3.10-slim-bullseye` is a good option, see https://pythonspeed.com/articles/base-image-python-docker-images/ | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Upgrade to 3.10.6-slim-bullseye Docker base image 1296222572 | |
| 1177966193 | https://github.com/simonw/datasette/issues/1768#issuecomment-1177966193 | https://api.github.com/repos/simonw/datasette/issues/1768 | IC_kwDOBm6k_c5GNlZx | simonw 9599 | 2022-07-07T17:25:22Z | 2022-07-07T17:25:22Z | OWNER | I tried this on Datasette Cloud and swapping `datasetteproject/datasette` to `python:3.10-slim-bullseye` as the base image dropped the overall image size from ~232MB to ~166MB - but note that I don't have SpatiaLite in that second image. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Upgrade to 3.10.6-slim-bullseye Docker base image 1296222572 | |
| 1214403875 | https://github.com/simonw/datasette/issues/1768#issuecomment-1214403875 | https://api.github.com/repos/simonw/datasette/issues/1768 | IC_kwDOBm6k_c5IYlUj | simonw 9599 | 2022-08-14T15:46:49Z | 2022-08-14T15:46:49Z | OWNER | https://hub.docker.com/layers/python/library/python/3.10.6-slim-bullseye/images/sha256-cf85cd32e60184a94d88a0103c289d09024abffaa77680d116d7cc837668ea15?context=explore is the most recent - `3.10.6-slim-bullseye`. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Upgrade to 3.10.6-slim-bullseye Docker base image 1296222572 | |
| 1214404690 | https://github.com/simonw/datasette/issues/1768#issuecomment-1214404690 | https://api.github.com/repos/simonw/datasette/issues/1768 | IC_kwDOBm6k_c5IYlhS | simonw 9599 | 2022-08-14T15:52:02Z | 2022-08-14T15:52:02Z | OWNER | Tested locally with: datasette package fixtures.db --extra-options="--setting sql_time_limit_ms 2500" \ -t datasette-package-python-upgrade And then: ``` docker run -p 8081:8001 datasette-package-python-upgrade INFO: Started server process [8] INFO: Waiting for application startup. INFO: Application startup complete. INFO: Uvicorn running on http://0.0.0.0:8001 (Press CTRL+C to quit) ``` <img width="832" alt="image" src="https://user-images.githubusercontent.com/9599/184544853-bc2d06cc-ff9a-47f3-9744-e8916e531929.png"> | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Upgrade to 3.10.6-slim-bullseye Docker base image 1296222572 | |
| 1214405023 | https://github.com/simonw/datasette/issues/1768#issuecomment-1214405023 | https://api.github.com/repos/simonw/datasette/issues/1768 | IC_kwDOBm6k_c5IYlmf | simonw 9599 | 2022-08-14T15:54:11Z | 2022-08-14T15:54:11Z | OWNER | Also trying this locally: datasette publish cloudrun fixtures.db --service issue-1768 https://issue-1768-j7hipcg4aq-uc.a.run.app/-/versions <img width="775" alt="image" src="https://user-images.githubusercontent.com/9599/184544946-7cbce9c6-4cb3-4efa-96d8-1741afd1d6f4.png"> | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | Upgrade to 3.10.6-slim-bullseye Docker base image 1296222572 |
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]);