issue_comments: 747833639

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-747833639 https://api.github.com/repos/simonw/datasette/issues/1150 747833639 MDEyOklzc3VlQ29tbWVudDc0NzgzMzYzOQ== 9599 2020-12-18T02:49:40Z 2020-12-18T03:52:12Z OWNER

I'm going to use five tables to start off with:

  • databases - a list of databases. Each one has a name, path (if it's on disk), is_memory, schema_version
  • tables - a list of tables. Each row is database_name, table_name, sql (the create table statement) - may add more tables in the future, in particular maybe a last_row_count to cache results of counting the rows.
  • columns - a list of columns. It's the output of pragma_table_xinfo with the database_name and table_name columns added at the beginning.
  • foreign_keys - a list of foreign keys - pragma_foreign_key_list output plus database_name and table_name.
  • indexes - a list of indexes - pragma_table_xinfo output plus database_name and table_name.
 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 770436876