Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Oct 15 14:26
    SebastienTainon commented #196
  • Aug 08 18:40
    holtkamp commented #205
  • Aug 08 18:37
    holtkamp commented #205
  • Aug 06 08:51
    holtkamp commented #205
  • Aug 05 14:44
    holtkamp edited #196
  • Aug 05 14:40
    holtkamp commented #196
  • Aug 05 12:13
    coveralls commented #205
  • Aug 05 12:02
    xabbuh commented #204
  • Aug 05 12:01
    xabbuh opened #205
  • Aug 02 14:01
    jmmorillon opened #204
  • Jul 15 14:57
    bjmmartin closed #203
  • Jul 15 14:57
    bjmmartin commented #203
  • Jul 12 15:10
    bjmmartin edited #203
  • Jul 12 15:07
    bjmmartin opened #203
  • Jul 11 12:48
    emanuelesogus opened #202
  • Jun 17 14:03
    asikrhmn commented #191
  • May 25 13:08
    holtkamp commented #201
  • May 25 13:04
    holtkamp commented #201
  • May 24 09:23
    lngphp edited #201
  • May 24 09:01
    lngphp edited #201
Jon West
@ddproxy
Yeah and to compare with postgres error if applicable... anyways moment
Jon West
@ddproxy
ERROR:  Invalid endian flag value encountered.
********** Error **********

ERROR: Invalid endian flag value encountered.
SQL state: XX000
Derek J. Lambert
@djlambert
that's interesting
wkb-parser should have thrown an error for that too
Jon West
@ddproxy
How did I mess that up...
Derek J. Lambert
@djlambert
what's the first byte?
should be 0 or 1
Jon West
@ddproxy
0
Derek J. Lambert
@djlambert
0x00?
Jon West
@ddproxy
0103000020E610000098000000
But, interesting... The difference between my two files is one is wrapped with "s and the other is not..
Derek J. Lambert
@djlambert
polygon?
Jon West
@ddproxy
Oh yeah
donuts ;)
Derek J. Lambert
@djlambert
the byte order is 01 but that's still valid
03 00 00 20 should be polygon with srid
so that doesn't have any strange flags
Jon West
@ddproxy
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#121 creof/doctrine2-spatial#54 creof/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
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
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