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


Hour of Code Aims to Reach 100 Million Worldwide
09/10/2014

After its successful debut last year, in which the inaugural Hour of Code reached well over its initial target of 10 Million students, Code.org has embarked on a crowdfunding campaign to raise $5 mill [ ... ]



The Astonishing Rise Of Dart
13/10/2014

If the signs are to be believed Dart, Google's JavaScript replacement is shooting up the popularity stakes. Should Dart be the next language you learn?


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.