Postgresql vs oracle 2017

broken image
broken image

More than once I'd identify a feature that provided a solution to an issue through online research only to be prevented from using it due to the customer not having the requisite license for it.Īnd the support was useless. The licensing for Oracle was highly granular, down to the feature level. The development experience with Oracle was also awful. We were using PostGIS to support spatial queries (a key requirement), and Oracle Spatial was just not at the same level (both in performance and features). I've been on a project where we were forced to migrate the opposite direction: From PostgreSQL to Oracle, because the client was already paying for Oracle licenses and really, really, wanted us to use Oracle to justify the expense.

broken image