6 ms·
Heroku makes sharing SQL data as easy as URL
- jaylevitt 15y agoMan, if you could hook up a Data Clip to http://explain.depesz.com http://explain.depesz.com, how great would that be?
- pvh 15y agoGood idea!
- alexmr 15y agoanyone 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 15y agoI 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/ https://github.com/FRiCKLE/ngx_postgres/) and go from there.
- jasonkeene 15y agoperhaps this? http://htsql.org/ http://htsql.org/
- 83457 15y agothough not quite the same, anytime someone talks about SQL and URLs in the same sentence i think of htsql
- benatkin 15y agoThe 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 15y agoI 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/ http://xkcd.com/327/
- pvh 15y agoIf 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.