ClickHouse Integration Status

[vladismchard]

Hi, our team saw the source code for Clickhouse (https://github.com/umami-software/umami/tree/master/db/clickhouse), we are very interested in whether there will be integration, if so, when?
If a release is planned, will there be scripts for migration?
If it exists now, where can I find documentation on how to migrate from Clickhouse to PostgresSQL?

If you haven't thought about it, maybe create automatic migration scripts from Postgres to Clickhouse?

[romangg]

I would also be interested in that. I decided to setup an Umami instance for manjaro.org, which is a well known open-source Linux distribution.

We have many users and around 5 million page views per month on the forum alone. So Umami's postgres database is too packed and slow on queries after only 4 months (and the database size is ballooning with now 30GB).

If it exists now, where can I find documentation on how to migrate from Clickhouse to PostgresSQL?

You mean the other way around, right? From Postgres to CH.

[vladismchard]

Yes, i mean that!

[mikecao]

Yes, Clickhouse is supported, but we need to write the documentation for it. Will do it after the next open-source release. But be aware that you will need to do all migrations manually as it's not supported by Prisma. Also the setup still requires a Postgres database.