Installing spatialite-2.3.0 on Windows

• SpatiaLite itself supports the Geometry data type and related Spatial SQL functions as defined by the Open Gis Consortium - OGC
• RTree is the original SQLite implementation for Spatial Indexing
• MbrCache represents an alternative implementation for Spatial Indexing
• mathSQL supports useful mathematical SQL functions as Cos(), Sqrt() Log() ...
• VirtualShape allows immediate SQL access to Shapefiles
• VirtualText allows immediate SQL access to TXT/CSV files
• VirtualNetwork supports Routing
• EXIF GPS supports EXIF metadata, including GPS position when available

1. the spatialite-gui.exe way:
   • this one represents all-the-stuff-you-need already-bounded-together, and adopts an user friendly GUI
     i.e. you can simply work in the most natural way you are accustomed, using graphic windows and taking profit of the mouse
   • spatialite-gui.exe does not requires a Windows installer;
     you simply have to unzip what you've just downloaded [i.e. spatialite-gui-win-x86-2.3.0.zip] and put it in some folder
   • to get started you can launch the spatialite-gui.exe program. That's all.
     spatialite-gui.exe is a statically linked executable; it has no external dependencies at all, so it's immediately ready to run
2. the spatialite.exe way:
   • this one represents all-the-stuff-you-need already-bounded-together, and is a classic CLI database front end quite identical to its brother sqlite3.exe
   • spatialite.exe does not requires a Windows installer;
     you simply have to unzip what you've just downloaded [i.e. spatialite-tools-win-x86-2.3.0.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
   • and you can follow this way in order to deploy any other tool, such as exif_loader.exe, spatialite_network.exe ...
3. the sqlite3 way:
   • go to the SQLite downloads and get the latest sqlite-version.zip
   • then get libspatialite-win-x86-2.3.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
   • or even better, copy any DLL into the system folder C:\WINDOWS\SYSTEM32
   • to get started you can launch the sqlite3.exe program, and then .load 'libspatialite-2.dll' or SELECT load_extension('libspatialite-2.dll');
     That's all
4. the xxx GUI tool way / the xxx language binding way:
   • there are lots of GUI tools supporting SQLite
   • and there are lots of language bindings supporting SQLite as well:
     • Python
     • PHP
     • Java
     • Visual Basic ADO .NET and so on
   • more or less you simply need to perform the same steps as for using sqlite3
   • simply performing SELECT load_extension('libspatialite-2.dll'); will then start SpatiaLite
   • if your preferred software refuses to load extensions, then you have to stop and surrender yourself.
     this actually means there is no way to interoperate your sqlite-related software and SpatiaLite.
     you can found an in-depth explanation for this here