home / github / issues

Menu
  • Search all tables
  • GraphQL API

issues: 1421529723

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
1421529723 I_kwDOBm6k_c5UutJ7 1850 Write API in Datasette core 9599 closed 0   8658075 13 2022-10-24T22:13:24Z 2022-11-29T20:11:20Z 2022-11-29T20:11:20Z OWNER  

I need this for Datasette Cloud, and in thinking it through I realized that it's really time Datasette grew a default write API as well.

I'm going to mostly model this off sqlite-utils, since I've spent a bunch of time iterating on a pseudo-JSON API for that over the past few years (piping JSON to stdin etc).

I want this for Datasette 1.0. I'm going to be building it in the new 1.0-dev branch, which is automatically deployed to https://latest-1-0-dev.datasette.io/ running on Cloud Run.

API features to build:

  • [x] #1852
  • [x] #1856
  • [x] #1857
  • [x] #1858
  • [x] #1859
  • [x] #1871
  • [x] #1888
  • [x] #1868
  • [x] #1851
  • [x] #1863
  • [x] #1864
  • [x] #1866
  • [x] https://github.com/simonw/datasette/issues/1882
  • [x] #1862
  • [x] #1874
  • [x] https://github.com/simonw/datasette/issues/1887
  • [x] #1877

Bumped to later on:

  • 1855

  • 1878

  • 1873

  • 1875

  • Make sure CORS works
  • https://github.com/simonw/datasette/issues/1889
  • Alter a table - sqlite-utils transform style (more powerful than straight ALTER)
  • Execute SQL against a write connection
  • Maybe even multiple write SQL statements bundled in a single transaction
  • https://github.com/simonw/datasette/issues/1867
107914493 issue    
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/1850/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  completed

Links from other tables

  • 1 row from issues_id in issues_labels
  • 13 rows from issue in issue_comments
Powered by Datasette · Queries took 0.738ms · About: github-to-sqlite