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 _______________________________________________ Mailing list: https://launchpad.net/~launchpad-dev Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-dev More help : https://help.launchpad.net/ListHelp
