Custom SQL query returning 1 row (hide)

Query parameters

752966476 MDU6SXNzdWU3NTI5NjY0NzY= 1114 --load-extension=spatialite not working with datasetteproject/datasette docker image 2182 closed 0     4 2020-11-29T17:35:20Z 2020-11-29T20:17:11Z 2020-11-29T17:37:45Z NONE added the `--load-extension=spatialite` shortcut looking for the extension in these places: However, in the datasetteproject/datasette docker image the file is at `/usr/local/lib/`. This results in the example command [here]( failing: ``` % docker run --rm -p 8001:8001 -v `pwd`:/mnt datasetteproject/datasette datasette -p 8001 -h /mnt/data.db --load-extension=spatialite Error: Could not find SpatiaLite extension ``` But it does work when given an explicit path: ``` % docker run --rm -p 8001:8001 -v `pwd`:/mnt datasetteproject/datasette datasette -p 8001 -h /mnt/data.db --load-extension=/usr/local/lib/ INFO: Started server process [1] INFO: Waiting for application startup. INFO: Application startup complete. INFO: Uvicorn running on (Press CTRL+C to quit) ... ``` Perhaps `SPATIALITE_PATHS` should include `/usr/local/lib/`? 107914493 issue