Included shp2pgsql, OGR2OGR, QuantumGIS SPIT, SHP loader for PostGIS also developed by Morten using SharpMap.NET various others Shp dataloader for SQL Server 2008 developed by Morten Nielsen (doesn't yet work with RC0) The comments are actually much more informative than the article itself.įLOSS (PostgreSQL is BSD, PostGIS is GPL Open Source - you can use for commercial apps but if you make changes to the core libraries of PostGIS, you need to give that back to the community) Here is an interesting blog entry on the subject MySQL free software but not Open Source. Windows 2000+ (including Vista and 2003, haven't tested on 2008), Linux, Unix, MacĬommercial - Closed Source, Various levels of features based on version, Express version has full spatial support but limitation on database size and only use one processor.Ĭommercial Open Source (COSS), some parts GPL. Windows XP, Windows Vista, (haven't tested on 2008), Linux, Unix, Mac Windows XP, Windows Vista, Windows 2003, Windows 2008 Its tool set is also very nice for general db management. SQL Server while its not free except for its express version, all its spatial is fully-supported in its express (so no major hidden gotchas), its pricing is low enough, install base high, and inertial costs of switching a db platform that you can't discount it on price alone especially if you are a windows-only shop with a wealth of applications built on SQL Server. IBM is not too bad and its express may be adequate. Will probably break the bank at least a little or make your product more pricey than it needs to be. If you have dreams of database farms and clouds, deployment of custom apps for many clients, the licensing costs of Oracle offerings See DB2 Express-C and DB2 Spatial Extender White paper for more details. The unique generosity of allowing up to 2 processors, unlimited size db, but limited to 4G on board memory. Their IBM DB2 Express-C does have a freely downloadable DB2 Spatial Extender which by accounts appears to be rich and they do have IBM charges for geodetic as a separate priced blade on-top of their regular offerings. Enterprise Spatial licensing limitations and Oracle 11G locator white paper. While Oracle 11G is a bit more generous than its 10G offering, locator spatial functions are significantly less than Oracle Spatial and are missing critical functions such as ST_Intersection and ST_Centroid.Īlthough Oracle locator does provide geodetic support, it has vastly less functionality than their Oracle Spatial offering. Oracle 11G only provides Locator (and not Oracle Spatial) for their express and Non-Enterprise, for Enterprise - its an additional priced offering on top of the regular enterprise price to upgrade your Locator to Spatial. That can be used, functionality and size of database. Offerings are in general more costly and while the free versions of those do offer a great bit of functionality, they are limited to number of processors If MySQL spatial capabilities does just enough of what you need and at adequate speed, by all means there is no need to swap it out. SQL Server 2008 spatial and PostGIS, we felt it important to include because MySQL has such a large install base. While the spatial functionality and speed of MySQL significantly lags that of functionality SQL Server 2008 and PostGIS are the front-runners. We shall note that in terms of affordability vs. Most of this information is gleened from the help docs and our general We are onlyĬomparing these three databases because these are the ones we use most often and care about. In this comparison we shall focus on the suitability of these for spatial analysis, mapping and general GIS processing. This article is a compliment to our Postgres OnLine Magazine May/June 2008 issue Cross Compare of SQL Server, MySQL, and PostgreSQLĪnd our inaugural issue December 2007 PostGIS for geospatial analysis and mapping. Cross Compare SQL Server 2008 Spatial, PostgreSQL/PostGIS 1.3-1.4, MySQL 5-6
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |