Changes between Initial Version and Version 1 of Ticket #21273, comment 10
- Timestamp:
- Mar 13, 2014, 6:00:04 AM (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #21273, comment 10
initial v1 1 Reason why XE doesn't work is obvious: 2 3 GeoDjango uses Oracle built-in WKT transformations which require Java within DB engine itself and XE is missing that. 4 5 Also context switching between Java and PL/SQL is dead slow. 6 1 7 SDO_GEOMETRY itself has been same for a good while. I do have almost working version of read/write support for Oracle XE, as well as 3D support for Oracle geometries in general. 2 8 … … 4 10 5 11 Currently I think that backend I've been working on is only failing is some coordinate transformations. 12 13 For reading I do read plain SDO_GEOMETRY object, convert it to GeoJson (it's slightly more simpler format than WKT and GEOS/GDAL supports 3D GeoJSON better than 3D WKT). 14 15 For writing I do parse plain GEOSGeometry, construct SDO_GEOMETRY like CLOB string and push it through special PL/SQL function in a database. 16 17 There is a caveat here: For writing installing (one time for whole database) special package is required.