issue_comments

Table actions

3 rows where issue = 964400482

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, author_association, 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
895571420 https://github.com/simonw/sqlite-utils/issues/310#issuecomment-895571420 https://api.github.com/repos/simonw/sqlite-utils/issues/310 IC_kwDOCGYnMM41YVXc simonw 9599 2021-08-09T21:44:38Z 2021-08-09T21:44:38Z OWNER When I ship this I should update the TILs at https://til.simonwillison.net/cloudrun/tailing-cloud-run-request-logs and https://til.simonwillison.net/jq/flatten-nested-json-objects-jq to reference it. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} `sqlite-utils insert --flatten` option to flatten nested JSON 964400482  
895572309 https://github.com/simonw/sqlite-utils/issues/310#issuecomment-895572309 https://api.github.com/repos/simonw/sqlite-utils/issues/310 IC_kwDOCGYnMM41YVlV simonw 9599 2021-08-09T21:46:15Z 2021-08-09T21:46:15Z OWNER Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#flattening-nested-json-objects {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} `sqlite-utils insert --flatten` option to flatten nested JSON 964400482  
944918759 https://github.com/simonw/sqlite-utils/issues/310#issuecomment-944918759 https://api.github.com/repos/simonw/sqlite-utils/issues/310 IC_kwDOCGYnMM44UlDn rdtq 22523840 2021-10-16T13:54:56Z 2021-10-16T13:54:56Z NONE It would be cool if --flatten worked with `sqlite-utils memory` as well. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} `sqlite-utils insert --flatten` option to flatten nested JSON 964400482  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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