search

hasura / graphql-engine

Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
https://hasura.io
Apache License 2.0
31.1k stars 2.77k forks source link

Question: Is it possible to use Hasura with Clikhouse #7189

Closed sergii4 closed 4 months ago

sergii4 commented 3 years ago

Clickhouse emulate MySql protocol but not MySql database, so when I tried to point Hasura to Clickhouse I get a DB Exception such as missing INFORMATION_SCHEMA.

Are there any workarounds from Hasura side for it?

michael-land commented 2 years ago

I'm getting the same error. It would be great if hasura can support Clickhouse

maxpain commented 2 years ago

Any updates?

iosifnicolae2 commented 2 years ago

I'm also interested.

L-U-C-K-Y commented 2 years ago

Would also be interested!

iosifnicolae2 commented 2 years ago

We've managed to implement a solution using clickhouse_fdw (also, we've fixed some bugs with json support here: https://github.com/iosifnicolae2/clickhouse_fdw)

sina68 commented 1 year ago

ClickHouse and PostgreSQL - a Match Made in Data Heaven https://clickhouse.com/blog/migrating-data-between-clickhouse-postgres

marionschleifer commented 1 year ago

Hey folks, we're launching our new Clickhouse connector in our monthly community call on 31st of August at 9am PT. Would love to see you there! 🎉 you can sign up here. If you can't make it, no problem. You can sign up anyway and we'll send you the recording.

maxpain commented 1 year ago

@marionschleifer wow! Will it be available in the free version of Hasura?

marionschleifer commented 1 year ago

@maxpain yes it will be 🙂

manasag commented 5 months ago

Hi, I want to update that we are launching Hasura V3 (DDN) this month. in V3, Clickhouse will be available for Free tier and Community version.

I would highly suggest to join us to see the full power of Hasura DDN at the Hasura Dev Day on April 16 🎉. Sign up here: https://hasura.io/dev-day. Can't make it? Sign up anyway and we'll send you the recording.

manasag commented 4 months ago

Clickhouse is now available on V3. https://hasura.io/docs/3.0/connectors/clickhouse/ This is available in the Cloud Free tier and also in OSS (more update by next week on how to work with V3 OSS). Closing this issue for now.