home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 392343690

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/292#issuecomment-392343690 https://api.github.com/repos/simonw/datasette/issues/292 392343690 MDEyOklzc3VlQ29tbWVudDM5MjM0MzY5MA== 9599 2018-05-27T16:08:25Z 2018-05-27T16:08:40Z OWNER

Turns out it's actually possible to pull data from other tables using the mechanism in the prototype:

{ "databases": { "wtr": { "tables": { "license": { "column_selects": { "count": "(select count(*) from license_frequency where license_frequency.license = license.id)" } } } } } } Performance using this technique is pretty terrible though:

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