News for hackers. Stuff that matters.
Re:PopSQL – Modern, collaborative SQL editor for your team by ghh on Monday October 02, 2017 @07:27AM (#15383046)
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

[2] http://www.metabase.com [3] https://news.ycombinator.com/item?id=10425959

[4] https://redash.io

Re:PopSQL – Modern, collaborative SQL editor for your team by arikfr on Monday October 02, 2017 @09:20AM (#15383564)
Redash 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.

Re:PopSQL – Modern, collaborative SQL editor for your team by fredmonroe on Monday October 02, 2017 @12:44PM (#15385405)
is 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
Re:PopSQL – Modern, collaborative SQL editor for your team by arikfr on Monday October 02, 2017 @05:26PM (#15388096)
It is :-)
Re:PopSQL – Modern, collaborative SQL editor for your team by rodionos on Monday October 02, 2017 @04:09PM (#15387480)
Redash is more that just a SQL editor. It's a full-featured dashboarding system which works particularly well with relational data sources.
Re:PopSQL – Modern, collaborative SQL editor for your team by petepete on Monday October 02, 2017 @08:51AM (#15383382)
I'd add Blazer to your list too. Used it with great success and it meets your 4 criteria.

https://github.com/ankane/blazer

Re:PopSQL – Modern, collaborative SQL editor for your team by j_s on Monday October 02, 2017 @08:54AM (#15383399)
Thanks 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 (Sep 2017, 63 comments)

https://github.com/hvf/franchise

Also mentioned there:

https://github.com/apache/incubator-superset

Re:PopSQL – Modern, collaborative SQL editor for your team by thenaturalist on Monday October 02, 2017 @04:11PM (#15387493)
In 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-intelligen...
Re:PopSQL – Modern, collaborative SQL editor for your team by huy on Monday October 02, 2017 @08:11AM (#15383217)
To add on to your list:

https://www.holistics.io (I work here).

Re:PopSQL – Modern, collaborative SQL editor for your team by LogicX on Monday October 02, 2017 @08:32AM (#15383300)
We 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.
Re:PopSQL – Modern, collaborative SQL editor for your team by amigoingtodie on Monday October 02, 2017 @08:02PM (#15388982)
Can you go into more detail on this?
Re:PopSQL – Modern, collaborative SQL editor for your team by pmx on Monday October 02, 2017 @07:56AM (#15383151)
As far as I know there is no way to use or download Wagon now that Box has acquired them
Re:PopSQL – Modern, collaborative SQL editor for your team by netcraft on Monday October 02, 2017 @09:06AM (#15383465)
This is true an also what gives me pause before trying any more tools like this.
Re:PopSQL – Modern, collaborative SQL editor for your team by infinite8s on Monday October 02, 2017 @03:05PM (#15386870)
Would 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.
Re:PopSQL – Modern, collaborative SQL editor for your team by pmx on Thursday October 05, 2017 @05:00AM (#15407648)
I 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.
Re:PopSQL – Modern, collaborative SQL editor for your team by mrmondo on Monday October 02, 2017 @07:34AM (#15383069)
Metabase it’s pretty nice, although it’s a bit slow and resource intensive.
Re:PopSQL – Modern, collaborative SQL editor for your team by nrjames on Monday October 02, 2017 @11:47AM (#15384725)
It 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-para...