I'll figure it out tonight, maybe write a CLI tool to debug with...
Need to grab some lunch :S
Samuel Denis-D'Ortun
@sadortun
Hello guys, we could probably close the following issue since they were resolved ; creof/doctrine2-spatial#121creof/doctrine2-spatial#54creof/doctrine2-spatial#128
Derek J. Lambert
@djlambert
#121 has a work around but proxies haven't been implemented yet. I'm not convinced #128 is resolved but not much we can do without more information.
Derek J. Lambert
@djlambert
Currently in wkt-parser and wkb-parser the namespace uses WKT or WKB in all uppercase. The class names in geo-obj are currently CamelCased (Wkt, Wkb). Should I uppercase these to be consistent, or should the "standard" be uppercase namespace, CamelCase classes?
Jon West
@ddproxy
Uh, Uppercase all the things. WKB, WKB are acronyms
Derek J. Lambert
@djlambert
ok thanks. That was my thought on the other libraries. Not sure why I CamelCased it here. lazy fingers
Jon West
@ddproxy
Likewise...
Philippe CARLE
@philippecarle
just wanted to say ¸¸.•¨•♫♪ Thanks ! (it's not enough often in OS world)
Samuel Denis-D'Ortun
@sadortun
@philippecarle :sparkles:
Derek J. Lambert
@djlambert
:)
Philippe CARLE
@philippecarle
hey there
Has someone already benchmarked performance of "usual" spatial operations with this doctrine extension between MySQL 5.7 and PostGIS ?
Samuel Denis-D'Ortun
@sadortun
@philippecarle I would say fast enough ! Working of 5M points, and performance is not a concern for now.
Jon West
@ddproxy
@philippecarle 26M points here... No issues yet.
Peter Juanda
@pjuanda
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
Derek J. Lambert
@djlambert
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
Peter Juanda
@pjuanda
@djlambert i think custom dbal will solve the issue. Custom dbal allow you to load an extension for processing the data. Ehm, i have try it, and found the geometry command can be executed perfectly
_
Derek J. Lambert
@djlambert
do you have any sample code?
Peter Juanda
@pjuanda
currently my implementation still dirty, i just copy the mysql folder with contain the functions to new folder as sqlite, with some tweaking it works.
Derek J. Lambert
@djlambert
for loading the extension in dbal
Peter Juanda
@pjuanda
@djlambert i'll try dig deeper in this weekend, and i'll share it over here
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
Derek J. Lambert
@djlambert
I thought I had tried something similar last year but can't recall exactly. I can take a look this weekend.
Peter Juanda
@pjuanda
@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
Derek J. Lambert
@djlambert
thanks for the heads up
Peter Juanda
@pjuanda
@djlambert thanks anyway, much appreciate. I'll notify in here if i find out the problem and the solution to fix it