issues: 325294102

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
325294102 MDU6SXNzdWUzMjUyOTQxMDI= 278 Build smallest possible Docker image with Datasette plus recent SQLite (with json1) plus Spatialite 4.4.0 9599 closed 0     3 2018-05-22T13:28:40Z 2018-05-23T17:43:36Z 2018-05-23T17:43:36Z OWNER  

A Dockerfile that does the following:

  • Bundles Datasette master
  • Python 3.6 most recent version (or 3.7 if it has been released)
  • SQLite 3.23.1 (or most recent release) such that "import sqite3" in Python gets that version. Ideally with the json1 module baked in by default, but having it loadable as an optional module is fine too
  • SpatiaLite 4.4.0-RC0 (or most recent version) such that it can be loaded as an optional module
  • Uses multi-stage builds to stay as small as possible

Note that the current "release" of SpatiaLite is 4.3.0 which is missing key features like https://www.gaia-gis.it/fossil/libspatialite/wiki?name=KNN - 4.4.0 probably needs to be compiled from source.

I don't know the best way to get a current SQLite version bundled for Python 3. Maybe https://github.com/coleifer/pysqlite3 ?

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

Links from other tables