Category: Thoughts

  • ESRI ArcSDE on MySQL or PostgreSQL

    Another ESRI conference is upon us and I just noticed that the survey that Jack Dangermond always sends out is in my inbox. I was filling it out as I always do putting in that I’d like support for MySQL or PostgreSQL and low and behold later in the survey there is a question asking if I’d like to see either. I can’t recall if that question was ever in a previous survey, but I know people have asked again and again at the technical workshops.

    Personally I’d love to see support for either. The biggest cost for SDE isn’t always SDE itself but a RDBMS that can support enough users on the internet. I still would always recommend Oracle over any other RDBMS, but I’ve run into a couple of situations where clients don’t have the money to spend on Oracle or SQL Server for their web applications and we have to leave all GIS data as Shapefiles (bah!). I’m not getting my hopes up that there will be an annoucement, but both MySQL and PostgreSQL have really taken off in the last 5 years. Personally I’d rather have PostgreSQL support, but either would be help us with our web deployments.