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...

Amazon Web Services launches SimpleDB Beta

Amazon SimpleDB is on its way and it may just change how you use databases with your web applications (or even desktop apps). SimpleDB is a web service that leverages Amazon S3 and Amazon EC2 to store, process and query datasets. Currently most if not all of us use a RDBMS such as SQL Server, Oracle, MySQL or PostgreSQL to store our data, but that requires hardware and most of the time a DBA to administer database.

Can you imagine a spatial component to Amazon SimpleDB and how you’d integrate it with your workflows? My spine is tingling just thinking about the possibilities.

You can learn more about the details of SimpleDB here.

Update: The more I think about this, the more I realize how disruptive SimpleDB will be. It was designed to be used with web applications and will be able to scale with them easily. You just can’t do that on your own. I was writing about AWS back in June and how its ability to scale could help users provide services that only the largest companies can afford.