home / github / issue_comments

Menu
  • GraphQL API

issue_comments: 1641082395

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/2104#issuecomment-1641082395 https://api.github.com/repos/simonw/datasette/issues/2104 1641082395 IC_kwDOBm6k_c5h0O4b 15178711 2023-07-18T22:41:37Z 2023-07-18T22:41:37Z CONTRIBUTOR For filtering virtual table's "shadow tables" (ex the FTS5 _content and most the spatialite tables), you can use `pragma_table_list` (first appeared in SQLite 3.37 (2021-11-27), which has a `type` column that calls out `type="shadow"` tables https://www.sqlite.org/pragma.html#pragma_table_list {"total_count": 1, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 1} 1808215339  
Powered by Datasette · Queries took 0.851ms