issue_comments: 1302715662

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-1302715662 https://api.github.com/repos/simonw/datasette/issues/1882 1302715662 IC_kwDOBm6k_c5Npd0O 9599 2022-11-03T21:50:27Z 2022-11-03T21:50:27Z OWNER

API design for this: POST /db/-/create Authorization: Bearer xxx Content-Type: application/json { "table": { "name": "my new table", "columns": [ { "name": "id", "type": "integer" }, { "name": "title", "type": "text" } ] "pk": "id" } } Supported column types are:

  • integer
  • text
  • float (even though SQLite calls it a "real")
  • blob

This matches my design for sqlite-utils: https://sqlite-utils.datasette.io/en/stable/cli.html#cli-create-table

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