clickhouse support | Directus | Page 1

thick vine Dec 22, 2022, 1:30 PM

#

ClickHouse

ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries

#

@midnight marsh created

#

for data display and analysis

#

displaying tables etc. would be great at first if it was simple.

#

I'm using it for postgresql, but in the same project I'm using it in this database. It would be great to be able to connect this to the same panel.

frosty iron Dec 22, 2022, 1:32 PM

#

clickhouse support

thick vine Dec 22, 2022, 1:33 PM

#

https://clickhouse.com/docs/en/integrations/language-clients/nodejs

midnight marsh Dec 22, 2022, 1:34 PM

#

Thanks for opening the post here 👍

thick vine Dec 22, 2022, 1:35 PM

#

It would be great if I could open a new region here and show these database tables and see the data.

midnight marsh Dec 22, 2022, 1:35 PM

#

I'm sorry but I've no experience with ClickHouse so far.
Do you want to use it as a datasource in Directus? Is it like a database itself?

thick vine Dec 22, 2022, 1:38 PM

#

for the first version it might be fetching the table names and creating the table.

#

It is entirely up to you how you proceed and what you add next. There is no structure where I can check the clickhouse data and see the tables.

#

I'm already using it like a directus admin panel, it would be great if I could also connect this database to the same place.

#

it would be weird to set up a new directus again for this. It would be nice for me to manage both postgresql database and clickhouse database in the same admin panel.

thick vine Dec 22, 2022, 1:41 PM

#

thick vine https://clickhouse.com/docs/en/integrations/language-clients/nodejs

Your plans may change according to the structure and codes here.

#clickhouse support