issue_comments: 474399630

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/datasette/issues/420#issuecomment-474399630 https://api.github.com/repos/simonw/datasette/issues/420 474399630 MDEyOklzc3VlQ29tbWVudDQ3NDM5OTYzMA== 9599 2019-03-19T14:38:14Z 2019-03-19T14:38:14Z OWNER

Most of these can be replaced with relatively straight-forward direct introspection of the SQLite table.

The one exception is the incoming foreign keys: these can only be found by inspecting ALL of the other tables.

This requires running PRAGMA foreign_key_list([table_name]) against every other table in the database. How expensive is doing this on a database with hundreds of tables?

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 421971339