<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en-us" xmlns="http://www.w3.org/2005/Atom"><title>Simon Willison's Weblog: dabbledb</title><link href="http://simonwillison.net/" rel="alternate"/><link href="http://simonwillison.net/tags/dabbledb.atom" rel="self"/><id>http://simonwillison.net/</id><updated>2010-03-27T18:43:42+00:00</updated><author><name>Simon Willison</name></author><entry><title>Preview: Freebase Gridworks</title><link href="https://simonwillison.net/2010/Mar/27/gridworks/#atom-tag" rel="alternate"/><published>2010-03-27T18:43:42+00:00</published><updated>2010-03-27T18:43:42+00:00</updated><id>https://simonwillison.net/2010/Mar/27/gridworks/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://blog.freebase.com/2010/03/26/preview-freebase-gridworks/"&gt;Preview: Freebase Gridworks&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
If my experience with government datasets has taught me anything, it’s that most datasets are collected by human beings (probably using Excel) and human beings are inconsistent. The first step in any data related project inevitably involves cleaning up the data. The Freebase team must run up against this all the time, and it looks like they’re tackling the problem head-on. Freebase Gridworks is just a screencast preview at the moment but an open source release is promised “within a month”—and the tool looks absolutely fantastic. DabbleDB-style data refactoring of spreadsheet data, running on your desktop but with the UI served in a browser. Full undo, a JavaScript-based expression language, powerful faceting and the ability to “reconcile” data against Freebase types (matching up country names, for example). I can’t wait to get my hands on this.

    &lt;p&gt;&lt;small&gt;&lt;/small&gt;Via &lt;a href="http://blog.jonudell.net/2010/03/26/freebase-gridworks-a-power-tool-for-data-scrubbers/"&gt;Jon Udell&lt;/a&gt;&lt;/small&gt;&lt;/p&gt;


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/cleanup"&gt;cleanup&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/dabbledb"&gt;dabbledb&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/data"&gt;data&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/freebase"&gt;freebase&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/gridworks"&gt;gridworks&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/javascript"&gt;javascript&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/open-data"&gt;open-data&lt;/a&gt;&lt;/p&gt;



</summary><category term="cleanup"/><category term="dabbledb"/><category term="data"/><category term="freebase"/><category term="gridworks"/><category term="javascript"/><category term="open-data"/></entry><entry><title>Magic/Replace</title><link href="https://simonwillison.net/2008/Dec/1/magicreplace/#atom-tag" rel="alternate"/><published>2008-12-01T00:23:10+00:00</published><updated>2008-12-01T00:23:10+00:00</updated><id>https://simonwillison.net/2008/Dec/1/magicreplace/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://cleanupdata.com/"&gt;Magic/Replace&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
More inspirational magic from the team at Dabble DB. Be sure to watch the (short) demo video.


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/avi-bryant"&gt;avi-bryant&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/cleanupdata"&gt;cleanupdata&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/dabbledb"&gt;dabbledb&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/data"&gt;data&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/magicreplace"&gt;magicreplace&lt;/a&gt;&lt;/p&gt;



</summary><category term="avi-bryant"/><category term="cleanupdata"/><category term="dabbledb"/><category term="data"/><category term="magicreplace"/></entry><entry><title>Giving Dabble DB a time machine</title><link href="https://simonwillison.net/2008/Oct/7/dabble/#atom-tag" rel="alternate"/><published>2008-10-07T12:55:50+00:00</published><updated>2008-10-07T12:55:50+00:00</updated><id>https://simonwillison.net/2008/Oct/7/dabble/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://blog.dabbledb.com/2008/09/giving-dabble-d.html"&gt;Giving Dabble DB a time machine&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
More innovation from Dabble DB—the service now offers a UI to their backup snapshots, letting you roll your own instance back to a specific point in time to recover accidentally deleted data.


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/dabbledb"&gt;dabbledb&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/revert"&gt;revert&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/snapshots"&gt;snapshots&lt;/a&gt;&lt;/p&gt;



</summary><category term="dabbledb"/><category term="revert"/><category term="snapshots"/></entry><entry><title>White- (or green, or blue, or yellow) label Dabble</title><link href="https://simonwillison.net/2007/Apr/4/dabble/#atom-tag" rel="alternate"/><published>2007-04-04T23:43:19+00:00</published><updated>2007-04-04T23:43:19+00:00</updated><id>https://simonwillison.net/2007/Apr/4/dabble/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://dabbledb.com/blog/?p=87"&gt;White- (or green, or blue, or yellow) label Dabble&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
DabbleDB can pick a colour scheme based on a logo that you upload. Pure class.


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/colour"&gt;colour&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/dabbledb"&gt;dabbledb&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/logo"&gt;logo&lt;/a&gt;&lt;/p&gt;



</summary><category term="colour"/><category term="dabbledb"/><category term="logo"/></entry><entry><title>Guide to the Dabble DB Plugin API</title><link href="https://simonwillison.net/2007/Jan/9/dabble/#atom-tag" rel="alternate"/><published>2007-01-09T11:37:26+00:00</published><updated>2007-01-09T11:37:26+00:00</updated><id>https://simonwillison.net/2007/Jan/9/dabble/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://dabbledb.com/help/guides/pluginapi/"&gt;Guide to the Dabble DB Plugin API&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
This is really nice—Dabble POSTs your plugin script a bunch of CSV values, your script returns CSV for the derived fields. Doesn’t seem to state which flavour of CSV though.

    &lt;p&gt;&lt;small&gt;&lt;/small&gt;Via &lt;a href="http://www.cincomsmalltalk.com/blog/blogView?showComments=true&amp;amp;entry=3345752150"&gt;James Robertson&lt;/a&gt;&lt;/small&gt;&lt;/p&gt;


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/api"&gt;api&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/chad-fowler"&gt;chad-fowler&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/csv"&gt;csv&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/dabbledb"&gt;dabbledb&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/plugins"&gt;plugins&lt;/a&gt;&lt;/p&gt;



</summary><category term="api"/><category term="chad-fowler"/><category term="csv"/><category term="dabbledb"/><category term="plugins"/></entry><entry><title>Jon Udell's The Screening Room: Dabble DB</title><link href="https://simonwillison.net/2006/Nov/1/jon/#atom-tag" rel="alternate"/><published>2006-11-01T12:16:37+00:00</published><updated>2006-11-01T12:16:37+00:00</updated><id>https://simonwillison.net/2006/Nov/1/jon/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://weblog.infoworld.com/udell/2006/10/31.html"&gt;Jon Udell&amp;#x27;s The Screening Room: Dabble DB&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
Not quite as impactful as a “live” demo, but still really impressive.


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/dabbledb"&gt;dabbledb&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/jon-udell"&gt;jon-udell&lt;/a&gt;&lt;/p&gt;



</summary><category term="dabbledb"/><category term="jon-udell"/></entry></feed>