Regina Obe has developed a table to compare the new SQL Server 2008 with PostgreSQL/PostGIS (with MySQL thrown in there to boot). The table does a wonderful job showing the comparative strengths and weaknesses of all three relational databases.
SHARETHIS.addEntry({ title: “Comparing SQL Server 2008, MySQL and PostgreSQL/PostGIS”, url: “http://www.spatiallyadjusted.com/2008/07/21/comparing-sql-server-2008-mysql-and-postgresqlpostgis/” });
[Read more →]
Tags:Microsoft·MySQL·PostGIS·PostgreSQL·sql server 2008
PostgreSQL is about to get really integrated into ArcGIS workflows in 2008. First off we have ArcGIS Server Enterprise (ArcSDE) which will support PostgreSQL (ESRI and PostGIS data types) and now we have zigGIS 2.0 which will support PostGIS/PostgreSQL without the need for the traditional “ArcSDE” connection.
First and foremost, the zigGIS codebase will remain [...]
[Read more →]
Tags:arcgis·ArcGIS Server·arcmap·ArcSDE·ESRI·PostGIS·PostgreSQL·ziggis
OK, so here is what is happening at 9.3 with ArcSDE.
ArcSDE finally rides into the sunset. Even though technically ArcSDE has been replaced at 9.2, it was still a separate product. Now at 9.3 it will become fully integrated into ArcGIS Server. ArcGIS Server Enterprise will be the “traditional” ArcSDE level where [...]
[Read more →]
Tags:9.3·arcgis·arcgisserver·ArcSDE·geodatabase·oracle·PostGIS·PostgreSQL·spatial·sqlserver
I get tons of emails from people asking where they can get free ArcView licenses for home use. People really want to work with GIS at home as well as at work which makes sense to me. I’ve always pointed folks to QGIS and other tools, but Matt Perry has a wonderful and [...]
[Read more →]
Tags:GDAL·Geos·GIS·GMT·GPSBabel·GRASS·Mapserver·opensource·PostGIS·PostgreSQL·Proj·Python·QGIS·quantum gis·R·ubuntu
I’m “stuck” in Waikiki this week at our Honolulu office helping them get back on track with their GIS after our GIS coordinator resigned to join her husband in the peace corps on Tonga. The new GIS person is really excited about GIS and that is always nice to be around. Sometimes even [...]
[Read more →]
Tags:arcinfo·ArcSDE·dukes·ESRI·GIS·Mapserver·Open Source·PostGIS·QGIS·waikiki·wms