launchpad-dev team mailing list archive

Thread
Date

arbitrary user sql queries

To: Launchpad Community Development Team <launchpad-dev@xxxxxxxxxxxxxxxxxxx>
From: Martin Pool <mbp@xxxxxxxxxxxxx>
Date: Tue, 30 Nov 2010 14:35:05 +1100
Cc: Jorge Castro <jorge.castro@xxxxxxxxxxxxx>
Sender: martinpool@xxxxxxxxx

Jorge just pointed me to <http://odata.stackexchange.com/> which lets
anyone run arbitrary SQL against public data in StackExchange.

For example, <http://odata.stackexchange.com/ubuntu/s/666/most-democratic>
(the top 100 voters against askubuntu.)

Interesting bits:
 * This runs against a warehouse database, not the live db.
 * Based on Azure, hosted by msft.
 * The tool source is MIT licenced.
 * It seems to be real unfiltered sql, I would guess restricted only
by db permissions.  You can for instance create new (temporary?)
tables and insert into them.
<http://odata.stackexchange.com/ubuntu/s/348/my-money-for-jam>
 * They strip sensitive data on the way to the public warehouse.
 * You can save and share interesting queries.

They probably have a much simpler line between what's public and not
than lp could.

-- 
Martin