Artifact [f13d2be0bb]
Not logged in

Artifact f13d2be0bb31b8ef2d4960e19e03b61aa3b4fb04:

Wiki page [SpatiaLite] by sandro 2020-08-02 16:29:54.
D 2020-08-02T16:29:54.182
L SpatiaLite
P cc8d35e8e6e70fec4509b6f80c6b3b00db06eb74
U sandro
W 5140
<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/librasterlite2">librasterlite2</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.3.0a</b> (<i>released on 2015-09-07)</i><ul>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-4.3.0a.tar.gz">libspatialite-4.3.0a.tar.gz</a> (tarball, .tar.gz)</li>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-4.3.0a.zip">libspatialite-4.3.0a.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="#dfffc0"><b>Release Candidate</b>: <b>5.0.0-RC1</b> (<i>released on 2020-08-02)</i><ul>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-5.0.0-RC1.tar.gz">libspatialite-5.0.0-RC1.tar.gz</a> (tarball, .tar.gz)</li>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-5.0.0-RC1.zip">libspatialite-5.0.0-RC1.zip</a> (zipfile, .zip)</li>
</ul></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.0.1</a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; current <a href="https://github.com/geopaparazzi/libjsqlite-spatialite-android/wiki">4.3.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.3.0/index.html">online</a> HTML doc</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-4.3.0.tar.gz">download</a> HTML tarball (tar.gz)</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-4.3.0.zip">download</a> HTML zipfile (zip)</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-4.3.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.3.0.html">reference list</a> (present released version).<td></tr>
<tr><td bgcolor="#dfffc0"><b>Spatial SQL functions</b> <a href="http://www.gaia-gis.it/gaia-sins/spatialite-sql-5.0.0.html">reference list</a> (latest development version: <b>5.0.0-RC1</b>).<td></tr>
<tr><td>
<table width="100%" bgcolor="#89cff0" cellpadding="8"><tr><td>
<big><a href="https://www.gaia-gis.it/gaia-sins/spatialite_topics.html">Documentation</a> about SpatiaLite</big>
</td></tr></table>
</td></tr>
<tr><td><b>Archaeological</b> <a href="http://www.gaia-gis.it/spatialite-3.0.0-BETA/index.html">web sites</a>, <a href="wiki?name=misc-docs">tutorials / CookBook</a> and <a href="https://www.gaia-gis.it/fossil/libspatialite/wiki?name=4.3.0+doc">obsolete updates</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>, <i>4.2.0</i>, <i>4.3.0</i> and <i>5.0.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 cd33cacb0eccf480e3ed6af4df74fe99