Datasette 1.0 JSON API (and documentation)

[simonw]

The new JSON API in a stable, documented form.

[simonw]

This is mainly happening here:

• Redesign default .json format #782

[simonw]

Idea: I could add Pydantic https://pydantic-docs.helpmanual.io/usage/schema/ as an optional test dependency and use it to generate JSON schemas and run validation against examples in the API documentation.

Maybe generate API documentation from it too?

[simonw]

... maybe Datasette itself should include interactive API documentation, in addition to documenting it in the manual?

/dbname/table/-/apidocs could return documentation about the specific table, taking into account columns and types.