Installing spatialite-2.2 on Windows

spatialite-2.2 is a SQLite's extension, and includes in itself two further SQLite's extensions: the RTree, the MbrCache, the VirtualShape and the VirtualText ones.
There are various alternative ways you can follow at your choice to deploy and use them:

the spatialite.exe way:
- this one represents all-the-stuff-you-need already-bounded-together
- spatialite.exe does not requires a Windows installer;
  you simply have to unzip what you've just downloaded [i.e. spatialite-2.2-win-bin.zip] and put it in some folder
- to get started you can launch the spatialite.exe program. That's all.
  spatialite.exe is a statically linked executable; it has no external dependencies at all, so it's immediately ready to run
the sqlite3 way:
- go to the SQLite downloads and get the latest sqlite-version.zip and sqlitedll-version.zip
- get the spatialite-2.2-win-libs.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
- or even better, copy all the various DLLs into the system folder C:\WINDOWS\SYSTEM32
- to get started you can launch the sqlite3.exe program, and then .load 'libspatialite-2.dll'
  That's all
the GUI tool way:
- you can find lots of GUI tools supporting SQLite.
  May well be one of them supports dynamic 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-2.2-win-libs.zip
- unzip it somewhere
- copy all the various DLLs tou've just downloaded into your current directory, or even better into the system folder C:\WINDOWS\SYSTEM32
- then you start you preferred SQLite GUI tool and after execute an SQL statement as:
  - SELECT load_extension('libspatialite-2.dll');
- If this works, you are ready to start

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

back to main page