3 ms·
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 als
by darkxanthos 11y ago
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 https://github.com/EverythingMe/redash
- aidos 11y agoThis 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.
- dulvac 11y agoThat 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?
- darkxanthos 11y agoYeah 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.
- arikfr 11y agoYes, 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.
- staz 11y agoWe 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