Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Ask HN: Tools to visualize data in SQL databases?

news.ycombinator.com

Post reply on HN
Print view View original

71–80 of 137 posts

Re: Ask HN: Tools to visualize data in SQL databases?

#71

Post by sdesol »

Since superset, metabase and redash was mentioned, I'll share some development insights regarding these OSS projects. Note, I've never used these solutions before, so I can't speak to their quality, but I can speak to how active and invested they appear to be.

Looking at recently merged pull requests that were less than 120 days old, apache/superset had 89 unique authors, which is very high, as the following shows:

https://oss.gitsense.com/insights/github?q=pull-age%3A%3C%3D...

Metabase had 37 authors, which is also quite high for an opensource project, which the following shows:

https://oss.gitsense.com/insights/github?q=pull-age%3A%3C%3D...

And redash has 11, but most of the contributions were more than 28 days ago, and is significantly less active than metabase and superset as the following shows:

https://oss.gitsense.com/insights/github?q=pull-age%3A%3C%3D...

I was actually quite surprised by superset, as I never heard of them before, but they are backed by serious investment (https://preset.io/about/), which clearly shows in how active their repository is.

Re: Ask HN: Tools to visualize data in SQL databases?

#73

Post by justindeguzman »

You should check out Arctype! (https://arctype.com)

We're trying to re-imagine popular SQL clients (phpMyAdmin, MySQL Workbench) to have the design and software quality of modern tools like Superhuman, Linear, etc. We make it very easy to query and create charts from your database then share it with your team.

We currently support MySQL, Postgres, PlanetScale, Yugabyte, and in the next couple of weeks SQLite and ClickHouse.

Re: Ask HN: Tools to visualize data in SQL databases?

#74

Post by Eikon »

justindeguzman wrote: post #73

You should check out Arctype! ( https://arctype.com ) We're trying to re-imagine popular SQL clients (phpMyAdmin, MySQL Workbench) to have the design and software quality of modern tools like Superhuman, Linear, etc. We make it very easy to query and create charts from your database then share it with your team. We currently support MySQL, Postgres, PlanetScale, Yugabyte, and in the next couple of weeks SQLite and Cl…

Looks like a non-native version of TablePlus, with a strange pricing structure.

Re: Ask HN: Tools to visualize data in SQL databases?

#75

Post by disgruntledphd2 »

reureu wrote: post #60
jslove wrote: post #14

Earlier quoted context omitted.

As you get deeper into it they hook you into the server and other stuff and it ends up costing 000s. Pandas is better but requires programming.

I second pandas, and would also highlight seaborn, plotly, and dash as complimentary data visualization libraries. Tableau is fine for what it is, but I've found that the requests from stakeholders often grow to a point where you either can't do it in Tableau or have to move mountains to get it to work... so, in essence, sunk cost fallacy makes tableau millions.

PSA: If you haven't already learned pandas, learn dplyr/ggplot2 instead. Yes, R is a pretty clunky language (but it's closer to lisp than pretty much anything else as popular) but ggplot2 and dplyr are 100% the best currently available way to visualise tables in SQL.

Re: Ask HN: Tools to visualize data in SQL databases?

#76

Post by FridgeSeal »

robertlagrant wrote: post #42
emilsedgh wrote: post #27

Metabase is what you're looking for. https://metabase.com/

That looks great, but AGPL makes everyone nervous.

You’re not building against their code, you’re just using the end product, why would AGPL matter here at all?

Re: Ask HN: Tools to visualize data in SQL databases?

#77

Post by StratusBen »

justindeguzman wrote: post #73

You should check out Arctype! ( https://arctype.com ) We're trying to re-imagine popular SQL clients (phpMyAdmin, MySQL Workbench) to have the design and software quality of modern tools like Superhuman, Linear, etc. We make it very easy to query and create charts from your database then share it with your team. We currently support MySQL, Postgres, PlanetScale, Yugabyte, and in the next couple of weeks SQLite and Cl…

+1 for Arctype - I'm a happy user :)

Re: Ask HN: Tools to visualize data in SQL databases?

#78

Post by emmelaich »

petilon wrote: post #30

Reverse question: What tool do you use to get data into the database? Google Forms is great, but if you want the data to go into your own database what tools are available?

Depending on the source, debezium might be useful.

Otherwise, there are many ETL solutions.

Re: Ask HN: Tools to visualize data in SQL databases?

#79

Post by justindeguzman »

Eikon wrote: post #74
justindeguzman wrote: post #73

You should check out Arctype! ( https://arctype.com ) We're trying to re-imagine popular SQL clients (phpMyAdmin, MySQL Workbench) to have the design and software quality of modern tools like Superhuman, Linear, etc. We make it very easy to query and create charts from your database then share it with your team. We currently support MySQL, Postgres, PlanetScale, Yugabyte, and in the next couple of weeks SQLite and Cl…

Looks like a non-native version of TablePlus, with a strange pricing structure.

We're huge fans of TablePlus but Arctype is free (all features) for most developers. We charge a low price for teams/startups above 10 users in a typical SaaS model. TablePlus is a great piece of software but it charges $79 for individuals (one year of updates) to unlock all features such as having multiple tabs. We're also focused a lot more on visualization and collaboration.
Post reply on HN