Redash(https://redash.io/) is pretty easy to use and get up and started with, especially if you know SQL. It's free and open source.
Ask HN: Tools to visualize data in SQL databases?
11–20 of 137 posts
Re: Ask HN: Tools to visualize data in SQL databases?
#12Maybe not exactly what you are looking for but Datasette is brilliant for SQLite (and csv) https://datasette.io/
It doesn't speak MariaDB (yet - I have a long-term goal to investigate adding alternative database backends as plugins) but you can instead use the https://datasette.io/tools/db-to-sqlite CLI tool to convert a PostgreSQL or MySQL (or other SQL Alchemy supported) database to SQLite, then use Datasette against the resulting file.
This actually works pretty well for small (Then you can visualize with plugins such as https://datasette.io/plugins/datasette-cluster-map or https://datasette.io/plugins/datasette-vega
I also often load data into Datasette and then do custom visualizations in Observable Notebooks by fetching data back out through the Datasette JSON API - here's an example notebook that does that, using the Observable Plot charting library: https://observablehq.com/@simonw/datasette-downloads-per-day...
Re: Ask HN: Tools to visualize data in SQL databases?
#13This may be an unpopular opinion, but if you have US$70/mo to spare, it's hard to beat Tableau for this exact use case. "Connect to an arbitrary database, create a view that joins numerous tables (including foreign tables, via blending) together, load to columnar storage on a local SSD for performance if necessary, add arbitrary derived columns (including well-defined lateral lookups for things like 'annotate this ac…
>This may be an unpopular opinion, but if you have US$70/mo to spare, it's hard to beat Tableau for this exact use case.
This is a popular opinion, in my book.
Re: Ask HN: Tools to visualize data in SQL databases?
#14This may be an unpopular opinion, but if you have US$70/mo to spare, it's hard to beat Tableau for this exact use case. "Connect to an arbitrary database, create a view that joins numerous tables (including foreign tables, via blending) together, load to columnar storage on a local SSD for performance if necessary, add arbitrary derived columns (including well-defined lateral lookups for things like 'annotate this ac…
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.
Re: Ask HN: Tools to visualize data in SQL databases?
#15wizardmac.com
The most effective, efficient data exploration tool I've ever used. I'm a data scientist, but I use this before I write so much as a line of code.
Re: Ask HN: Tools to visualize data in SQL databases?
#16Grafana
Re: Ask HN: Tools to visualize data in SQL databases?
#17It's not what you mean, but I noticed yesterday that Kaggle does what you're asking on datasets.
See https://www.kaggle.com/rhuebner/human-resources-data-set. I think it's a great view on top of a datatable.
Re: Ask HN: Tools to visualize data in SQL databases?
#18Maybe not exactly what you are looking for but https://whaly.io can do the trick !
Re: Ask HN: Tools to visualize data in SQL databases?
#19No plots and statistics (well, maybe, but I've not used them if there are there). But DBeaver is nice to browse a database.
For SQLite databases, I use sqlitebrowser.
Both tools are open source.
Re: Ask HN: Tools to visualize data in SQL databases?
#20Redash( https://redash.io/ ) is pretty easy to use and get up and started with, especially if you know SQL. It's free and open source.
https://www.metabase.com/ free and open source.