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.

 

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

 

Banner


Crazy Clocks
10/03/2024

It's that time again when the clocks change and  time is of the essence and I indulge my interest in crazy clocks. I am always surprised that there are still new ideas for how to display the time [ ... ]



Call For Code 2024 Focuses On Generative AI
01/03/2024

This year's Call for Code challenge has been launched with a theme of the use of generative AI technology for solutions that aim to improve equitable access to resources and opportunities for historic [ ... ]


More News

Last Updated ( Monday, 21 January 2013 )