issue_comments: 344810525

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/datasette/issues/46#issuecomment-344810525 https://api.github.com/repos/simonw/datasette/issues/46 344810525 MDEyOklzc3VlQ29tbWVudDM0NDgxMDUyNQ== 54999 2017-11-16T04:11:25Z 2017-11-16T04:11:25Z CONTRIBUTOR

@simonw On the spatialite support, here is some info to make it work and a screenshot:

I used the following Dockerfile: ``` FROM prolocutor/python3-sqlite-ext:3.5.1-spatialite as build

RUN mkdir /code ADD . /code/

RUN pip install /code/

EXPOSE 8001 CMD ["datasette", "serve", "/code/ne.sqlite", "--host", "0.0.0.0"] ```

and added this to prepare_connection: conn.enable_load_extension(True) conn.execute("SELECT load_extension('/usr/local/lib/mod_spatialite.so')")

 
{
    "total_count": 1,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 1,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 271301468