issue_comments: 1302818784

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/1882#issuecomment-1302818784 https://api.github.com/repos/simonw/datasette/issues/1882 1302818784 IC_kwDOBm6k_c5Np2_g 9599 2022-11-04T00:25:18Z 2022-11-04T16:12:39Z OWNER

On that basis I think the core API design should change to this: POST /db/-/create Authorization: Bearer xxx Content-Type: application/json { "name": "my new table", "columns": [ { "name": "id", "type": "integer" }, { "name": "title", "type": "text" } ] "pk": "id" } This leaves room for a "rows": [] key at the root too. Having that as a child of "table" felt unintuitive to me, and I didn't like the way this looked either:

json { "table": { "name": "my_new_table" }, "rows": [ {"id": 1, "title": "Title"} ] } Weird to have the table name nested inside table when rows wasn't.

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