home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 473708941

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/419#issuecomment-473708941 https://api.github.com/repos/simonw/datasette/issues/419 473708941 MDEyOklzc3VlQ29tbWVudDQ3MzcwODk0MQ== 9599 2019-03-17T19:58:11Z 2019-03-17T19:58:11Z OWNER

Some problems to solve:

  • Right now Datasette assumes it can always show the count of rows in a table, because this has been pre-calculated. If a database is mutable the pre-calculation trick no longer works, and for giant tables a select count(*) from X query can be expensive to run. Maybe we set a time limit on these? If time limit expires show "many rows"?
  • Maintaining a content hash of the table no longer makes sense if it is changing (though interestingly there's a .sha3sum built-in SQLite CLI command which takes a hash of the content and stays the same even through vacuum runs). Without that we need a different mechanism for calculating table colours. It also means that we can't do the special dbname-hash URL trick (see #418) at all if the database is opened as mutable.
{
    "total_count": 1,
    "+1": 1,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
421551434  
Powered by Datasette · Queries took 1.097ms · About: github-to-sqlite