Dabble DB

The Dabble Blog

Announcing the Dabble DB Plugin API

Have you ever wanted to sort your competitors by their search engine rank? Look up the current retail prices of your Christmas wish list items? Group your contacts by the estimated cost of their homes?

Data loves company, and your private data can be so much more valuable when it’s combined with information pulled from the web. That’s why we’re announcing a new way for anyone to extend Dabble DB to do exactly that.

Seth Godin calls this kind of thing a websheet. We call it the Dabble DB Plugin API, and you can read more about it in Chad Fowler’s excellent tutorial. There’s plenty of info there on how it all works, but the key things I want to emphasize are:

  • It’s open. Anyone can write, host, and share a plugin on their own web server using whatever language and platform they want, without any fancy libraries or XML dialects needed.
  • It’s integrated. Once a user’s installed a plugin, all of that plugin’s functions will show up inside the Dabble UI just like any built-in function, and any new fields or data that the plugin produces will look and act just like anything else within Dabble.
  • It’s simple. We’ve modelled plugins after the tried and true Unix pipe-and-filter model of data manipulation. Dabble DB passes data in as plain text (in the form of a CSV file), and the plugin passes the transformed data back in the same format. That’s it.
  • It’s flexible. Maybe you don’t need to pull in data from the web, but just need to do some custom statistical calculations. Great. Maybe you want to do some crazy conditional formatting or generate Tufte-style sparklines. Perfect. Anything that involves taking one piece of data and returning another, whether it’s text, dates, times, durations, money, or images, is something a plugin can handle.
  • Did I mention it’s open? Seth Godin points out that although there is a tool with some basic websheet functionality, “it needs to be open so others can add to it”. This API is dead simple to implement; if any other vendors want to support these same plugins, we’d be thrilled.

Oh, and for Dabble DB users who just want a sample plugin to play around with, here’s one with pretty universal appeal: http://dabbledb.com/plugins/currency will perform some basic currency conversion for you using the daily rates from the Bank of Canada. But we don’t really want to be writing plugins ourselves. What we’re really excited about is seeing what the community does: since anyone can easily host a plugin at a cheap webhost - with or without distributing the source, with or without charging for access, with or without our approval or knowledge - the door’s wide open for developers. Come on in.


The comments to this entry are closed.