Heroku makes sharing SQL data as easy as URL (gigaom.com)

117 points by bbr 14y ago ↗ HN

9 comments

[ 3.4 ms ] story [ 29.6 ms ] thread

Man, if you could hook up a Data Clip to http://explain.depesz.com, how great would that be?

pvh 14y ago ↗

Good idea!

anyone know of an open source tool that approximates this? i'd love to build something like it at my company. would be used a ton.

davyjones 14y ago ↗

I am guessing it is for your company intranet? If you are powering it with nginx, you can tack the postgres add-on (https://github.com/FRiCKLE/ngx_postgres/) and go from there.

jasonkeene 14y ago ↗

perhaps this? http://htsql.org/

83457 14y ago ↗

though not quite the same, anytime someone talks about SQL and URLs in the same sentence i think of htsql

benatkin 14y ago ↗

The clever thing is having saved query results and a way to re-run the query. Besides that it's just a nice executable SQL pastebin with a good user auth strategy (integration into an existing system).

willvarfar 14y ago ↗

I just wiped their data by appending

    Robert'); DROP TABLE Students; --

To the URL!

Not really, but it makes you wonder strongly about security.

http://xkcd.com/327/

pvh 14y ago ↗

If you can make a dataclip, you have access to the database. We've audited it for privilege escalation and put some simple shooting-yourself-in-the-foot protection in, but if you REALLY REALLY want to screw yourself over you can probably find a way.