4 ms·
Other solutions in the `write sql and share the graphs with your team`-space: - ChartIO - 'WagonHQ, Modern SQL Editor' [1] (now aquired by Box) - MetaBase [2
by ghh 9y ago
Other solutions in the `write sql and share the graphs with your team`-space:
- ChartIO
- 'WagonHQ, Modern SQL Editor' [1] (now aquired by Box)
- MetaBase [2,3]
- Redash [4]
MetaBase is the only one that I know of that is
- fully open source,
- mature (graphing options, permission model),
- still actively maintained, and
- both friendly to non-technical users and expert sql'ers alike
[1] https://news.ycombinator.com/item?id=9792464 https://news.ycombinator.com/item?id=9792464
[2] http://www.metabase.com http://www.metabase.com
[3] https://news.ycombinator.com/item?id=10425959 https://news.ycombinator.com/item?id=10425959
[4] https://redash.io https://redash.io
- mrmondo 9y agoMetabase it’s pretty nice, although it’s a bit slow and resource intensive.
- nrjames 9y agoIt also seems to have some serious bugs. For example, none of their SQL Parameters examples[1] work with a Postgres connection. I just downloaded it this morning to give it a try after reading this topic. [1]http://www.metabase.com/docs/v0.21.1/users-guide/12-sql-parameters.html http://www.metabase.com/docs/v0.21.1/users-guide/12-sql-para...
- pmx 9y agoAs far as I know there is no way to use or download Wagon now that Box has acquired them
- netcraft 9y agoThis is true an also what gives me pause before trying any more tools like this.
- infinite8s 9y agoWould people pay for a desktop tool like this? How important is sharing? I had built something a year ago (on top of PyQt) but shelved it for lack of interest.
- pmx 9y agoI might if it wasn't tied to a cloud service. Sharing not that important for me unless it can be done without the need for getting a 3rd party involved.
- huy 9y agoTo add on to your list: https://www.holistics.io https://www.holistics.io (I work here).
- LogicX 9y agoWe use and like redash, because we can have it trigger zapier tasks when there are new results on a query. Makes cross-integration when testing new things great, and saves time in development being able to hack together a stop-gap solution this way.
- amigoingtodie 9y agoCan you go into more detail on this?
- petepete 9y agoI'd add Blazer to your list too. Used it with great success and it meets your 4 criteria. https://github.com/ankane/blazer https://github.com/ankane/blazer
- j_s 9y agoThanks for the links! Here's a recent related discussion of another product: Franchise – An Open-Source SQL Notebook | https://news.ycombinator.com/item?id=15303833 https://news.ycombinator.com/item?id=15303833 (Sep 2017, 63 comments) https://github.com/hvf/franchise https://github.com/hvf/franchise Also mentioned there: https://github.com/apache/incubator-superset https://github.com/apache/incubator-superset
- arikfr 9y agoRedash creator here. Just to make sure someone doesn't get the wrong impressions from your comment: Redash is 99% open source (and I'm going to close this gap this month[1]), mature and actively maintained. The friendliness is subjective, but we're not trying to please everyone :-) [1] Sometimes it's easier to prototype new things in the SaaS version, but everything reaches open source eventually. There is practically one feature that wasn't open sourced until now, and I'm going to add it to the open source version now.
- fredmonroe 9y agois the feature joining multiple data sources? i'm a fan of redash btw, people should check it out. i use it as a docker container for self hosting
- arikfr 9y agoIt is :-)
- rodionos 9y agoRedash is more that just a SQL editor. It's a full-featured dashboarding system which works particularly well with relational data sources.
- thenaturalist 9y agoIn case you're interested in more tools in that area, I'm actively maintaining & updating a list of BI related tools: https://github.com/thenaturalist/awesome-business-intelligence https://github.com/thenaturalist/awesome-business-intelligen...