Here comes the anti-database “movement”

I’ve been seeing more and more articles like this one from Computerworld about abandoning SQL databases.

The meet-up in San Francisco last month had a whiff of revolution about it, like a latter-day techie version of the American Patriots planning the Boston Tea Party. The inaugural get-together of the burgeoning NoSQL community crammed 150 attendees into a meeting room at CBS Interactive. Like the Patriots, who rebelled against Britain’s heavy taxes, NoSQLers came to share how they had overthrown the tyranny of slow, expensive relational databases in favor of more efficient and cheaper ways of managing data.

NoSQLers?  Oh boy are we going to be in for it when they hear how critical databases are for the geospatial industry.  To me this “revolution” sounds more like a backlash against the traditional SQL DBA who doesn’t want to change in the face of “Web 2.0″.  Of course it is very easy to move to a new data storage platform when you either have a ton of money or no product yet.  While I do think technology such as Google’s BigTable and Amazon’s SimpleDB as an inevitable course for many web applications, wholesale abandonment of SQL and databases such as Oracle/SQL Server/PostgreSQL is absurd.

No-SQL Patriots dump RDBMS without a care to the implications...

No-SQL "Patriots" dump RDBMS without a care to the implications...

Comparing SQL Server 2008, MySQL and PostgreSQL/PostGIS

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.

zigGIS 2.0 coming soon

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 open. Secondly, personal and educational use of zigGIS will remain free…

As for our corporate users – you will need to purchase licenses per seat. Licenses will fall somewhere below $300 each. We hope this keeps zigGIS affordable to those organizations that require heavy-duty GIS capabilities. (don’t forget that the use of PostGIS + zigGIS saves you from all ArcSDE licensing costs)

If you are in an enterprise environment, ArcGIS Server Enterprise probably makes a ton of sense (especially in the ESRI server stack), but in smaller offices and workgroups why pay for all that overhead you are not using?

ArcGIS Server and ArcSDE (and even Microsoft SQL Server 2008 Spatial)

OK, so here is what is happening at 9.3 with ArcSDE.

  1. 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 ArcGIS Server supports an unlimited number of users via either direct connect or connection to an application server. It offers DBMS support for IBM DB2, IBM Informix, all editions of Microsoft SQL Server, Oracle and PostgreSQL. It has no data or memory limits. The Workgroup level of ArcGIS Server supports a maximum of 10 direct connect users. It includes an embedded DBMS (Microsoft SQL Server Express Spatial). It has a data limit of 4 GB and a memory limit of 1 GB.
  2. ArcGIS will connect to Microsoft SQL Server via direct connect. Out of the box ArcGIS application will be able to connect to Microsoft SQL Server Express Spatial, but if you want unlimited users, you’ll need to purchase ArcGIS Server Enterprise. This is probably less than what folks wanted, but you’ll have to sort that our yourselves.
  3. ArcGIS supports older versions of the Geodatabase. At 9.3, ArcGIS can connect and create geodatabases (personal, file) back to 9.0. This means you won’t need to keep older versions of the geodatabase around to share with others. You also won’t have to upgrade your geodatabases just because ArcGIS went to a new release. If you wish, you can keep your older geodatabases running at whatever release you wish (back to 9.0).
  4. SQL Server 2008 Spatial will be fully supported when Microsoft releases final version of SQL Server 2008. This might mean that SQL Server 2008 support might not show up until SP1 or SP2 for 9.3. It all depends on Microsoft’s release schedule.
  5. PostgreSQL support will be available at 9.3 as has been reported. There will be support for both the PostGIS and ESRI data types.
  6. ArcGIS Engine will allow developing with Microsoft SQL Server 2008 Express so you can scale down your enterprise applications to the workgroup level. You’ll no longer be limited to working with personal for file geodatabases.
  7. ArcGIS Server Enterprise will support 64bit processors. This is only the spatial database application server and not the AGS Basic, Standard and Advanced product.

So does that answer your questions about ESRI spatial database support at 9.3?

Create GIS workstation using Ubuntu and open source GIS software

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 easy way to most of the important open source GIS tools on Ubuntu with just a couple of commands.

just keeps getting easier and easier to get a fully functional open source GIS workstation up and running thanks to Ubuntu. The following instructions will take your vanilla installation of Ubuntu 7.10 and add the following top-notch desktop GIS applications:

Postgresql/PostGIS : a relational database with vector spatial data handling
GRASS : A full blown GIS analysis toolset
Quantum GIS: A user-friendly graphical GIS application
GDAL, Proj, Geos : Libraries and utilities for processing spatial data
Mapserver : web mapping program and utilites
Python bindings for QGIS, mapserver and GDAL
GPSBabel : for converting between various GPS formats
R : a high-end statistics package with spatial capabilities
GMT : the Generic Mapping Tools for automated high-quality map output

Download Ubuntu, install, run a simple command, enjoy GIS for free. Seems like a great solution to me!


Look how fun OSGeo is!