Artifact [c836ce14f8]
Not logged in

Artifact c836ce14f8db0f0437cf8bc91424f309ad0ede2a:

Wiki page [SpatiaLite] by sandro 2014-07-26 09:17:47.
D 2014-07-26T09:17:47.856
L SpatiaLite
P cdd843ad3b8591ccba015d814aae884eb4649204
U sandro
W 4564
<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.2.0</b> (<i>released on 2014-07-25)</i><ul>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-4.2.0.tar.gz">libspatialite-4.2.0.tar.gz</a> (tarball, .tar.gz)</li>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-4.2.0.zip">libspatialite-4.2.0.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 portings for Android: old <a href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=splite-android">3.1</a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; current <a href="https://github.com/geopaparazzi/libjsqlite-spatialite-android/wiki">4.2.0</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.2.0/index.html">online</a> HTML doc</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-4.2.0.tar.gz">download</a> HTML tarball (tar.gz)</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-4.2.0.zip">download</a> HTML zipfile (zip)</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-4.2.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.2.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>Updated doc supporting recent versions: </b> <a href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=switching-to-4.0">v.4.0</a>
<a href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=4.1.0-doc">v.4.1</a>
<a href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=4.2.0-doc">v.4.2</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> and <i>4.2.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 510540e30c2464bbc50401fffb518184