issues: 327420945

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
327420945 MDU6SXNzdWUzMjc0MjA5NDU= 297 datasette publish Dockerfile should use python:3.6-slim-stretch 9599 closed 0     1 2018-05-29T17:40:08Z 2018-05-31T14:44:37Z 2018-05-31T14:44:37Z OWNER  

Right now the Dockerfile generated by datasette package and datasette publish uses this:

https://github.com/simonw/datasette/blob/b0a95da96386ddf99816911e08df86178ffa9a89/datasette/utils.py#L269

This appears to result in a SQLite version of 3.8.7.1 - https://parlgov.datasettes.com/-/versions

"sqlite": { "extensions": {}, "fts_versions": [ "FTS4", "FTS3" ], "version": "3.8.7.1" }

Meanwhile, https://fivethirtyeight.datasettes.com/-/versions is deployed with this Dockerfile https://github.com/simonw/fivethirtyeight-datasette/blob/0849901cae06e957fe04892cd4033bdcd1fcf966/Dockerfile which uses FROM python:3.6-slim-stretch and results in the following version report:

"sqlite": { "extensions": { "json1": null }, "fts_versions": [ "FTS5", "FTS4", "FTS3" ], "version": "3.16.2" }

So not only do we get a more recent SQLite (including https://www.sqlite.org/rowvalue.html added in 3.15) but we also get FTS5 and json1 as well.

Refs #191

107914493 issue     
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/297/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