issues: 855451460

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
855451460 MDU6SXNzdWU4NTU0NTE0NjA= 1297 Documentation: json1, and introspection endpoints 192568 open 0     0 2021-04-12T00:38:00Z 2021-04-12T01:29:33Z   CONTRIBUTOR  

https://docs.datasette.io/en/stable/facets.html notes that:

If your SQLite installation provides the json1 extension (you can check using /-/versions) Datasette will automatically detect columns that contain JSON arrays...

When I check -/versions I see two sections relevant to json1: "extensions": { "json1": null }, "compile_options": [ ... "ENABLE_JSON1",

The ENABLE_JSON1 makes me think json1 is likely available. But the "json1": null made me think it wasn't available (because of the null). It would help if the documentation provided clarity about how to know if json1 is installed. It would also be helpful if the /-/versions information signalled somehow that that is to be appended to the hostname or domain name (or whatever you want to call it, or simply show it, using example.com/-/versions instead of /-/versions. Likewise on that last point, for https://docs.datasette.io/en/stable/introspection.html#introspection , at least at some point on that page detailing where those introspection endpoints go. (Sometimes documentation can be so abbreviated that it's hard for new users to figure out what's going on.)

 107914493 issue     
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/1297/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
    

Links from other tables