issue_comments: 747803268

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/1150#issuecomment-747803268 https://api.github.com/repos/simonw/datasette/issues/1150 747803268 MDEyOklzc3VlQ29tbWVudDc0NzgwMzI2OA== 9599 2020-12-18T01:08:40Z 2020-12-18T01:08:40Z OWNER

Next step: design a schema for the in-memory database table that exposes all of the tables.

I want to support things like:

  • Show me all of the tables
  • Show me the columns in a table
  • Show me all tables that contain a tags column
  • Show me the indexes
  • Show me every table configured for full-text search

Maybe a starting point would be to build concrete tables using the results of things like PRAGMA foreign_key_list(table) and PRAGMA table_xinfo(table) - note though that table_xinfo is SQLite 3.26.0 or higher, as shown here: https://github.com/simonw/datasette/blob/5e9895c67f08e9f42acedd3d6d29512ac446e15f/datasette/utils/init.py#L563-L579

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