Home Heroku Data Clips Make Sharing Results from Postgres Queries Simple

Heroku Data Clips Make Sharing Results from Postgres Queries Simple

Heroku has added a data clips feature to its Heroku Postgres databases. What’s that, you ask? According Heroku’s Matthew Soldo, data clips are a “convenient way to share data inside a database.”

Basically, the feature lets users of Heroku Postgres share a result of a SQL query via a URL. The results can be viewed in the browser, or downloaded in several standard formats.

What’s the point of the feature? Rather than sharing a static snapshot of a query, this allows users to see a live result of a query at any given time. (Data Clips can also be locked to a specific time, if preferred.) So, for example, this might be useful to share up-to-date statistics on current inventory or sales results.

The example given on the Heroku blog combs through Wikipedia entries and finds people in the English articles with the term scientist or artist.

Note that this is not a feature that’s available via upstream PostgreSQL. Soldo says that the feature is built on top of Heroku’s Web based administration tool. “Because PostgreSQL doesn’t have a built-in webserver, this feature wouldn’t be possible on the standalone database.”

The feature is immediately available to users of Heroku Postgres. Note that clips do have a few limits. Results are limited to 10,000 rows and the clips will not refresh more than once every 60 seconds.

This looks like a pretty nifty feature. Is this compelling enough to consider using Heroku Postgres instead of a self-hosted PostgreSQL database, though? Would be curious to hear what other folks think about it.

About ReadWrite’s Editorial Process

The ReadWrite Editorial policy involves closely monitoring the tech industry for major developments, new product launches, AI breakthroughs, video game releases and other newsworthy events. Editors assign relevant stories to staff writers or freelance contributors with expertise in each particular topic area. Before publication, articles go through a rigorous round of editing for accuracy, clarity, and to ensure adherence to ReadWrite's style guidelines.

Get the biggest tech headlines of the day delivered to your inbox

    By signing up, you agree to our Terms and Privacy Policy. Unsubscribe anytime.

    Tech News

    Explore the latest in tech with our Tech News. We cut through the noise for concise, relevant updates, keeping you informed about the rapidly evolving tech landscape with curated content that separates signal from noise.

    In-Depth Tech Stories

    Explore tech impact in In-Depth Stories. Narrative data journalism offers comprehensive analyses, revealing stories behind data. Understand industry trends for a deeper perspective on tech's intricate relationships with society.

    Expert Reviews

    Empower decisions with Expert Reviews, merging industry expertise and insightful analysis. Delve into tech intricacies, get the best deals, and stay ahead with our trustworthy guide to navigating the ever-changing tech market.