91–100 of 137 posts
I recently started using Arctype ( https://arctype.com/ ) and have really enjoyed the experience so far. Relatively new tool, but the team is awesome. It's a SQL client that has some basic data visualization features seemingly geared towards engineers
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…
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. "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…
What's the closest Tableau alternative that's OSS? PowerBI? Apache Superset? https://superset.apache.org
On the other hand, Redash has served my startup really well for the first 3 years (and now we're finally moving to Tableau)
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.
Earlier quoted context omitted.
What's the closest Tableau alternative that's OSS? PowerBI? Apache Superset? https://superset.apache.org
In spirit, but with no UI, vega js, they follow the same “grammar of graphics” idea from the same research. Altair does vega charting but in Python. Kibana is using vega in more UI fashion but I haven’t tested it. I think someone should put a proper web ui on top of vega…
I have used Vega + Jupyter a few times. As well as the Vega Viewer extension for VS Code. I haven't used it enough to be proficient and fast, but I have used it enough to know that I want to be.
Earlier quoted context omitted.
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.
I've tried google data studio, superset, but what I need is a integrated control where user's can filter the report based on their location. Or alternatively which would make it easiest for me to develop this control myself.
How has no one mentioned Sequel Pro and its successor Sequel Ace? It’s a classic, free native Mac app. https://github.com/Sequel-Ace/Sequel-Ace
I tried most of the free tools but I don't like any of them. In my experience they're all clunky and don't have a beautiful design (I'm on Windows at work and Linux at home). I just settled on DBeaver, but don't consider that an endorsement from my part. I found DB Browser for SQLite to be the least bad, but it's obviously limited to SQLite. My problem may come from the fact I have simple needs and they're all very c…
It's simple and open source