Live data from Hacker News

Redash – Connect to any data source, easily visualize and share your data

github.com

41–50 of 98 posts

Re: Redash – Connect to any data source, easily visualize and share your data

#41
For those of you looking for a another fully hosted solution, check out https://www.cluvio.com (full disclosure: I am one of the founders).

Like redash, Cluvio allows you to run SQL queries against your database and quickly visualize results as beautiful, interactive dashboards, which can easily be shared within your company or externally.

We developed our own custom grammar on top of SQL which makes writing time-range related queries a lot easier and allows to parametrize queries, which powers the dashboard interactivity.

We also allow to run custom R script on top of the SQL results, have SQL Alerts that run at specified schedules, allow you to create SQL Snippets and offer a free entry plan.

Currently supported datasources are Postgres, Redshift, MySQL, MariaDB and Amazon Aurora.

Re: Redash – Connect to any data source, easily visualize and share your data

#42
We have been using Redash at our company for almost a year now. Every single release just proves how promising the project is. You can make useful dashboards in minutes. Support for multiple databases is amazing. We are using it with multiple PostgreSQLs, Redshift, MongoDB and InfluxDB.

The most valuable feature is alerts though. I work at an ecommerce and operations heavy company where we have tons of connected components. Where alerts come really handy for us is that anyone in the organization can add quick alerts for proactive monitoring of events recorded in on-field ops and act when things go bad. This almost like building a feature on one of the internal tools, just doing that yourself without any engineering support. This comes in really handy.

Kudos to the team! Looking forward to some more amazing stuff in Redash!

Re: Redash – Connect to any data source, easily visualize and share your data

#43
post #14

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.

Hi Arik,

Quick question: to what decimal accuracy are the visualizations capable of displaying, and are second/sub-second time series possible in the dashboards? The issue our team has been having with other platforms such as Quicksight is the lack of support for extremely granular data visualization. Thanks in advance!

Re: Redash – Connect to any data source, easily visualize and share your data

#44
post #14

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.

Well done!

Re: Redash – Connect to any data source, easily visualize and share your data

#45
post #6

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

I've tried Superset but halted because there is a bug with PostgreSQL ( https://github.com/airbnb/superset/issues/1900 ). I'll be trying Redash to see what's going on. In the mean time, there is a Django project where I've integrated the sql-explorer ( https://github.com/groveco/django-sql-explorer ) and it was well appreciated. Especially the API endpoint.

Re: Redash – Connect to any data source, easily visualize and share your data

#47
post #34

Earlier quoted context omitted.

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…

The "::filter" convention is filters. We also have parameters (for some time now, although only in v0.11 added UI for them). With parameters you can do: 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/…

That's great news about parameters, I don't think I used a version with those included. Thanks again for building a quality tool!

Re: Redash – Connect to any data source, easily visualize and share your data

#48
I really like Redash, it’s one of the early tools that introduce this concept of turn SQL into chart to developers, and also teach developers to learn and write better SQL, altogether without any cost. I evaluated Redash during my past company back in 2013 (we were also using Tableau), but due to some Redash’s lack of features (no support for filters, lack of permission control, sporadic performance), we went and build something inhouse with similar approach (turn SQL into charts).

And inspired by the same path Redash founder took, that internal project turned into a startup by itself.

We’re relatively new but getting good momentum. Some of our customers went with us after evaluating both. While we don’t have a self-hosted open-source version, our pricing only starts at 49$/mo for up to 5 users (pretty affordable for startups IMHO).

You can check it out here: https://www.holistics.io

Re: Redash – Connect to any data source, easily visualize and share your data

#49
post #14

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.

Hi Arik, Quick question: to what decimal accuracy are the visualizations capable of displaying, and are second/sub-second time series possible in the dashboards? The issue our team has been having with other platforms such as Quicksight is the lack of support for extremely granular data visualization. Thanks in advance!

In the tables we show only 2 digits after the dot, but that's easy to change (in code; and later on will be configurable). Never tried to plot sub-second time series, so don't know what will happen - but unlike most platforms, you can modify Redash to support this :)

It's true that it's extra work, but it's a one time investment which you can reuse for all your visualization needs later on.

Post reply on HN