Spatialite has some nice spatial indexing features built in that work very well. This is an older article series that talks about Spatialite spatial indexes, bu

Spatialite has some nice spatial indexing features built in that work very well. This is an older article series that talks about Spatialite spatial indexes, but most of the queries in it still work today: https://northredoubt.com/n/2012/01/18/spatialite-and-spatial-indexes/ https://northredoubt.com/n/2012/01/18/spatialite-and-spatial...