Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Official Docker image of Datasette does not support VirtualKNN2 #2313

Open
rdmurphy opened this issue Mar 30, 2024 · 0 comments
Open

Official Docker image of Datasette does not support VirtualKNN2 #2313

rdmurphy opened this issue Mar 30, 2024 · 0 comments

Comments

@rdmurphy
Copy link

rdmurphy commented Mar 30, 2024

Hello! I hit this last night while getting my database of LA County's election results online. Back when I did this in 2022 everything worked fine, but it appears that if you have a reasonably up to date copy of libspatialite on your computer and use it to create a database (via sqlite-utils) it creates a database that expects to be used with a copy of the library that supports the new-ish KNN2 feature.

I ended up just writing my own Dockerfile to get this working (using an Alpine image), but I think the issue the official image is having is that Debian's stable version of libsqlite3-mod-spatialite is still on 5.0.* instead of 5.1.* (when I believe KNN2 was added). Debian's package repository does have a reference to a 5.1.* version, but it's in the unstable package repository.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant