2 ms·
Worked on a large application for the Dutch government with Oracle as database using spatial. Oracle is the only database that implemented spatial wrong (in my
by ivolimmen 6y ago
Worked on a large application for the Dutch government with Oracle as database using spatial. Oracle is the only database that implemented spatial wrong (in my opinion). Oracle is the only one that implemented spacial functions to have a parameter for the accuracy. So basically you spacial function could calculate things wrong depending on that parameter. We had issues in the calculations when we where subtracting land to see what parts we needed to buy from land owners for laying new roads. We could not fix this. Oracle didn't help. They payed millions for licenses but they did not offer enough support in my opinion. I did some of the calculations in postgres with the spacial extension and most of them where way faster (10 times was not uncommon). Postgres also did not fuck up the calculations like oracle did. The project actually had a huge amount of psql code and we could not switch to postgres...