Compatibility with Apache Superset

[smola]

We're considering using Apache Superset to generate dashboards. Both for gitbase and gitbase-spark-connector. So we need to work on compatibility for it. If there is any major functionality that cannot be done in short-term, input on what it would take to support it will also be needed.

[mcuadros]

In a preliminary review I found this incompatibilities:

• Support for SHOW SCHEMAS as SHOW DATABASES alias (Add support for SHOW SCHEMAS go-mysql-server#652, sqlparser: support for SHOW SCHEMAS vitessio/vitess#4785)
• Missing DATE function (sql/expression: new date function go-mysql-server#654)
• Missing DAYOFMONTH function (sql/expression: new dayofmonth function (alias of day) go-mysql-server#671)
• Missing DATE_SUB and DATE_ADD functions (DATE_SUB and DATE_ADD functions go-mysql-server#663)
• Incompaitbile SHOW CREATE TABLE result with SQLAlchemy (plan: types in lowecase on SHOW CREATE TABLE go-mysql-server#656)
• using fqns in SHOW CREATE TABLE errors (https://github.com/src-d/gitbase/issues/787)
• Missing support for HAVING (https://github.com/src-d/go-mysql-server#689)

[erizocosmico]

• DATE_SUB and DATE_ADD DATE_SUB and DATE_ADD functions go-mysql-server#663

[mcuadros]

I just added support for HAVING, since some charts require this, without having a easy alternative on the GUI to generate other kind of query.

What about src-d/go-mysql-server#599? /cc @smola @ajnavarro

[ajnavarro]

@mcuadros src-d/go-mysql-server#599 needs more work to make rules work as expected in some cases.

[kuba--]

Let's split this kind of EMPIC into multiple small tasks. So far, it looks that everything is either done, blocked by 3rdparties or requires much more effort.

[mcuadros]

Well, this issue is still pending, not blocked.

What I wrote is my initial research but a more depth list should be perform after going through all the options of Superset, since this is going to be our default UI

[erizocosmico]

HAVING support at src-d/go-mysql-server#689

[ajnavarro]

Closing as completed; https://github.com/src-d/gitbase/releases/tag/v0.20.0-beta4 is compatible with superset.