Has someone already benchmarked performance of "usual" spatial operations with this doctrine extension between MySQL 5.7 and PostGIS ?
Hi there, can we add support for sqlite ?
If there is an issue with sqlite pdo that forbid us to load extension, we can use custom sqlite dbal that provided in here jsor/dbal-sqlite3
If there is an issue with sqlite pdo that forbid us to load extension, we can use custom sqlite dbal that provided in here jsor/dbal-sqlite3
DBAL won't solve the issue, it's in the PDO driver. https://bugs.php.net/bug.php?id=64810. The only way around this currently is to patch and compile a local copy.
local copy of PHP
just a minute
here is the code
i create a new driver which extends from jsor/dbal-sqlite3 and define the extensions
i find it works, but that is still very dirty implementation
@djlambert ok, but be aware that i find some issue with json/dbal-sqlite3 driver. Currently in my testing, the driver cause some issue in doctrine locking, in which i still debugging the issue
*looking for the cause