I have searched on google and the archives for a technical comparison of Oracle and PostgreSQL (also MySQL), unsuccessfully.
Is there any comparison that covers more than just the basic differences? Maybe you can give me some comparison?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
Thesis by Shamal Kiran Matty (2012) 'Comparative study of Oracle Spatial and Postgres Spatial' discusses quite a lot of issues that might be of interest here.
From the summary:
However, the research done as a part of this thesis suggests that PostGIS is more advantageous over Oracle Spatial for the reasons stated below:
- Cost Savings
- Ease of Integration
- Ease of use
- Superior performance
- Feature rich
- Lower disk usage
Check BostonGIS Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features. If that's too basic: Which topics do you need covered?
MySQL is not usable for serious GIS work.
In the meantime I had found the following Comparison of Oracle, MySQL and PostgreSQL DBMS which i think is a good overview.