6 ms·
Another great and innovative app thrown into the dust from an acquisition. They actually made working with SQL a joy.
by samdalton 10y ago
Another great and innovative app thrown into the dust from an acquisition. They actually made working with SQL a joy.
- papa_bear 10y agoYeah I'm pretty bummed about this. Are there any similar locally-run apps that make it easy to get graphs from your SQL queries? I've seen a few SaaS apps like Periscope that do similar, but I'm not a fan of letting other companies load up our entire database just to make some graphs.
- colinbartlett 10y agoI'm a big fan of Looker[1]. It's one of the best BI tools I've used and it lets you work with SQL but abstracts away much of the minutiae of writing it. It's an enterprise SaaS app, although they do allow you to self host. For side projects and such I use Metabase[2] which is open source and pretty useful for giving business users access to query data. Its visualizations are rudimentary but workable. 1. https://looker.com https://looker.com 2. https://github.com/metabase/metabase https://github.com/metabase/metabase
- proksoup 10y agoDBvisualizer ... A Java app but it does that job pretty okay.
- jesalg 10y agoI second Metabase recommendation. Like the fact that it's OSS.
- avdempsey 10y agoYou might check out Redash or Caravel. They're both open source, you host them yourself, and have a bunch of dashboard and access control functionality. Caravel in particular has some great exploration tools. You can build queries either by hand or by using visualization specific drag and drop. Caravel is getting regular updates from the AirBnB team too. If you want more power I recommend using a Jupyter notebook and Python. There's also Rodeo which is like R Studio for Python.
- ocdtrekkie 10y agoYup. Just submitted it to http://ourincrediblejourney.tumblr.com http://ourincrediblejourney.tumblr.com