Connecting CrateDB through Postgrest or Hasura Graphql

Hi,

Is there a possibility of integrating CrateDB with either PostgRest or Hasura Graphql.

Any hints or documents can be helpful.

I am new to cratedb … I just understood architecture of Cratedb.

Some insights on connecting CrateDb through PostgRest or Hasura Graphql will be helpful.

Thank you.

Hi,

I don’t think we have official support or guides for those engines/APIs yet. But we happy if you could share your experiences.

Generally CrateDB exposes a Postgres compatible Interface on the postgres Port 5432. So you can connect to CrateDB pretty similiar as to a native Postgres database. If your are running CrateDB on your local machine you may use the user crate without password. If you are using a cloud instance, be sure to activate TLS/SSL in the API/engine and use your credentials to login.

Also CrateDB has an http-endpoint cratehost:4200/_sql that can be used to send SQL requests directly via http(s).