Slinky – An easy way to query your PostgreSQL data (opens in new tab)

We use redash. This allows forking of queries, charting, and some light dashboarding. Also it supports full text searching of queries and descriptions. It's also stand alone and easy to launch on ec2.

https://github.com/EverythingMe/redash

The video on the landing page does not play.

'Video format or MIME type is not supported' on firefox 37.0.2 win 7 x64

I don't get it. What makes this better than simply giving out read-only users and using a local GUI like pgadmin?

This looks pretty awesome! It is also worth mentioning Django SQL Explorer (https://github.com/epantry/django-sql-explorer), which has all of the presented features, as well as handy schema definition by the side. It also allows for parameters in the queries, which is very useful (e.g. leaving the timeframe customisable before running a query). With Django 1.8 now being easier to install/deploy to wherever, this is a great plugin to allow more people data access!

Without clicking play on the video I don't find it clear what this actually does / is?

I thought that'd be an abstraction layer so people who are not that familiar with SQL but need some basic information can easily get it but this doesn't seem any different than just giving someone access to a view with a regular GUI client or http://pgcli.com/.

We use blazer[1] which is open source and lets you share queries just like this video demonstrates. It also has other nice features like composing results into charts and allowing interpolated values for generating queries with variable inputs. The demo[2] has examples for the features I mentioned.

1: https://github.com/ankane/blazer

2: https://blazerme.herokuapp.com/

Seems like a pretty dull service at face value. But actually works really well for my co-founder and I. Good work! Sorry for the bitter sweetness =D

It would be nice to understand a bit more about how it works before you have to sign up, however looks useful

ZenQuery does something quite similar but for a variety of RDBMS: http://www.zenqry.com/

It's not limited to Heroku but can be used with any database connection URL. In fact, ZenQuery was modelled after Heroku Dataclips.

(sorry for the plug)

How did you guys drop down to a read-only connection on Heroku Postgres? We directly connect DB clients like PGAdmin to a reporting DB on Heroku, but Heroku only seems to support credentials with full access. I don't want an analyst to "DROP TABLES" by mistake.

I can't see the video, and without that the landing page doesn't tell me anything. How is this different from periscope.io?

Just use pgadmin, ipython+pandas, or pgweb.

Sounds a lot like heroku data clips?