Artifact [9c1e360585]
Not logged in

Artifact 9c1e3605859364af65c636d0164eb9da10fc42f2:

Wiki page [SpatiaLite] by sandro 2015-06-16 00:56:38.
D 2015-06-16T00:56:38.838
L SpatiaLite
P d9a0e49d0eb4b072b74473e725891f0db762b252
U sandro
W 4980
<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="#d0ff90">
<b>Testing:</b> version <b>4.3.0-RC0</b> (<i>released on 2015-06-14</i>)<br>
<a href="http://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-4.3.0-RC0.tar.gz">libspatialite-4.3.0-RC0.tar.gz</a> <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-4.3.0-RC0.zip">libspatialite-4.3.0-RC0.zip</a> <a href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=4.3.0+functions">release notes</a> <a href="http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.3.0.html">SQL functions reference guide</a>
</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.0.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 about version</b> 
<a href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=4.2.0-doc">4.2.0</a> (<i>including 4.0.0 and 4.1.0 changes</i>)</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 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 dd2461a7ee75e36b1d58feaca6f824ef