search

haxetink / tink_sql

SQL embedded into Haxe
MIT License
53 stars 16 forks source link

more postgres support #131

Closed andyli closed 3 years ago

andyli commented 3 years ago

I used wkx for parsing the spatial values from PostGIS, because PostGIS used a sightly extended version of WKB (EWKB) that tink_spatial doesn't support at the moment.

kevinresol commented 3 years ago

basic EWKB support added to tink_spatial, @andyli please check if that is enough for your use case? https://github.com/haxetink/tink_spatial/commit/fb0d0a02ceed49325709215b5da0062fd8316c62

andyli commented 3 years ago

Somehow tink_spatial cannot parse the output from Postgres.

Postgres output buffer (hex):

0102000020E6100000020000000000000000000040000000000000F03F00000000000008400000000000000040

wkx parse result (GeoJSON):

{"type":"LineString","coordinates":[[2,1],[3,2]]}

tink_spatial gave error:

WKB type "4326" not supported
andyli commented 3 years ago

Ah, wait, my bad. I incorrectly stripped 4 bytes from the input. It seems to work correctly now.