Python Spatialite on Apple Silicon with Pyenv
For rapid prototyping or for running simple test cases in Django I like to use spatialite the geospatial extension to sqlite. To use Spatialite, you need to have SQLite compiled with extension support. However, both the built-in SQLite on macOS and the one from Homebrew lack this support. As a result, the Python version compiled by Pyenv also lacks this support, since it compiles a near-default configuration of Python, with SQLite extensions disabled by default....