issue_comments: 1498275621

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/2049#issuecomment-1498275621 https://api.github.com/repos/simonw/datasette/issues/2049 1498275621 IC_kwDOBm6k_c5ZTd8l 9599 2023-04-05T23:23:01Z 2023-04-05T23:23:01Z OWNER

The default representation here can be even smaller.

For rows it's this:

json { "ok": true, "next": "d,v", "rows": [...] } For SQL queries I'm considering this: json { "ok": true, "rows": [...] } I considered adding "sql" and "params" too, but on further thought those would be entirely a waste of bytes the majority of the time. If a user wants those they can request them with an ?_extra=query as seen here:

http://localhost:8001/content/releases.json?_size=0&_extra=query

json { "ok": true, "next": null, "query": { "sql": "select html_url, id, author, node_id, tag_name, target_commitish, name, draft, prerelease, created_at, published_at, body, repo, reactions, mentions_count from releases order by id limit 1", "params": {} }, "rows": [] }

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