Wiki page
[SpatiaLite] by
sandro
2014-05-21 23:26:36.
D 2014-05-21T23:26:36.788
L SpatiaLite
P 9561ae95f384e625f8bcd16c9b3d949ba4367bf5
U sandro
W 4757
<table cellspacing="10" cellpadding="30"><tr>
<td bgcolor="#f0f0f8" width="50%">
SpatiaLite is an <b>open source</b> library intended to extend the <a href="http://www.sqlite.org/">SQLite</a> core to support fully fledged Spatial SQL capabilities.<br>
SQLite is intrinsically simple and lightweight:<ul>
<li>a single lightweight library implementing the full SQL engine</li>
<li>standard SQL implementation: almost complete SQL-92</li>
<li>no complex client/server architecture</li>
<li>a whole database simply corresponds to a single monolithic file (no size limits)</li>
<li>any DB-file can be safely exchanged across different platforms, because the internal architecture is universally portable</li>
<li>no installation, no configuration</li></ul>
SpatiaLite is smoothly integrated into SQLite to provide a complete and powerful Spatial DBMS (mostly OGC-SFS compliant).<br/>
Using SQLite + SpatiaLite you can effectively deploy an alternative <i>open source</i> Spatial DBMS roughly equivalent to <a href="http://www.postgresql.org/">PostgreSQL</a> + <a href="http://postgis.refractions.net/">PostGIS</a>.
SpatiaLite is licensed under the <a href="http://www.mozilla.org/MPL/boilerplate-1.1/mpl-tri-license-html">MPL tri-license</a> terms; you are free to choose the best-fit license between:<ul>
<li>the <a href="http://www.mozilla.org/MPL/MPL-1.1.html">MPL 1.1</a></li>
<li>the <a href="http://www.gnu.org/licenses/gpl-2.0.html#TOC1">GPL v2.0</a> or any subsequent version</li>
<li>the <a href="http://www.gnu.org/licenses/lgpl-2.1.html">LGPL v2.1</a> or any subsequent version</li></ul>
</td>
<td>
<table cellpadding="4" cellspacing="4">
<tr><td>Closely related <b>projects</b>:<ul>
<li><a href="/fossil/freexl">FreeXL</a></li>
<li><a href="/fossil/spatialite-tools">spatialite-tools</a></li>
<li><a href="/fossil/spatialite_gui">spatialite_gui</a></li>
<li><a href="/fossil/librasterlite">librasterlite</a></li>
<li><a href="/fossil/spatialite_gis">spatialite_gis</a></li>
<li>back to the <a href="http://www.gaia-gis.it/gaia-sins">Gaia-SINS</a> home page</li></ul>
</td></tr>
<tr><td><b>Sources</b>: current version is <b>4.1.1</b> (<i>released on 2013-06-29)</i><ul>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-4.1.1.tar.gz">libspatialite-4.1.1.tar.gz</a> (tarball, .tar.gz)</li>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-4.1.1.zip">libspatialite-4.1.1.zip</a> (zipfile, .zip)</li>
<li><b>4.2.0 Release Candidate 1</b> (<i>released on 2014-05-22</i>):
<ul>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-4.2.0-rc1.tar.gz">libspatialite-4.2.0-rc1.tar.gz</a> (tarball, .tar.gz)</li>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-4.2.0-rc1.zip">libspatialite-4.2.0-rc1.zip</a> (zipfile, .zip)</li>
</ul></li>
<li>browse <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-sources">older versions</a></li></ul>
</td></tr>
<tr><td bgcolor="#ffffd0">SpatiaLite porting for <a href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=splite-android">Android</a></td></tr>
<tr><td>Doxygen <b>C API documentation</b>:<ul>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-4.1.0/index.html">online</a> HTML doc</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-4.1.0.tar.gz">download</a> HTML tarball (tar.gz)</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-4.1.0.zip">download</a> HTML zipfile (zip)</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-4.1.0.pdf">PDF document</a></ul>
</td></tr>
<tr><td><b>Spatial SQL functions</b> <a href="http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.1.0.html">reference guide</a><td></tr>
<tr><td><b>Tutorials, Cookbook</b> and other <a href="wiki?name=misc-docs">documentation</a></td></tr>
<tr><td><b>Archaeological</b> <a href="http://www.gaia-gis.it/spatialite-3.0.0-BETA/index.html">web sites</a></td></tr>
<tr><td bgcolor="#ffffd0"><b>Switching to 4.0: </b> <a href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=switching-to-4.0">useful documentation</a></td></tr>
<tr><td bgcolor="#ffffd0"><b>Switching to 4.1: </b> <a href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=4.1.0-doc">useful documentation</a></td></tr>
</table></td>
</tr></table>
<table bgcolor="#d0e0ff" width="100%">
<tr><td align="center">
<small><b>Credits</b><hr>
Development of <i>SpatiaLite 4.1.0</i> has been substantially funded by
<a href="http://en.wikipedia.org/wiki/Tuscany">Tuscany Region</a> - Territorial and Environmental Information System<br>
<a href="http://www.geografia.toscana.it/">Regione Toscana</a> - Settore Sistema Informativo Territoriale ed Ambientale.</small>
</td></tr></table>
Z 47ac9c900682a2fd75497f91a163e6b8