Closed MikeCoats closed 8 months ago
See details of how I tested this here:
Short version: having applied this fix, the following command (on simulated aarch64
):
sqlite-utils memory "select spatialite_version()" --load-extension=spatialite
Outputs:
[{"spatialite_version()": "5.0.1"}]
Initially, I found an issue in
datasette
where it wouldn’t findspatialite
when running on my Radxa Rock 5B - an RK3588 powered SBC, running the arm64 build of Debian Bullseye. I confirmed the same behaviour on my Raspberry Pi 4 - a BCM2711 powered SBC, running the arm64 build of Debian Bookworm.I did some digging and realised the issue originates in this project. Even with the
libsqlite3-mod-spatialite
package installed,pytest
skips all of the GIS tests in the project.I tracked the issue down to the
find_sqlite()
function in theutils.py
file. TheSPATIALITE_PATHS
array doesn’t have an entry for the location of this module on arm64 linux.