Doctrine-spatial is a doctrine extension. It implements spatial types and functions. As exemple, this extension can help you to know if your favorite superheroes is inside Gotham city.
Currently, MySQL and PostgreSQL with PostGIS are supported. Could potentially add support for other platforms if an interest is expressed.
The documentation explain how to:
- install this doctrine extension,
- configure this extension,
- create spatial entities,
- use spatial functions in your repositories,
- contribute (and test)
The documentation contains a glossary of all available types and all available spatial functions.
This useful library was created by Derek J. Lambert. Alexandre Tranchant forked it from creof/doctrine-spatial because project seems to be non-active since 2017.
The dev branch can be used, but be careful backward compatibility aren't warrantied.
The main branch is dedicated to fix issue in the last stable version.
This doctrine extension is compatible with PHP 8.1+ Security fixes will follow the PHP Roadmap.
MySQL5.7 is supported, but is deprecated. MySQL8.0 is supported.
This spatial library is compatible with PostgreSql. This library is tested with the last versions of Postgis and PostgreSql.
RFC
I don't have enough money to buy the last edition of the ISO/IEC 13249-3:2016.
I only bought the previous version. This document is essential to know which functions are in Standard and which one
are specific to a database engine. If anyone has bought one and don't use it anymore, feel free to forward it. You can
contact me by mail, specified in composer.json.
Microsoft SQL Server I'm searching help to create a docker delivering a Microsoft SQL Server service. So I'll be able to implement compatibility with this database server.
MariaDB I'm searching help to create a Github action delivering a MariaDB service, to launch test and determine if this library is compatible.