issue_comments: 697859772
This data as json
| html_url | issue_url | id | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
|---|---|---|---|---|---|---|---|---|---|---|---|
| https://github.com/simonw/sqlite-utils/issues/172#issuecomment-697859772 | https://api.github.com/repos/simonw/sqlite-utils/issues/172 | 697859772 | MDEyOklzc3VlQ29tbWVudDY5Nzg1OTc3Mg== | 9599 | 2020-09-23T18:38:43Z | 2020-09-23T18:38:52Z | OWNER | I wonder if I could make this faster by separating it out into a few steps: - Create the new lookup table with all of the distinct rows - Add the blank foreign key column - run a `UPDATE table SET blah_id = (select id from lookup where thang = table.thang)` - Drop the value columns | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 707427200 |