SOFTWARES
Spatialite
- use the "spatialite gui" that you can download at https://www.gaia-gis.it/gaia-sins/index.html
or more precise here http://www.gaia-gis.it/gaia-sins/windows-bin-NEXTGEN-amd64/spatialite_gui-NG-win-amd64.7z
mac users go here : https://www.gaia-gis.it/spatialite-2.3.0/binaries.html
Notepad ++
-
you will feel more comfortable if you writte your queries in notepad++ https://notepad-plus-plus.org/download/v7.6.4.html
-
call your file *.sql and it will be coloured in a beautiful way that will make it more understandble
DATBASE DOCUMENTATIONS
- sqlite functions : https://www.sqlite.org/lang_corefunc.html
- spatialite functions : http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2.0.html
TUTORIALS
- sqlite : https://www.sqlitetutorial.net/
- spatialite : https://www.bostongis.com/?content_name=spatialite_tut01