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
This is a demo project and template repository showing how I use SpatiaLite with Datasette for quick spatial analysis.
Built on sqlite