Hacker News Reader

Comment by darkxanthos | Hacker News Reader

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

View on HN

We directly use an ipython notebook server shared for the whole company. A lot more flexible but require a big level of trust since it allow total system control

That looks great! I very much prefer the canonical SQL for querying data in a visual way, rather than a "generic" custom querying language. Does it send the query directly to the db? Is there any transformation? Does it mean it only works with sql databases?

Yeah it's basically just a web based SQL front end. It also integrates with Google accounts very well which was a big plus for us.

Yes, Redash sends the query as is to the database. It currently supports PostgreSQL (& Redshift), MySQL, BigQuery, MongoDB, Graphite and Python scripts. Also someone currently working on ElasticSearch support.

The MonogDB & Graphite support is crude, but exists.

I'm the project maintainer, feel free to ask if you have any questions.

This looks great! I have a number of adhoc queries I keep kicking around. Some of which them are timeseries based and I've taken the time to pump those into graphite, but others are just interesting to see in their own right sometimes.

Thanks for sharing.

Reply on news.ycombinator.com