Graphql-engine: Add support for CockroachDB

[orefalo]

Or any distributed/replicated SQL db alike...

[stanxii]

It is really cool!

[karibertils]

would be interesting

[vroad]

CockroachDB doesn't support triggers at this moment.
Could Hasura implement event triggers without built-in DB support?

Even if that's possible, events won't be fired if you modify the DB directly.

https://github.com/cockroachdb/cockroach/issues/28296

[vroad]

Latest version of CockroachDB now offers support for experiential change feed.
https://www.cockroachlabs.com/docs/v19.1/changefeed-for.html

Could this be used instead of SQL triggers?
I'm not sure if current Hasura implementation assume that trigger is always available regardless of the database you use, though.

[hiralsp]

Is the only thing that's broken is webhooks for db change events? Does everything else work with CockroachDB ?

[marionschleifer]

Hi everyone 👋 this is to let you know that we are aware of the community's request for support for CockroachDB. We will take this up in a few weeks 🙂

[hiralsp]

Any update here?

[gnanakeethan]

any updates here?

[tirumaraiselvan]

Hey everyone, so we did an initial investigation and Hasura doesn't start on CockroachDB out-of-the-box because of Cockroach's different implementation of internal schema and lack of few json operators.

Although now we have more insights into what will go into supporting CockroachDB and we will update this issue when we have a technical spec ready.

[guru2228]

any updates on this

[hiralsp]

please update, thank you!

[nvcnvn]

@tirumaraiselvan sorry for the noise.
Do you have a draft technical spec somewhere already? Me and my team are willing to work on this (ofc with guidance, none of us know Haskell).

[madasebrof]

Plus one for support for CockroachDB! 😄

[nmabhinandan]

Any updates?

[fritzblue]

Or any distributed/replicated SQL db alike...

@orefalo Hasura does support YugabyteDB, which is a distributed SQL database with a Postgres-compliant API.

Here is a tutorial on using Hasura and YugabyteDB together.

Yugabyte has a hosted cloud offering that starts with 5GB of storage and 3 nodes on the free tier.

[ChristianHohlfeld]

Hi everyone 👋 this is to let you know that we are aware of the community's request for support for CockroachDB. We will take this up in a few weeks 🙂

any updates on this? Thank's!

[Bessonov]

I use CockroachDB at work and YugaByte for a personal project. Both are great until now, but also different. With YB you get better compatibility to Postgres and with CRDB you get a very easy management, scaling and stability (more mature than YB, bug not mature as PG).

In general, I prefer tools which I can use in both projects and it would be nice if hasura supports CRDB too. So, the question is, what prohibits usage of CRDB? It's the syntax or missing features like triggers?

As a workaround I can imagine to use custom resolvers to fetch/update CRDB for example with knex or some ORM. Is this the way to go until CRDB is supported?

CockroachDB doesn't support triggers at this moment.
Could Hasura implement event triggers without built-in DB support?

Even if that's possible, events won't be fired if you modify the DB directly.

I'm not hasura user yet, but I would like to ask which events are important here? Can it work for migrations?

[tonyabracadabra]

Would Hasura support any PostgreSQL compatible databases like TiDB or PolarDB?

[alexandrim0]

Vote for CockroachDB!
Thank you!