Dataclips 2.0 - A Pastebin For SQL
Written by Kay Ewbank   
Monday, 21 January 2013

There’s a new version of a tool described as pastebin for SQL. Dataclips 2.0 adds the ability to fork your dataclips, to control access granularly, and to create dashboards to make it easier to browse dataclips.

Dataclips has been developed by Heroku Postgres (https://postgres.heroku.com/), best known for providing the Postrgres SQL database as a service, to allow the results of SQL queries on a Heroku Postgres database to be easily shared.

The team at Heroku Postgres says they believe data should flow like water, and that you should be able to move data smoothly between apps, teams and services.

 

 

In practical terms Dataclips is a tool for sharing live query results where you define a dataclip as a sharable handle to a live query. Under the covers the dataclip is presented as an unguessable URL that you can email, tweak, or embed in something such as a spreadsheet. The recipients of a data clip are able to view the data in their browser or download it in JSON, CSV, XML, or Microsoft Excel formats.

The new version adds the ability to fork dataclips. Forking creates a new dataclip with a new URL that you can then modify. Your original dataclip still exists and will continue to be available at its original URL. The new tool makes it easier to update dataclips, so if you modify the query a dataclip runs, it will maintain its URL but changes will appear to those who access the clip. Dataclips 2.0 also adds a new dashboard that you can use to search clips by author, database, or name.

Another improvement to the new version is granular access control for dataclips. The previous version of dataclips used unique URLs as the security technique. Version 2.0 has added the ability to secure dataclips to specific Heroku accounts, and to securely grant or remove access to data without requiring you to recreate dataclips when access requirements change.

 

 

The final main improvement to the new release is the ability to embed dataclips directly into spreadsheets and into Google Docs and have them kept in sync.

More Information

https://devcenter.heroku.com/articles/dataclips

Related Articles

Ruby Creator moves to Heroku

 

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.

 

blog comments powered by Disqus

 

Banner


Break This Robot Apart And It Reassembles
06/04/2014

This is terrifying - a robot that you can't destroy. If you break it by kicking it to pieces then the pieces simply move towards each other and reassemble.
Is this science fiction or gothic horror mad [ ... ]



Google I/O 2014 Site Launches
27/03/2014

We already know the dates and venue for Google I/O 2014 - it will take place June 25-26 at Moscone West in San Francisco. Now that the event's website has opened there's some more information - b [ ... ]


More News

Last Updated ( Monday, 21 January 2013 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.