NextGIS completed the transition from Oracle and Oracle Spatial to PostgreSQL/PostGIS for the new application of iFort.
iFort has decided to broaden its line of products with the new geomarketing application. Existing solutions of the company are using Oracle for storing the data. New application required more lightweight and easy to use database with capabilities to store and process geospatial data. PostgreSQL with PostGIS was a natural candidate.
NextGIS has adapted and transitioned server procedures from Oracle and Oracle Spatial to PostgreSQL/PostGIS, there were also developed several new stored procedures using PL/pgSQL language. In particular, NextGIS developed algorithms for detection of clustered geometries and calculation of reachable transport networks.
We were pleased with flexibility of SQL and choice of languages to create stored procedures. For our applications, PostgreSQL was on par with Oracle in terms of productivity in most and was superior in several cases. Serious stress-testing is planned, but we are already certain that we’ve got more than expected from migration to PostgreSQL. NextGIS’ expertise and attention to our problems made the transition painless.
Alexander Chilingaryan
CEO, iFort
