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.
Comparing SQL Server 2008, MySQL and PostgreSQL/PostGIS
July 21st, 2008 · 9 Comments · GIS
Tags:Microsoft·MySQL·PostGIS·PostgreSQL·sql server 2008
zigGIS 2.0 Coming Soon
December 19th, 2007 · 7 Comments · ArcGIS Desktop, ArcSDE, ESRI, Open Source, PostGIS, PostgreSQL
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 [...]
Tags:arcgis·ArcGIS Server·arcmap·ArcSDE·ESRI·PostGIS·PostgreSQL·ziggis
ArcGIS Server and ArcSDE (and Even Microsoft SQL Server 2008 Spatial)
December 17th, 2007 · 58 Comments · ArcGIS Server, ArcSDE, ESRI
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 [...]
Tags:9.3·arcgis·arcgisserver·ArcSDE·geodatabase·oracle·PostGIS·PostgreSQL·spatial·sqlserver
Create GIS Workstation Using Ubuntu and Open Source GIS Software
October 22nd, 2007 · 34 Comments · GRASS, Mapserver, OSGeo, Open Source, PostGIS, PostgreSQL, QGIS
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 [...]
Tags:GDAL·Geos·GIS·GMT·GPSBabel·GRASS·Mapserver·opensource·PostGIS·PostgreSQL·Proj·Python·QGIS·quantum gis·R·ubuntu

