home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 530028567

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/dogsheep/twitter-to-sqlite/issues/9#issuecomment-530028567 https://api.github.com/repos/dogsheep/twitter-to-sqlite/issues/9 530028567 MDEyOklzc3VlQ29tbWVudDUzMDAyODU2Nw== 9599 2019-09-10T16:59:25Z 2019-09-10T16:59:25Z MEMBER

By default in SQLite foreign key constraints are not enforced (you need to run PRAGMA foreign_keys = ON; to enforce them).

We will take advantage of this - even though the following table has foreign keys against user we will allow IDs to populate that table without a corresponding user record.

In the future we may add a command that can backfill missing user records.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
491791152  
Powered by Datasette · Queries took 0.924ms · About: github-to-sqlite