Loading spatialite extension fails in SQLite under MacOS

[digital-idiot]

Solution to issue cannot be found in the documentation.

• [X] I checked the documentation.

Issue

Loading spatialite extension in SQLite fails stating:

dlsym(0x8bb10240, sqlite3_spatialite_init): symbol not found.

Trying the following snippet in Python:

import sqlite3
# setup an in-memory database
con = sqlite3.connect(':memory:')
# enable loading extensions and load spatialite
con.enable_load_extension(True)
try:
    con.load_extension('mod_spatialite.so')
except sqlite3.OperationalError:
    con.load_extension('libspatialite.so')

results into:

OperationalError: dlopen(mod_spatialite.so.dylib, 0x000A): tried: 'mod_spatialite.so.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OSmod_spatialite.so.dylib' (no such file), '~/micromamba/envs/PyDev/lib/mod_spatialite.so.dylib' (no such file), '~/micromamba/envs/PyDev/bin/../lib/mod_s

Related Issue: #49

Installed packages

```shell List of packages in environment: "~/micromamba/envs/PyDev" Name Version Build Channel ────────────────────────────────────────────────────────────────────────────────────────────── affine 2.4.0 pyhd8ed1ab_0 conda-forge aiohttp 3.9.5 py312he37b823_0 conda-forge aiosignal 1.3.1 pyhd8ed1ab_0 conda-forge anyio 4.4.0 pyhd8ed1ab_0 conda-forge aom 3.9.1 h7bae524_0 conda-forge appnope 0.1.4 pyhd8ed1ab_0 conda-forge argon2-cffi 23.1.0 pyhd8ed1ab_0 conda-forge argon2-cffi-bindings 21.2.0 py312h02f2b3b_4 conda-forge arrow 1.3.0 pyhd8ed1ab_0 conda-forge asttokens 2.4.1 pyhd8ed1ab_0 conda-forge async-lru 2.0.4 pyhd8ed1ab_0 conda-forge atlite 0.2.13 pyhd8ed1ab_0 conda-forge atomicwrites 1.4.1 pyhd8ed1ab_0 conda-forge attrs 23.2.0 pyh71513ae_0 conda-forge aws-c-auth 0.7.22 h8a62e84_10 conda-forge aws-c-cal 0.7.1 h94d0942_1 conda-forge aws-c-common 0.9.23 h99b78c6_0 conda-forge aws-c-compression 0.2.18 h94d0942_7 conda-forge aws-c-event-stream 0.4.2 hb74cd8f_15 conda-forge aws-c-http 0.8.2 had1507a_6 conda-forge aws-c-io 0.14.10 hcdb10ff_1 conda-forge aws-c-mqtt 0.10.4 h856d8ab_8 conda-forge aws-c-s3 0.6.0 ha9fd6de_2 conda-forge aws-c-sdkutils 0.1.16 h94d0942_3 conda-forge aws-checksums 0.1.18 h94d0942_7 conda-forge aws-crt-cpp 0.27.3 h9d3339c_2 conda-forge aws-sdk-cpp 1.11.329 he6360a2_9 conda-forge awscli 1.33.40 py312h81bd7bf_0 conda-forge azure-core-cpp 1.12.0 hd01fc5c_0 conda-forge azure-identity-cpp 1.8.0 h0a11218_1 conda-forge azure-storage-blobs-cpp 12.11.0 h77cc766_1 conda-forge azure-storage-common-cpp 12.6.0 h7024f69_1 conda-forge azure-storage-files-datalake-cpp 12.10.0 h64d02d0_1 conda-forge babel 2.14.0 pyhd8ed1ab_0 conda-forge beautifulsoup4 4.12.3 pyha770c72_0 conda-forge bleach 6.1.0 pyhd8ed1ab_0 conda-forge blinker 1.8.2 pyhd8ed1ab_0 conda-forge blosc 1.21.6 h5499902_0 conda-forge bokeh 3.5.0 pyhd8ed1ab_0 conda-forge boto3 1.34.158 pyhd8ed1ab_0 conda-forge botocore 1.34.158 pyge310_1234567_0 conda-forge bottleneck 1.4.0 py312hbebd99a_1 conda-forge bqplot 0.12.43 pyhd8ed1ab_0 conda-forge branca 0.7.2 pyhd8ed1ab_0 conda-forge brotli 1.1.0 hb547adb_1 conda-forge brotli-bin 1.1.0 hb547adb_1 conda-forge brotli-python 1.1.0 py312h9f69965_1 conda-forge bzip2 1.0.8 h99b78c6_7 conda-forge c-ares 1.32.2 h99b78c6_0 conda-forge ca-certificates 2024.7.4 hf0a4a13_0 conda-forge cached-property 1.5.2 hd8ed1ab_1 conda-forge cached_property 1.5.2 pyha770c72_1 conda-forge cachetools 5.4.0 pyhd8ed1ab_0 conda-forge cads-api-client 1.1.0 pyhd8ed1ab_0 conda-forge cairo 1.18.0 hb4a6bf7_3 conda-forge cdsapi 0.7.0 pyhd8ed1ab_0 conda-forge ceres-solver 2.2.0 h4929e67_3 conda-forge certifi 2024.7.4 pyhd8ed1ab_0 conda-forge cffi 1.16.0 py312h8e38eb3_0 conda-forge cfgrib 0.9.14.0 pyhd8ed1ab_0 conda-forge cfitsio 4.4.1 h793ed5c_0 conda-forge cftime 1.6.4 py312hbebd99a_0 conda-forge charset-normalizer 3.3.2 pyhd8ed1ab_0 conda-forge click 8.1.7 unix_pyh707e725_0 conda-forge click-plugins 1.1.1 py_0 conda-forge cligj 0.7.2 pyhd8ed1ab_1 conda-forge cloudpickle 3.0.0 pyhd8ed1ab_0 conda-forge colorama 0.4.6 pyhd8ed1ab_0 conda-forge colour 0.1.5 pyhd8ed1ab_1 conda-forge comm 0.2.2 pyhd8ed1ab_0 conda-forge contourpy 1.2.1 py312h0fef576_0 conda-forge cpd 0.5.5 h420ef59_2 conda-forge cryptography 42.0.8 py312had01cb0_0 conda-forge cycler 0.12.1 pyhd8ed1ab_0 conda-forge cytoolz 0.12.3 py312he37b823_0 conda-forge dask 2024.7.0 pyhd8ed1ab_0 conda-forge dask-core 2024.7.0 pyhd8ed1ab_0 conda-forge dask-expr 1.1.7 pyhd8ed1ab_0 conda-forge dataclasses 0.8 pyhc8e2a94_3 conda-forge dateparser 1.2.0 pyhd8ed1ab_0 conda-forge dav1d 1.2.1 hb547adb_0 conda-forge debugpy 1.8.2 py312h5c2e7bc_0 conda-forge decorator 5.1.1 pyhd8ed1ab_0 conda-forge defusedxml 0.7.1 pyhd8ed1ab_0 conda-forge distributed 2024.7.0 pyhd8ed1ab_0 conda-forge docutils 0.16 py312h81bd7bf_4 conda-forge draco 1.5.7 h2ffa867_0 conda-forge earthengine-api 0.1.412 pyhd8ed1ab_0 conda-forge eccodes 2.36.0 hce07c50_0 conda-forge ee_extra 0.0.15 pyhd8ed1ab_0 conda-forge eerepr 0.0.4 pyhd8ed1ab_0 conda-forge eigen 3.4.0 hc021e02_0 conda-forge entrypoints 0.4 pyhd8ed1ab_0 conda-forge exceptiongroup 1.2.2 pyhd8ed1ab_0 conda-forge executing 2.0.1 pyhd8ed1ab_0 conda-forge expat 2.6.2 hebf3989_0 conda-forge ffmpeg 7.0.1 gpl_h5b99759_104 conda-forge ffmpeg-python 0.2.0 py_0 conda-forge fgt 0.4.11 hf4e0b24_0 conda-forge filelock 3.15.4 pyhd8ed1ab_0 conda-forge findlibs 0.0.5 pyhd8ed1ab_0 conda-forge fiona 1.9.6 py312h17a5523_3 conda-forge flask 3.0.3 pyhd8ed1ab_0 conda-forge fmt 10.2.1 h2ffa867_0 conda-forge folium 0.17.0 pyhd8ed1ab_0 conda-forge font-ttf-dejavu-sans-mono 2.37 hab24e00_0 conda-forge font-ttf-inconsolata 3.000 h77eed37_0 conda-forge font-ttf-source-code-pro 2.038 h77eed37_0 conda-forge font-ttf-ubuntu 0.83 h77eed37_2 conda-forge fontconfig 2.14.2 h82840c6_0 conda-forge fonts-conda-ecosystem 1 0 conda-forge fonts-conda-forge 1 0 conda-forge fonttools 4.53.1 py312h7e5086c_0 conda-forge fqdn 1.5.1 pyhd8ed1ab_0 conda-forge freetype 2.12.1 hadb7bae_2 conda-forge freexl 2.0.0 hfbad9fb_0 conda-forge fribidi 1.0.10 h27ca646_0 conda-forge frozenlist 1.4.1 py312he37b823_0 conda-forge fsspec 2024.6.1 pyhff2d567_0 conda-forge future 1.0.0 pyhd8ed1ab_0 conda-forge gdal 3.9.1 py312h69a40ad_7 conda-forge gdown 5.2.0 pyhd8ed1ab_0 conda-forge geeadd 0.5.6 pyhd8ed1ab_0 conda-forge geemap 0.33.1 pyhd8ed1ab_0 conda-forge geocoder 1.38.1 py_1 conda-forge geojson 3.1.0 pyhd8ed1ab_0 conda-forge geopandas 1.0.1 pyhd8ed1ab_0 conda-forge geopandas-base 1.0.1 pyha770c72_0 conda-forge geos 3.12.2 h00cdb27_0 conda-forge geotiff 1.7.3 h7e5fb84_1 conda-forge gettext 0.22.5 h8fbad5d_2 conda-forge gettext-tools 0.22.5 h8fbad5d_2 conda-forge gflags 2.2.2 hc88da5d_1004 conda-forge giflib 5.2.2 h93a5062_0 conda-forge glog 0.7.1 heb240a5_0 conda-forge gmp 6.3.0 h7bae524_2 conda-forge gnutls 3.7.9 hd26332c_0 conda-forge google-api-core 2.19.1 pyhd8ed1ab_0 conda-forge google-api-python-client 2.137.0 pyhd8ed1ab_0 conda-forge google-auth 2.32.0 pyhff2d567_0 conda-forge google-auth-httplib2 0.2.0 pyhd8ed1ab_0 conda-forge google-auth-oauthlib 1.2.1 pyhd8ed1ab_0 conda-forge google-cloud-core 2.4.1 pyhd8ed1ab_0 conda-forge google-cloud-storage 2.18.0 pyhff2d567_0 conda-forge google-crc32c 1.1.2 py312h80a10bc_5 conda-forge google-resumable-media 2.7.0 pyhd8ed1ab_0 conda-forge googleapis-common-protos 1.63.2 pyhd8ed1ab_0 conda-forge graphite2 1.3.13 hebf3989_1003 conda-forge greenlet 3.0.3 py312h20a0b95_0 conda-forge grpcio 1.62.2 py312h17030e7_0 conda-forge h11 0.14.0 pyhd8ed1ab_0 conda-forge h2 4.1.0 pyhd8ed1ab_0 conda-forge harfbuzz 9.0.0 h997cde5_1 conda-forge hdf4 4.2.15 h2ee6834_7 conda-forge hdf5 1.14.3 nompi_hec07895_105 conda-forge hpack 4.0.0 pyh9f0ad1d_0 conda-forge httpcore 1.0.5 pyhd8ed1ab_0 conda-forge httplib2 0.22.0 pyhd8ed1ab_0 conda-forge httpx 0.27.0 pyhd8ed1ab_0 conda-forge hyperframe 6.0.1 pyhd8ed1ab_0 conda-forge icu 75.1 hfee45f7_0 conda-forge idna 3.7 pyhd8ed1ab_0 conda-forge importlib-metadata 8.0.0 pyha770c72_0 conda-forge importlib_metadata 8.0.0 hd8ed1ab_0 conda-forge importlib_resources 6.4.0 pyhd8ed1ab_0 conda-forge iniconfig 2.0.0 pyhd8ed1ab_0 conda-forge ipyevents 2.0.2 pyhd8ed1ab_0 conda-forge ipyfilechooser 0.6.0 pyhd8ed1ab_0 conda-forge ipykernel 6.29.5 pyh57ce528_0 conda-forge ipyleaflet 0.18.2 pyhd8ed1ab_0 conda-forge ipython 8.26.0 pyh707e725_0 conda-forge ipytree 0.2.2 pyhd8ed1ab_0 conda-forge ipywidgets 8.1.3 pyhd8ed1ab_0 conda-forge isoduration 20.11.0 pyhd8ed1ab_0 conda-forge itsdangerous 2.2.0 pyhd8ed1ab_0 conda-forge jasper 4.2.4 h6c4e4ef_0 conda-forge jedi 0.19.1 pyhd8ed1ab_0 conda-forge jinja2 3.1.4 pyhd8ed1ab_0 conda-forge jmespath 1.0.1 pyhd8ed1ab_0 conda-forge joblib 1.4.2 pyhd8ed1ab_0 conda-forge js2py 0.74 pyhd8ed1ab_0 conda-forge json-c 0.17 he54c16a_1 conda-forge json5 0.9.25 pyhd8ed1ab_0 conda-forge jsonpointer 3.0.0 py312h81bd7bf_0 conda-forge jsonschema 4.23.0 pyhd8ed1ab_0 conda-forge jsonschema-specifications 2023.12.1 pyhd8ed1ab_0 conda-forge jsonschema-with-format-nongpl 4.23.0 hd8ed1ab_0 conda-forge jupyter-lsp 2.2.5 pyhd8ed1ab_0 conda-forge jupyter_client 8.6.2 pyhd8ed1ab_0 conda-forge jupyter_core 5.7.2 py312h81bd7bf_0 conda-forge jupyter_events 0.10.0 pyhd8ed1ab_0 conda-forge jupyter_server 2.14.2 pyhd8ed1ab_0 conda-forge jupyter_server_terminals 0.5.3 pyhd8ed1ab_0 conda-forge jupyterlab 4.2.3 pyhd8ed1ab_0 conda-forge jupyterlab_pygments 0.3.0 pyhd8ed1ab_1 conda-forge jupyterlab_server 2.27.2 pyhd8ed1ab_0 conda-forge jupyterlab_widgets 3.0.11 pyhd8ed1ab_0 conda-forge kealib 1.5.3 h848a2d4_1 conda-forge kiwisolver 1.4.5 py312h389731b_1 conda-forge krb5 1.21.3 h237132a_0 conda-forge lame 3.100 h1a8c8d9_1003 conda-forge lark 0.12.0 pyhd8ed1ab_0 conda-forge lcms2 2.16 ha0e7c42_0 conda-forge lerc 4.0.0 h9a09cb3_0 conda-forge libabseil 20240116.2 cxx17_h00cdb27_1 conda-forge libaec 1.1.3 hebf3989_0 conda-forge libarchive 3.7.4 h83d404f_0 conda-forge libarrow 16.1.0 h2a00445_14_cpu conda-forge libarrow-acero 16.1.0 h00cdb27_14_cpu conda-forge libarrow-dataset 16.1.0 h00cdb27_14_cpu conda-forge libarrow-substrait 16.1.0 hc68f6b8_14_cpu conda-forge libasprintf 0.22.5 h8fbad5d_2 conda-forge libasprintf-devel 0.22.5 h8fbad5d_2 conda-forge libass 0.17.1 hf20b609_2 conda-forge libblas 3.9.0 22_osxarm64_openblas conda-forge libbrotlicommon 1.1.0 hb547adb_1 conda-forge libbrotlidec 1.1.0 hb547adb_1 conda-forge libbrotlienc 1.1.0 hb547adb_1 conda-forge libcblas 3.9.0 22_osxarm64_openblas conda-forge libcrc32c 1.1.2 hbdafb3b_0 conda-forge libcurl 8.8.0 h7b6f9a7_1 conda-forge libcxx 18.1.8 h167917d_0 conda-forge libdeflate 1.20 h93a5062_0 conda-forge libedit 3.1.20191231 hc8eb9b7_2 conda-forge libev 4.33 h93a5062_2 conda-forge libevent 2.1.12 h2757513_1 conda-forge libexpat 2.6.2 hebf3989_0 conda-forge libffi 3.4.2 h3422bc3_5 conda-forge libgdal 3.9.1 hce30654_7 conda-forge libgdal-arrow-parquet 3.9.1 h964fb9d_9 conda-forge libgdal-core 3.9.1 hf00468f_7 conda-forge libgdal-fits 3.9.1 h7a7a030_7 conda-forge libgdal-grib 3.9.1 hdd4b840_7 conda-forge libgdal-hdf4 3.9.1 h94124bd_7 conda-forge libgdal-hdf5 3.9.1 hf90b89a_7 conda-forge libgdal-jp2openjpeg 3.9.1 h54bcb16_7 conda-forge libgdal-kea 3.9.1 hacb1b3e_7 conda-forge libgdal-netcdf 3.9.1 h1723b65_7 conda-forge libgdal-pdf 3.9.1 h4cf08c4_7 conda-forge libgdal-pg 3.9.1 h7d28298_7 conda-forge libgdal-postgisraster 3.9.1 h7d28298_7 conda-forge libgdal-tiledb 3.9.1 hbb20944_7 conda-forge libgdal-xls 3.9.1 hb39617b_7 conda-forge libgettextpo 0.22.5 h8fbad5d_2 conda-forge libgettextpo-devel 0.22.5 h8fbad5d_2 conda-forge libgfortran 5.0.0 13_2_0_hd922786_3 conda-forge libgfortran5 13.2.0 hf226fd6_3 conda-forge libglib 2.80.3 h59d46d9_1 conda-forge libgoogle-cloud 2.26.0 hfe08963_0 conda-forge libgoogle-cloud-storage 2.26.0 h1466eeb_0 conda-forge libgrpc 1.62.2 h9c18a4f_0 conda-forge libhwloc 2.11.1 default_h7685b71_1000 conda-forge libiconv 1.17 h0d3ecfb_2 conda-forge libidn2 2.3.7 h93a5062_0 conda-forge libintl 0.22.5 h8fbad5d_2 conda-forge libintl-devel 0.22.5 h8fbad5d_2 conda-forge libjpeg-turbo 3.0.0 hb547adb_1 conda-forge libkml 1.3.0 h00ed6cc_1020 conda-forge liblapack 3.9.0 22_osxarm64_openblas conda-forge libllvm14 14.0.6 hd1a9a77_4 conda-forge libnetcdf 4.9.2 nompi_he469be0_114 conda-forge libnghttp2 1.58.0 ha4dd798_1 conda-forge libopenblas 0.3.27 openmp_h517c56d_1 conda-forge libopenvino 2024.2.0 h5c9529b_1 conda-forge libopenvino-arm-cpu-plugin 2024.2.0 h5c9529b_1 conda-forge libopenvino-auto-batch-plugin 2024.2.0 hcd65546_1 conda-forge libopenvino-auto-plugin 2024.2.0 hcd65546_1 conda-forge libopenvino-hetero-plugin 2024.2.0 h88cb26a_1 conda-forge libopenvino-ir-frontend 2024.2.0 h88cb26a_1 conda-forge libopenvino-onnx-frontend 2024.2.0 h32b5460_1 conda-forge libopenvino-paddle-frontend 2024.2.0 h32b5460_1 conda-forge libopenvino-pytorch-frontend 2024.2.0 h00cdb27_1 conda-forge libopenvino-tensorflow-frontend 2024.2.0 h2741c3b_1 conda-forge libopenvino-tensorflow-lite-frontend 2024.2.0 h00cdb27_1 conda-forge libopus 1.3.1 h27ca646_1 conda-forge libparquet 16.1.0 hcf52c46_14_cpu conda-forge libpdal 2.7.2 hce30654_2 conda-forge libpdal-arrow 2.7.2 ha931944_2 conda-forge libpdal-core 2.7.2 hab9505c_2 conda-forge libpdal-cpd 2.7.2 h00cdb27_2 conda-forge libpdal-draco 2.7.2 h00cdb27_2 conda-forge libpdal-e57 2.7.2 h9bb3833_2 conda-forge libpdal-hdf 2.7.2 h848a2d4_2 conda-forge libpdal-icebridge 2.7.2 h848a2d4_2 conda-forge libpdal-nitf 2.7.2 h5336cf3_2 conda-forge libpdal-pgpointcloud 2.7.2 hc8db3c2_2 conda-forge libpdal-tiledb 2.7.2 h5b9cd91_2 conda-forge libpdal-trajectory 2.7.2 h56aa51d_2 conda-forge libpng 1.6.43 h091b4b1_0 conda-forge libpq 16.3 h7afe498_0 conda-forge libprotobuf 4.25.3 hbfab5d5_0 conda-forge libre2-11 2023.09.01 h7b2c953_2 conda-forge librttopo 1.1.0 h31fb324_16 conda-forge libsodium 1.0.18 h27ca646_1 conda-forge libspatialite 5.1.0 hf7a34df_8 conda-forge libsqlite 3.46.0 hfb93653_0 conda-forge libssh2 1.11.0 h7a5bd25_0 conda-forge libtasn1 4.19.0 h1a8c8d9_0 conda-forge libthrift 0.19.0 h026a170_1 conda-forge libtiff 4.6.0 h07db509_3 conda-forge libunistring 0.9.10 h3422bc3_0 conda-forge libutf8proc 2.8.0 h1a8c8d9_0 conda-forge libvpx 1.14.1 h7bae524_0 conda-forge libwebp-base 1.4.0 h93a5062_0 conda-forge libxcb 1.16 hf2054a2_0 conda-forge libxml2 2.12.7 h01dff8b_4 conda-forge libxslt 1.1.39 h223e5b9_0 conda-forge libzip 1.10.1 ha0bc3c6_3 conda-forge libzlib 1.3.1 hfb2fe0b_1 conda-forge llvm-openmp 18.1.8 hde57baf_0 conda-forge llvmlite 0.43.0 py312h30cb90f_0 conda-forge locket 1.0.0 pyhd8ed1ab_0 conda-forge logzero 1.7.0 py312h81bd7bf_5 conda-forge lxml 5.2.2 py312h0e5ab22_0 conda-forge lz4 4.3.3 py312haed5471_0 conda-forge lz4-c 1.9.4 hb7217d7_0 conda-forge lzo 2.10 h93a5062_1001 conda-forge mapclassify 2.6.1 pyhd8ed1ab_0 conda-forge markdown-it-py 3.0.0 pyhd8ed1ab_0 conda-forge markupsafe 2.1.5 py312he37b823_0 conda-forge matplotlib-base 3.9.1 py312h32d6e5a_0 conda-forge matplotlib-inline 0.1.7 pyhd8ed1ab_0 conda-forge mdurl 0.1.2 pyhd8ed1ab_0 conda-forge metis 5.1.0 h13dd4ca_1007 conda-forge minizip 4.0.7 h27ee973_0 conda-forge mistune 3.0.2 pyhd8ed1ab_0 conda-forge mpfr 4.2.1 h1cfca0a_2 conda-forge mpi 1.0 openmpi conda-forge msgpack-python 1.0.8 py312h157fec4_0 conda-forge multidict 6.0.5 py312h670c8ac_0 conda-forge multiurl 0.3.1 pyhd8ed1ab_0 conda-forge munkres 1.1.4 pyh9f0ad1d_0 conda-forge nbclient 0.10.0 pyhd8ed1ab_0 conda-forge nbconvert-core 7.16.4 pyhd8ed1ab_1 conda-forge nbformat 5.10.4 pyhd8ed1ab_0 conda-forge ncurses 6.5 hb89a1cb_0 conda-forge nest-asyncio 1.6.0 pyhd8ed1ab_0 conda-forge netcdf4 1.7.1 nompi_py312hec02768_101 conda-forge nettle 3.9.1 h40ed0f5_0 conda-forge networkx 3.3 pyhd8ed1ab_1 conda-forge nitro 2.7.dev8 h13dd4ca_0 conda-forge notebook-shim 0.2.4 pyhd8ed1ab_0 conda-forge nspr 4.35 hb7217d7_0 conda-forge nss 3.102 hc42bcbf_0 conda-forge numba 0.60.0 py312h41cea2d_0 conda-forge numexpr 2.10.0 py312h8ae5369_0 conda-forge numpy 2.0.0 py312hb544834_0 conda-forge oauthlib 3.2.2 pyhd8ed1ab_0 conda-forge openh264 2.4.1 hebf3989_0 conda-forge openjpeg 2.5.2 h9f1df11_0 conda-forge openmpi 5.0.3 hba4779a_110 conda-forge openssl 3.3.1 hfb2fe0b_1 conda-forge orc 2.0.1 h47ade37_1 conda-forge overrides 7.7.0 pyhd8ed1ab_0 conda-forge owslib 0.31.0 pyhd8ed1ab_0 conda-forge p11-kit 0.24.1 h29577a5_0 conda-forge packaging 24.1 pyhd8ed1ab_0 conda-forge pandas 2.2.2 py312h8ae5369_1 conda-forge pandocfilters 1.5.0 pyhd8ed1ab_0 conda-forge parso 0.8.4 pyhd8ed1ab_0 conda-forge partd 1.4.2 pyhd8ed1ab_0 conda-forge pcre2 10.44 h297a79d_0 conda-forge pdal 2.7.2 hd8ed1ab_4 conda-forge pexpect 4.9.0 pyhd8ed1ab_0 conda-forge pickleshare 0.7.5 py_1003 conda-forge pillow 10.4.0 py312h39b1d8d_0 conda-forge pip 24.0 pyhd8ed1ab_0 conda-forge pixman 0.43.4 hebf3989_0 conda-forge pkgutil-resolve-name 1.3.10 pyhd8ed1ab_1 conda-forge platformdirs 4.2.2 pyhd8ed1ab_0 conda-forge plotly 5.23.0 pyhd8ed1ab_0 conda-forge pluggy 1.5.0 pyhd8ed1ab_0 conda-forge poppler 24.07.0 h9787579_0 conda-forge poppler-data 0.4.12 hd8ed1ab_0 conda-forge postgresql 16.3 hdfa2ec6_0 conda-forge progressbar2 4.4.2 pyhd8ed1ab_0 conda-forge proj 9.4.1 hfb94cee_0 conda-forge prometheus_client 0.20.0 pyhd8ed1ab_0 conda-forge prompt-toolkit 3.0.47 pyha770c72_0 conda-forge proto-plus 1.23.0 pyhd8ed1ab_0 conda-forge protobuf 4.25.3 py312h1a610f3_0 conda-forge psutil 6.0.0 py312h7e5086c_0 conda-forge psycopg2 2.9.9 py312h84485f8_0 conda-forge pthread-stubs 0.4 h27ca646_1001 conda-forge ptyprocess 0.7.0 pyhd3deb0d_0 conda-forge pugixml 1.14 h13dd4ca_0 conda-forge pure_eval 0.2.2 pyhd8ed1ab_0 conda-forge pyaez 2.2 pyhd8ed1ab_0 conda-forge pyarrow 16.1.0 py312ha814d7c_4 conda-forge pyarrow-core 16.1.0 py312h21f1c3e_4_cpu conda-forge pyarrow-hotfix 0.6 pyhd8ed1ab_0 conda-forge pyasn1 0.6.0 pyhd8ed1ab_0 conda-forge pyasn1-modules 0.4.0 pyhd8ed1ab_0 conda-forge pycparser 2.22 pyhd8ed1ab_0 conda-forge pycrs 1.0.2 py_0 conda-forge pydantic 1.10.17 py312h7e5086c_0 conda-forge pygeoapi 0.17.0 pyhd8ed1ab_0 conda-forge pygeofilter 0.2.4 pyhd8ed1ab_0 conda-forge pygeoif 1.5.0 pyhd8ed1ab_0 conda-forge pygments 2.18.0 pyhd8ed1ab_0 conda-forge pyjsparser 2.7.1 pyh8c360ce_0 conda-forge pyjwt 2.9.0 pyhd8ed1ab_1 conda-forge pyobjc-core 10.3.1 py312hbb55c70_0 conda-forge pyobjc-framework-cocoa 10.3.1 py312hbb55c70_0 conda-forge pyogrio 0.9.0 py312h15038b3_0 conda-forge pyopenssl 24.2.1 pyhd8ed1ab_0 conda-forge pyparsing 3.1.2 pyhd8ed1ab_0 conda-forge pyperclip 1.9.0 pyh534df25_0 conda-forge pyproj 3.6.1 py312h64656f7_7 conda-forge pyshp 2.3.1 pyhd8ed1ab_0 conda-forge pysocks 1.7.1 pyha2e5f31_6 conda-forge pytest 8.2.2 pyhd8ed1ab_0 conda-forge python 3.12.4 h30c5eda_0_cpython conda-forge python-box 7.2.0 py312h7e5086c_0 conda-forge python-dateutil 2.9.0 pyhd8ed1ab_0 conda-forge python-eccodes 1.7.1 py312hbebd99a_0 conda-forge python-fastjsonschema 2.20.0 pyhd8ed1ab_0 conda-forge python-json-logger 2.0.7 pyhd8ed1ab_0 conda-forge python-pdal 3.4.5 py312h4ef7a57_4 conda-forge python-tzdata 2024.1 pyhd8ed1ab_0 conda-forge python-utils 3.8.2 pyhd8ed1ab_0 conda-forge python_abi 3.12 4_cp312 conda-forge pytz 2024.1 pyhd8ed1ab_0 conda-forge pyu2f 0.1.5 pyhd8ed1ab_0 conda-forge pyyaml 6.0.1 py312h02f2b3b_1 conda-forge pyzmq 26.0.3 py312hfa13136_0 conda-forge qhull 2020.2 h420ef59_5 conda-forge rasterio 1.3.10 py312h6160399_4 conda-forge ratelim 0.1.6 py_2 conda-forge re2 2023.09.01 h4cba328_2 conda-forge readline 8.2 h92ec313_1 conda-forge referencing 0.35.1 pyhd8ed1ab_0 conda-forge regex 2024.7.24 py312h7e5086c_0 conda-forge requests 2.32.3 pyhd8ed1ab_0 conda-forge requests-oauthlib 2.0.0 pyhd8ed1ab_0 conda-forge rfc3339-validator 0.1.4 pyhd8ed1ab_0 conda-forge rfc3986-validator 0.1.1 pyh9f0ad1d_0 conda-forge rich 13.7.1 pyhd8ed1ab_0 conda-forge rioxarray 0.16.0 pyhd8ed1ab_0 conda-forge rpds-py 0.19.0 py312h552d48e_0 conda-forge rsa 4.7.2 pyh44b312d_0 conda-forge ruamel.yaml 0.18.6 py312he37b823_0 conda-forge ruamel.yaml.clib 0.2.8 py312he37b823_0 conda-forge s3transfer 0.10.2 pyhd8ed1ab_0 conda-forge sankee 0.2.5 pyhd8ed1ab_0 conda-forge scikit-learn 1.5.1 py312h1b546db_0 conda-forge scipy 1.14.0 py312h14ffa8f_1 conda-forge scooby 0.10.0 pyhd8ed1ab_0 conda-forge send2trash 1.8.3 pyh31c8845_0 conda-forge setuptools 70.3.0 pyhd8ed1ab_0 conda-forge shapely 2.0.5 py312hbab3d11_0 conda-forge six 1.16.0 pyh6c4a22f_0 conda-forge snappy 1.2.1 hd02b534_0 conda-forge sniffio 1.3.1 pyhd8ed1ab_0 conda-forge snuggs 1.4.7 py_0 conda-forge sortedcontainers 2.4.0 pyhd8ed1ab_0 conda-forge soupsieve 2.5 pyhd8ed1ab_1 conda-forge spdlog 1.13.0 h5fcca99_0 conda-forge sqlalchemy 1.4.49 py312he37b823_1 conda-forge sqlite 3.46.0 h5838104_0 conda-forge stack_data 0.6.2 pyhd8ed1ab_0 conda-forge suitesparse 7.7.0 hf6fcff2_1 conda-forge svt-av1 2.1.2 h7bae524_0 conda-forge tbb 2021.12.0 h420ef59_3 conda-forge tblib 3.0.0 pyhd8ed1ab_0 conda-forge tenacity 8.5.0 pyhd8ed1ab_0 conda-forge terminado 0.18.1 pyh31c8845_0 conda-forge threadpoolctl 3.5.0 pyhc1e730c_0 conda-forge tiledb 2.24.2 h5def871_2 conda-forge tinycss2 1.3.0 pyhd8ed1ab_0 conda-forge tinydb 4.8.0 pyhd8ed1ab_0 conda-forge tk 8.6.13 h5083fa2_1 conda-forge toml 0.10.2 pyhd8ed1ab_0 conda-forge tomli 2.0.1 pyhd8ed1ab_0 conda-forge toolz 0.12.1 pyhd8ed1ab_0 conda-forge tornado 6.4.1 py312h7e5086c_0 conda-forge tqdm 4.66.4 pyhd8ed1ab_0 conda-forge traitlets 5.14.3 pyhd8ed1ab_0 conda-forge traittypes 0.2.1 pyh9f0ad1d_2 conda-forge types-python-dateutil 2.9.0.20240316 pyhd8ed1ab_0 conda-forge typing-extensions 4.12.2 hd8ed1ab_0 conda-forge typing_extensions 4.12.2 pyha770c72_0 conda-forge typing_utils 0.1.0 pyhd8ed1ab_0 conda-forge tzcode 2024a h93a5062_0 conda-forge tzdata 2024a h0c530f3_0 conda-forge tzlocal 5.2 py312h81bd7bf_0 conda-forge unicodecsv 0.14.1 pyhd8ed1ab_2 conda-forge uri-template 1.3.0 pyhd8ed1ab_0 conda-forge uriparser 0.9.8 h00cdb27_0 conda-forge uritemplate 4.1.1 pyhd8ed1ab_0 conda-forge urllib3 2.2.2 pyhd8ed1ab_1 conda-forge wcwidth 0.2.13 pyhd8ed1ab_0 conda-forge webcolors 24.6.0 pyhd8ed1ab_0 conda-forge webencodings 0.5.1 pyhd8ed1ab_2 conda-forge websocket-client 1.8.0 pyhd8ed1ab_0 conda-forge werkzeug 3.0.3 pyhd8ed1ab_0 conda-forge wheel 0.43.0 pyhd8ed1ab_1 conda-forge whitebox 2.3.5 pyhd8ed1ab_0 conda-forge whiteboxgui 2.3.0 pyhd8ed1ab_0 conda-forge widgetsnbextension 4.0.11 pyhd8ed1ab_0 conda-forge x264 1!164.3095 h57fd34a_2 conda-forge x265 3.5 hbc6ce65_3 conda-forge xarray 2024.6.0 pyhd8ed1ab_1 conda-forge xerces-c 3.2.5 h0a46525_1 conda-forge xorg-kbproto 1.0.7 h27ca646_1002 conda-forge xorg-libx11 1.8.9 he5f3e76_1 conda-forge xorg-libxau 1.0.11 hb547adb_0 conda-forge xorg-libxdmcp 1.1.3 h27ca646_0 conda-forge xorg-xextproto 7.3.0 h1a8c8d9_1003 conda-forge xorg-xproto 7.0.31 h27ca646_1007 conda-forge xyzservices 2024.6.0 pyhd8ed1ab_0 conda-forge xz 5.2.6 h57fd34a_0 conda-forge yaml 0.2.5 h3422bc3_2 conda-forge yarl 1.9.4 py312he37b823_0 conda-forge zeromq 4.3.5 hcc0f68c_4 conda-forge zict 3.0.0 pyhd8ed1ab_0 conda-forge zipp 3.19.2 pyhd8ed1ab_0 conda-forge zlib 1.3.1 hfb2fe0b_1 conda-forge zstandard 0.23.0 py312h721a963_0 conda-forge zstd 1.5.6 hb46c0d2_0 conda-forge ```

