@ovr I would like to work on this issue. I see that Cockroach DB fully supports the Postgres JDBC driver(https://www.cockroachlabs.com/docs/stable/install-client-drivers.html#java). So planning to add JDBC config for the same. Do let me know your thoughts. Thanks!

Hello Ronan D'Souza,

The JDBC driver is outdated and ignored on our CI because it's working on Node.js <= 8. It requires migration from one JDBC vendor to another because the current one is outdated and not supported.

1. https://github.com/CraZySacX/node-jdbc (current one)
2. https://github.com/naxmefy/node-jdbc (probably it's better module with active support)

So planning to add JDBC config for the same.

It's not the only thing that should be done to support CockroachDB. Each driver requires a dialect for SQL.

Implementing a "native" driver is a more useful and stable solution that we should choose.

Thanks for your feedback, Dmitry.

Since cockroachDB supports Postgres clients, I tried connecting to a cockroachDB using the Postgres driver in cube.js. I found that it partly works. For some reason, this query returns an SQL syntax error select 1 id, 100 amount, 'new' status; in cockroachDB and so have opened an issue in the cockroachDB repository cockroachdb/cockroach#55826.

Will also try exploring the native driver route.

Driver contains SQL dialect. It's a bad idea to use PostgreSQL Dialect with CockroachDB.

Take a look at
https://github.com/cube-js/cube.js/blob/v0.22.1/packages/cubejs-schema-compiler/adapter/PostgresQuery.js
https://github.com/cube-js/cube.js/blob/v0.22.1/packages/cubejs-schema-compiler/adapter/BaseQuery.js