eslider/spatialite

Sqlite and spatialite static binaries

Repository

• Windows x32 and Linux x64 binaries
• PHP shell wrapper driver
• PHP native wrapper driver

About

SpatiaLite is an open source library intended to extend the SQLite core to support fully fledged Spatial SQL capabilities. SQLite is intrinsically simple and lightweight:, _(*1)

• a single lightweight library implementing the full SQL engine
• standard SQL implementation: almost complete SQL-92
• no complex client/server architecture
• a whole database simply corresponds to a single monolithic file (no size limits)
• any DB-file can be safely exchanged across different platforms, because the internal architecture is universally portable
• no installation, no configuration

SpatiaLite is smoothly integrated into SQLite to provide a complete and powerful Spatial DBMS (mostly OGC-SFS compliant). Using SQLite + SpatiaLite you can effectively deploy an alternative open source Spatial DBMS roughly equivalent to PostgreSQL + PostGIS., _(*2)

SpatiaLite is licensed under the MPL tri-license terms; you are free to choose the best-fit license between:, _(*3)

• the MPL 1.1
• the GPL v2.0 or any subsequent version
• the LGPL v2.1 or any subsequent version

Installation

composer require "eslider/spatialite", _(*4)

Develop

composer update, _(*5)

Setup

In order to get native driver work, you need set absolute path of sqlite3.extension_dir variable in php.ini file to the bin/x64 directory, where mod_spatialite.so can be found., _(*6)

Example:

sqlite3.extension_dir = /var/www/project_name/vendor/eslider/spatialite/bin/x64/mod_spatialite, _(*7)

Tests

PHP Unit test command:, _(*8)

bin/phpunit tests, _(*9)

By the first time tests creates an spatialite.sqlite file in the project directory. The file has geometries and spatial functions. This initial process take some time (>1 min). Next time tests runs faster., _(*10)

Data-Management

Spatialite data management GUI, _(*11)

wine spatialite_gui.exe

Refer

• Official PHP repository located at http://www.gaia-gis.it/
• Powered by https://www.sqlite.org/