Installing SpatiaLite on Windows
SpatiaLite and VirtualShape are SQLite extensions, so you need
to install SQLite too, in order to allow them to operate.
There are various alternative ways you can follow at your choice:
- the standard way:
- go to the SQLite downloads
and get the latest sqlite-version.zip and sqlitedll-version.zip
- get the spatialite-win-1.0.zip
- neither SQLite nor SpatiaLite requires a Windows installer;
you simply have to unzip what you've just downloaded, putting all the stuff together in the same folder
- to get started you can launch the sqlite3.exe program, and then .load 'SpatiaLite.dll'
That's all
- the GUI tool way:
- you can find lots of GUI tools supporting SQLite.
May well be one of them supports extensions loading; all the ones I tested refused to do this.
- If you have best luck than me, then you simply have to get the spatialite-win-1.0.zip
- unzip it somewhere
- then you start you preferred SQLite GUI tool and after .load 'SpatiaLite.dll'
If this works, you are ready to start
- the SQLiteGeo way:
- if you think the first two ways are too complicated for you, get the sqlitegeo-win-1.0.zip
- this one is simply a standard sqlite3 slightly modified in order to support
automatically loading for SpatiaLite and VirtualShape
- SQliteGeo does not requires a Windows installer;
you simply have to unzip what you've just downloaded, putting all the stuff together in the same folder
- to get started you can launch the SQLiteGeo.exe program. That's all.
[you have not to type .load 'SpatiaLite.dll' at all; it's implicit]
Then I suggest you to download the test.db database and follow the tutorial step by step;
it's the fastest way to become accustomed with SpatiaLite and VirtualShape