docs: document support for different postgres flavours

[shahidhk]

There are many flavors of postgresql which graphql-engine might support out of the box or with slight configuration/modifications. We need to document for each of them.

TimescaleDB
Yugabyte
Aurora - Postgres
CockroachDB
CitusDB
CrateDB
PipelineDB

Current status (note that these have not been officially tested by Hasura and are based on empirical usage):

• Timescale: Fully works
• Yugabyte: Fully works (officially supported)
• Aurora: Fully works
• Citus: Our permission system doesn't work
• Cockroach: Internals are quite different from postgres (see: Add support for CockroachDB #678 )

[duyleekun]

CockroachDB hasn't supported user defined schema

 {"internal":{"statement":"CREATE SCHEMA hdb_catalog","prepared":false,"error":{"exec_status":"FatalError","hint":"See: https://github.com/cockroachdb/cockroach/issues/26443","message":"unimplemented at or near \"hdb_catalog\"","status_code":"0A000","description":"source SQL:\nCREATE SCHEMA hdb_catalog\n              ^"},"arguments":[]},"path":"$","error":"postgres query error","code":"postgres-error"}

[Smerity]

I could imagine scenarios where as a start-up scales they might shift to CockroachDB from Postgres. From a read and most of a write point of view would it not remain compatible with GraphQL? How frequently are user defined schema changes required in standard Hasura + Postgres operation?

The other feature that would disappear is the live subscription capability but that is an optional extra and Hasura has strong value even without it.

[shahidhk]

Thanks for reporting this @duyleekun.

@Smerity Hasura stores all the metadata on a separate schema called hdb_catalog.

Looks like this is a planned feature on CockroachDB. Should land soon.

See cockroachdb/cockroach#26443 and cockroachdb/cockroach#30916

[Disturbing]

Hey Guys - is it possible to do the creation of the hdb_catalog as a create db versus create schema to support cockroach?

[shahidhk]

@Disturbing It will be a big change to the internals. Not something we can immediately support.

[Disturbing]

Ok, thanks for the quick response. Out of curiosity, is there a specific reason why you guys when with SCHEMA

Table? I personally dont have much knowledge over this, but would love to

hear your perspective

…

On Wed, Mar 27, 2019 at 5:26 PM Shahidh K Muhammed ***@***.***> wrote: @Disturbing <https://github.com/Disturbing> It will be a big change to the internals. Not something we can immediately support. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#411 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ACQev7cNuU1qDdvSEfOhe8VesUH95rQxks5vazlRgaJpZM4WjIgY> .

[shahidhk]

@Disturbing When Hasura connects to a Postgres instance, the connection is database scoped. It cannot access another database outside of the given one. Hence the logical choice would be to use the namespacing available within a database which is a schema.

[Disturbing]

Thanks - makes sense.

[adamfeldman]

Hasura is now supported by YugaByte (Postgres-based distributed SQL DB):

https://docs.yugabyte.com/latest/develop/graphql/hasura

(I haven't personally tested this yet)

[adamfeldman]

Looks like this is a planned feature on CockroachDB. Should land soon.

See cockroachdb/cockroach#26443 and cockroachdb/cockroach#30916

FYI for others who are waiting for this: CockroachDB might implement user-defined schemas sometime in 2020: cockroachdb/cockroach#30916 (comment)

[zicklag]

Do all features of Hasura work on Yugabyte? What about this issue: yugabyte/yugabyte-db#1872?

[gagandeep]

CockroachDB user-defined schemas RFC got merged in May. cockroachdb/cockroach#30916

Should Hasura works on CockroachDB now?

[c-nv-s]

is it possible to reopen the ticket for adding support for cockroachdb considering thier project manager and dev stated they are seeking to make it compatible? or is there some other serious blocker to making it work?

[marionschleifer]

We document Postgres + compatible databases here.