issue_comments
15 rows where issue = 585626199
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 603560898 | https://github.com/simonw/datasette/issues/705#issuecomment-603560898 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzU2MDg5OA== | simonw 9599 | 2020-03-24T23:41:32Z | 2020-03-24T23:41:32Z | OWNER | I can switch over to deploying that using Cloud Run. Unfortunately if I move away from Zeit Now v1 (since it's no longer supported and might stop working) I don't think I'll be able to deploy a permanent URL for every commit hash that I push any more, which is a real shame. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603561207 | https://github.com/simonw/datasette/issues/705#issuecomment-603561207 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzU2MTIwNw== | simonw 9599 | 2020-03-24T23:42:42Z | 2020-03-24T23:42:42Z | OWNER | I'd like to still provide https://v0-35.datasette.io/ URLs for every named release, but I'm not sure how to best automate the provisioning of those subdomains. For the moment I'm going to focus on getting `latest.datasette.io` working again, using Cloud Run. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603582122 | https://github.com/simonw/datasette/issues/705#issuecomment-603582122 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzU4MjEyMg== | simonw 9599 | 2020-03-25T01:00:30Z | 2020-03-25T01:00:30Z | OWNER | I'm going to do this using GitHub Actions and the recipe from https://simonwillison.net/2020/Jan/21/github-actions-cloud-run/ First step: deploying manually using this: ``` datasette publish cloudrun fixtures.db \ -m fixtures.json \ --branch=7656fd64d8b6a32ebc34d89c1b8711cc5ea240f7 \ --version-note=7656fd64d8b6a32ebc34d89c1b8711cc5ea240f7 \ --extra-options="--config template_debug:1" \ --service=datasette-latest ``` | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603582241 | https://github.com/simonw/datasette/issues/705#issuecomment-603582241 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzU4MjI0MQ== | simonw 9599 | 2020-03-25T01:00:55Z | 2020-03-25T01:00:55Z | OWNER | That's live at https://datasette-latest-j7hipcg4aq-uc.a.run.app/ | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603599464 | https://github.com/simonw/datasette/issues/705#issuecomment-603599464 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzU5OTQ2NA== | simonw 9599 | 2020-03-25T02:07:16Z | 2020-03-25T02:07:16Z | OWNER | I need to verify `datasette.io` with Google. These instructions look good: https://cloud.google.com/endpoints/docs/openapi/verify-domain-name | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603599677 | https://github.com/simonw/datasette/issues/705#issuecomment-603599677 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzU5OTY3Nw== | simonw 9599 | 2020-03-25T02:08:11Z | 2020-03-25T02:08:11Z | OWNER | <img width="1197" alt="Webmaster_Central" src="https://user-images.githubusercontent.com/9599/77494367-cb6b0580-6e02-11ea-8cb3-8de1353d7d3e.png"> | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603599974 | https://github.com/simonw/datasette/issues/705#issuecomment-603599974 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzU5OTk3NA== | simonw 9599 | 2020-03-25T02:09:34Z | 2020-03-25T02:09:34Z | OWNER | I tried running this: $ now dns add datasette.io '@' TXT google-site-verification=wHw15S1fkNOMzk42PEVK6XLnSG9qEfyq6paO8_G4IVU | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603600064 | https://github.com/simonw/datasette/issues/705#issuecomment-603600064 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzYwMDA2NA== | simonw 9599 | 2020-03-25T02:09:56Z | 2020-03-25T02:09:56Z | OWNER | That worked: <img width="737" alt="Webmaster_Central" src="https://user-images.githubusercontent.com/9599/77494472-0b31ed00-6e03-11ea-9444-849b21bd91c8.png"> | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603600372 | https://github.com/simonw/datasette/issues/705#issuecomment-603600372 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzYwMDM3Mg== | simonw 9599 | 2020-03-25T02:11:11Z | 2020-03-25T02:11:11Z | OWNER | Now add the service mapping in Cloud Run: https://console.cloud.google.com/run/domains?project=datasette-222320 <img width="601" alt="Domain_mappings_–_Cloud_Run_–_datasette_–_Google_Cloud_Platform" src="https://user-images.githubusercontent.com/9599/77494538-387e9b00-6e03-11ea-8502-110f6d25526d.png"> | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603600553 | https://github.com/simonw/datasette/issues/705#issuecomment-603600553 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzYwMDU1Mw== | simonw 9599 | 2020-03-25T02:11:56Z | 2020-03-25T02:12:09Z | OWNER | ... and set up the CNAME record: $ now dns add datasette.io latest CNAME ghs.googlehosted.com. Got an error: > Error! A conflicting record exists "rec_e4c36ae94cf0a2b7b1781329". | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603601073 | https://github.com/simonw/datasette/issues/705#issuecomment-603601073 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzYwMTA3Mw== | simonw 9599 | 2020-03-25T02:13:44Z | 2020-03-25T02:13:44Z | OWNER | Removed the conflicting record with: $ now dns rm rec_e4c36ae94cf0a2b7b1781329 Then: $ now dns add datasette.io latest CNAME ghs.googlehosted.com. > Success! DNS record for domain datasette.io (rec_5b8855344da0be1861c4d55b) created under simonw [10s] | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603601247 | https://github.com/simonw/datasette/issues/705#issuecomment-603601247 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzYwMTI0Nw== | simonw 9599 | 2020-03-25T02:14:25Z | 2020-03-25T02:14:25Z | OWNER | Could take a while for the certificate to be issued: <img width="471" alt="Domain_mappings_–_Cloud_Run_–_datasette_–_Google_Cloud_Platform" src="https://user-images.githubusercontent.com/9599/77494719-ab881180-6e03-11ea-8953-07cd4ce5fdc3.png"> | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603602781 | https://github.com/simonw/datasette/issues/705#issuecomment-603602781 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzYwMjc4MQ== | simonw 9599 | 2020-03-25T02:20:09Z | 2020-03-25T02:20:09Z | OWNER | Now following steps in https://simonwillison.net/2020/Jan/21/github-actions-cloud-run/ - I've added the `GCP_SA_EMAIL` and `GCP_SA_KEY` secrets to this repository: https://github.com/simonw/datasette/settings/secrets | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603604105 | https://github.com/simonw/datasette/issues/705#issuecomment-603604105 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzYwNDEwNQ== | simonw 9599 | 2020-03-25T02:25:42Z | 2020-03-25T02:25:42Z | OWNER | https://latest.datasette.io/-/versions is now serving from Cloud Run. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 | |
| 603605246 | https://github.com/simonw/datasette/issues/705#issuecomment-603605246 | https://api.github.com/repos/simonw/datasette/issues/705 | MDEyOklzc3VlQ29tbWVudDYwMzYwNTI0Ng== | simonw 9599 | 2020-03-25T02:30:24Z | 2020-03-25T02:30:24Z | OWNER | It worked! After that push https://latest.datasette.io/-/versions updated to show `90015b26895fd2bd29676bc375f096102b0587ed` as the version note. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | latest.datasette.io is no longer updating 585626199 |
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]);