#SpatiaLite

@marcbeldata Did you try with #PostGIS ? It is made for this kind of operations. Leveraging #QGIS and #PostGIS together is more than often the best solution, and the most efficient.
You could try #Spatialite too if you do not want any server component.

As for #PostGIS and #QGIS, you can do a lot coupling them, not only computing. See e.g. @CabiecesJ presentation at FOSS4G 2022 ( as soon as the content is pushed online ) : https://talks.osgeo.org/foss4g-2022/talk/ZGCKEE/

I finally updated the first article on web maps with Django and SpatiaLite (SQLite) that I wrote in 2020. I tested the guide with Python 3.11, Django 4.1 and Ubuntu 22.10 and made some small improvements. ✨

I hope you find it interesting. 🤞

Any feedback is welcome. ✅

Happy reading. 👍

https://www.paulox.net/2020/12/08/maps-with-django-part-1-geodjango-spatialite-and-leaflet/

#Python #Django #Map #SpatiaLite #SQLite #GeoDjango #GIS #Leaflet #Javascript

i had big plans for ST_GeneratePoints, but it's not in #spatialite.

whomp, whomp.

https://postgis.net/docs/ST_GeneratePoints.html

I wrote a series of #articles on how to build #maps with #Django 🗺️

The first article in the series is "Maps with Django (1): GeoDjango, SpatiaLite, Leaflet" 🍃

A quickstart #guide to create a #webmap with the #Python based web framework Django using its module #GeoDjango, the #SQLite database with its spatial extension #SpatiaLite and #Leaflet, a #JavaScript library for interactive maps. 👇

https://www.paulox.net/2020/12/08/maps-with-django-part-1-geodjango-spatialite-and-leaflet/

A workaround to QGIS unable to edit SpatiaLite database layer https://bit.ly/3srPJQK #QGIS #SpatiaLite

I've just published:
"Maps with Django (part 1): GeoDjango, SpatiaLite and Leaflet"
A quickstart guide to create a web #map 🗺️ with #Django 🦄 using its module #GeoDjango 🌍, the #SQLite 🪶 database with its spatial extension #SpatiaLite 🌐 and #Leaflet 🍃
https://www.paulox.net/2020/12/08/maps-with-django-part-1-geodjango-spatialite-and-leaflet/

RT @BorisMericskay@twitter.com

Envie de se mettre au SQL où de re(découvrir) les possibilités de ce langage extraordinaire pour manipuler et analyser des données géographiques.

✅ Support de cours de 12h d'introduction au SQL spatial avec #SpatiaLite dans @qgis@twitter.com (200 slides en .pdf)

➡https://www.sites.univ-rennes2.fr/mastersigat/Cours/SeanceQSpatiaLite2.pdf

🐦🔗: https://twitter.com/BorisMericskay/status/1309018825510322178