Spatialite

https://www.gaia-gis.it/fossil/libspatialite/index

SpatiaLite is an open source library intended to extend the SQLite core to support fully fledged Spatial SQL capabilities.
Using SQLite + SpatiaLite you can effectively deploy an alternative open source Spatial DBMS roughly equivalent to PostgreSQL + PostGIS.

Here's a demo project of using it with Datasette

https://github.com/eyeseast/spatial-data-cooking-show

This is a demo project and template repository showing how I use SpatiaLite with Datasette for quick spatial analysis.

Built on sqlite