Environment info

```shell libmamba version : 1.5.8 micromamba version : 1.5.8 curl version : libcurl/8.7.1 (SecureTransport) LibreSSL/3.3.6 zlib/1.2.12 nghttp2/1.61.0 libarchive version : libarchive 3.5.3 zlib/1.2.12 liblzma/5.4.3 bz2lib/1.0.8 envs directories : ~/micromamba/envs package cache : ~/micromamba/pkgs ~/.mamba/pkgs environment : PyDev (active) env location : ~/micromamba/envs/PyDev user config files : ~/.mambarc populated config files : virtual packages : __unix=0=0 __osx=14.6.1=0 __archspec=1=arm64 channels : base environment : ~/micromamba platform : osx-arm64 ```

[xylar]

@digital-idiot, it seems like you are searching for a linux dynamic library extension under OSX. Could you try the following and let me know if it works?

import sqlite3
# setup an in-memory database
con = sqlite3.connect(':memory:')
# enable loading extensions and load spatialite
con.enable_load_extension(True)
try:
    con.load_extension('mod_spatialite')
except sqlite3.OperationalError:
    con.load_extension('libspatialite')

If not, could you try:

import sqlite3
# setup an in-memory database
con = sqlite3.connect(':memory:')
# enable loading extensions and load spatialite
con.enable_load_extension(True)
try:
    con.load_extension('mod_spatialite.dylib')
