Wiki page
[SpatiaLite] by
sandro
2021-02-07 16:26:39.
D 2021-02-07T16:26:39.154
L SpatiaLite
P 5da6e069755cb4840ef0b2a6deb36f72ae08b8e2
U sandro
W 4474
<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>5.0.1</b> (<i>released on 2021-02-07)
)</i><ul>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-5.0.1.tar.gz">libspatialite-5.0.1.tar.gz</a> (tarball, .tar.gz)</li>
<li>download <a href="http://www.gaia-gis.it/gaia-sins/libspatialite-5.0.1.zip">libspatialite-5.0.1.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.0.1</a> 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-5.0.1/index.html">online</a> HTML doc</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-5.0.1.tar.gz">download</a> HTML tarball (tar.gz)</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-5.0.1.zip">download</a> HTML zipfile (zip)</li>
<li><a href="http://www.gaia-gis.it/gaia-sins/splite-doxy-5.0.1.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-5.0.1.html">reference list</a> (present released version).</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 e219d8886ce9e1a1376e65255074305f