installation of Spatialite

[Marin M]

hi,

i am very new to spatialite

and want to install it.

i have already installed SQLite  and i guess it is enough to follow recipe given on

https://docs.djangoproject.com/en/4.1/ref/contrib/gis/install/spatialite/#spatialite-source

in part given under SQL it is given , i am not clear where should i run this commands  under _

$ wget https://www.sqlite.org/YYYY/sqlite-amalgamation-XXX0000.zip

$ unzip sqlite-amalgamation-XXX0000.zip

rgrds

[a.fu...@lqt.it]

Hi Marin,

The Django documentation assumes that you are running on a Linux or
maybe MacOsX system.
if instead you are working on Windows none of the suggested commands
make sense.

if you are a Windows user (as it seems very likely) the simplest way
to install SpatiaLite is the following:

#1 dowload this pre-compiled package:

http://www.gaia-gis.it/gaia-sins/windows-bin-amd64/mod_spatialite-5.0.1-win-amd64.7z

#2 now you have just to inflate the 7z compressed file
you'll get a brand new folder containing a lot of DLLs
and a copy of the sqlite3.exe executable binary


#3 you are ready to start sqlite3 (just click on the exe icon)

#4 final step: you have to load SpatiaLite as an extension by
executing these SQL statements:

---------------------------
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT load_extension('mod_spatialite');

sqlite> SELECT spatialite_version();
5.0.1
sqlite>
---------------------------

note: the call to spatialite_version() is simply a check
to verify that the extension has been correctly loaded;
if you read the answer "5.0.1" it means that you are now
definitely ready to execute any Spatial function supported
by SpatiaLite

hint: I recommend you to read the most recent online
documentation about all Spatial SQL functions you can
find here:

https://www.gaia-gis.it/gaia-sins/spatialite-sql-5.0.1.html

bye Sandro

[Marin M]

hi Sandro, 

thanks on answer

i have seen that there is GUI in addition

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

i have downloaded  from https://www.gaia-gis.it/fossil/spatialite_gui/index - Sources

I tried to open it to find some .exe 

Is there also some command(SQL) that has to be used  to get GUI on already enabled spatial lite  on sqlite( that you sent to me in previous email)

best regards

--
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to spatialite-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/spatialite-users/a218c79bfc0e42734ec4deafd2ee9ef8%40lqt.it.

[a.fu...@lqt.it]

On Sun, 26 Mar 2023 15:56:04 +0200, Marin M wrote:
> hi Sandro, 
> thanks on answer
>
> i have seen that there is GUI in addition

> https://www.gaia-gis.it/fossil/spatialite_gui/index [7]
>
> i have downloaded 
> from https://www.gaia-gis.it/fossil/spatialite_gui/index [8] -

> Sources
>
> I tried to open it to find some .exe 
>

Marin,

be careful not to get confused: the source code is universal
and is always the same for all platforms, but the executable
binaries are strictly dependent on the specific platform.
you'll never find a binary executable for Windows among the
sources, it's definitely not its place.

> Is there also some command(SQL) that has to be used  to get GUI on
> already enabled spatial lite  on sqlite( that you sent to me in
> previous email)
>

the GUI is a big binary executable that contains everything
needed for SpatiaLite inside a single monolithic EXE for
Windows without any other external dependencies.

#1 download the most recent version from here:

http://www.gaia-gis.it/gaia-sins/windows-bin-amd64-prev/spatialite_gui-NG-5.0.0-win-amd64.7z

#2 inflate the compressed 7z package so to get a new folder

#3 just click the GUI icon and you'll be immediately ready to
use both SQLite and SpatiaLite

bye Sandro