except sqlite3.OperationalError:
    con.load_extension('libspatialite.dylib')

If neither of those works, I'll fire up my Mac an see if I can reproduce the problem.

[digital-idiot]

@digital-idiot, it seems like you are searching for a linux dynamic library extension under OSX. Could you try the following and let me know if it works?

import sqlite3
# setup an in-memory database
con = sqlite3.connect(':memory:')
# enable loading extensions and load spatialite
con.enable_load_extension(True)
try:
    con.load_extension('mod_spatialite')
except sqlite3.OperationalError:
    con.load_extension('libspatialite')

If not, could you try:

import sqlite3
# setup an in-memory database
con = sqlite3.connect(':memory:')
# enable loading extensions and load spatialite
con.enable_load_extension(True)
try:
    con.load_extension('mod_spatialite.dylib')
except sqlite3.OperationalError:
    con.load_extension('libspatialite.dylib')

If neither of those works, I'll fire up my Mac an see if I can reproduce the problem.

@xylar Both of these works. Thanks for pointing out my mistake. However, I still cannot successfully do sqlite> .load libspatialite which throws: Error: dlsym(0x8b440f50, sqlite3_spatialite_init): symbol not found. Do you have any pointer how can I fix this?

[xylar]

@digital-idiot, I will freely admit that this is not a package I use myself, I just maintain it as a dependency of other things I use.

But a bit of searching around and trial-and-error suggests that this does work:

$ sqlite3
> .load mod_spatialite

It worked for me on my mac.

@gillins, let me know if you have any further thoughts on this.

[gillins]

I will freely admit that this is not a package I use myself, I just maintain it as a dependency of other things I use.

Same situation here! And I no longer have access to a Mac.... Thanks for investigating @xylar.

[digital-idiot]

@digital-idiot, I will freely admit that this is not a package I use myself, I just maintain it as a dependency of other things I use.

But a bit of searching around and trial-and-error suggests that this does work:

$ sqlite3
> .load mod_spatialite

It worked for me on my mac.

@gillins, let me know if you have any further thoughts on this.

Resolved. Thanks @xylar

[xylar]

@digital-idiot, glad I could help!