31–40 of 98 posts
Hi! I'm the author of Redash :) Nice to see Redash at the top of HN. I'll be happy to answer any questions about Redash, open source and about my journey to make Redash a self sustainable project. For any questions that don't fit on HN, feel free to reach me at arik at redash.io.
How does the externally hosted version connect to databases?
You will need to allow access from our servers to your database. It's obviously a security concern, but we take great measures to ensure the safety of your data.
If that's not an option, you can always run Redash self hosted.
It replaces event- and user-tracking tools like Mixpanel, Heap, Woopra, and others. Those are just UI layers on top of SQL queries. If you or your marketers know (or can learn) even basic SQL then Redash is what you want.
Earlier quoted context omitted.
Re. filtering: do you mean something like parameters? Because that's supported.
Not exactly. Say I have a table with one row per user and want users for a given country. I could say SELECT country_code AS country_code::multi-filter, count(1) AS users FROM mytable GROUP BY country_code; And I will indeed get a dropdown with country codes. But, the query is still running for all countries (and if I'm not mistaken all the filtering is on the client). For something more complex, like number of users…
SELECT country_code AS "cc::filter", COUNT(1) as num_users FROM mytable WHERE lifetime_spend > {{minimum_lifetime_spend}} GROUP BY country_code
And minimum_lifetime_spend will render as an input box. Currently we only support input boxes (of different types - number/string/date), but there is a plan to add support for dropdowns there as well.
Allowing self serving without knowing SQL is the goal, but I believe it will take time to do it right. We focus on delivering a great product for people who know SQL, and allow them to give more interactive result sets to other users using things like parameters.
So not sure if our goal is less ambitious, but we just take a different path. And that's good I guess, it would've been not interesting if everyone built the same thing, the same way :-)
Redash is great. We've tried several alternatives, including Metabase, and ended up with extensive Redash use. We use the self-hosted version for sharing data between the tech and business sides, for day-to-day monitoring and for ad-hoc visualizations, and are generally very happy with it. It's not perfect - there are some areas, like fine-control over chart customization, query auto-updates (especially queries with…
That's definitely possible. You might need to tune the number of workers you have to run queries (and maybe adjust your database settings, if it has limits on concurrency).
If you need help with this, you're welcome to the forum[1], Gitter[2] or Slack[3].
[1] https://discuss.redash.io [2] https://gitter.im/getredash/redash [3] https://slack.redash.io
I settled for Metabase (http://www.metabase.com/ , https://github.com/metabase/metabase ), mainly for the ease of use and installation (a simple java -jar metabase.jar does the trick).
Redash was a close second (one advantage at that time was the ability to have users that could only read queries), but after fighting with it for a while in order to install it, I tested Metabase and haven't looked back since.
Redash is great. We've tried several alternatives, including Metabase, and ended up with extensive Redash use. We use the self-hosted version for sharing data between the tech and business sides, for day-to-day monitoring and for ad-hoc visualizations, and are generally very happy with it. It's not perfect - there are some areas, like fine-control over chart customization, query auto-updates (especially queries with…
Hello, it seems that there are no instructions on step-by-step installing redash in your own server. The only thing I could find was info on how to install it on AWS or using docker ( https://redash.io/help-onpremise/setup/setting-up-redash-ins... ). However I want to install it normally, using my server's nginx / postgresql / python / supervisorctl etc. Can it be done? Can you provide some step by step instructions…
Step by step instructions could be great, but there is that much time in the day, so figured that anyone who wants to customize the deployment, will know how do it on his own (or use the bootstrap script for reference).
I'll be happy to answer questions on how to set it up in your environment, you're welcome to the forum[1], Gitter[2] or Slack[3].
[1] https://discuss.redash.io [2] https://gitter.im/getredash/redash [3] https://slack.redash.io
Looks great! What about open-sourced Superset[1] from AirBnB? Both looks great, but Superset seems to have a superset of Redash features (bad pun intended). [1]: https://github.com/airbnb/superset
Metabase is another great open-source tool: http://www.metabase.com/
It makes creating BI charts from a database easy enough that a non-developer can do it. But when the going gets tough, I can still drop down to hand-coded SQL. It was also an easy installation on Heroku.
It's not entirely perfect (combining multiple series on one chart is harder than it needs to be; can only pull data from databases not APIs) but it's been a success so far
I tried Redash some time ago while I was looking for a very simple "BI" like tool that our non-technical or low-technical colleagues could use (people in Client Satisfaction team). I settled for Metabase ( http://www.metabase.com/ , https://github.com/metabase/metabase ), mainly for the ease of use and installation (a simple java -jar metabase.jar does the trick). Redash was a close second (one advantage at that time…
Having a single executable is definitely the best, and I wish we had one for Readsh... trying to compensate on this with the Docker and cloud (AWS / GCE) images for easy setup.