ClickHouse support

[peturrun]

We at Activity Stream would like to contribute support for ClickHouse to Flyway.

There are some limitations - because ClickHouse doesn't support UPDATE or DELETE, repair functionality is not available.

This depends on changes to the clickhouse-jdbc driver that have been committed to the github repository, but are not yet part of a release.

[filimonov]

any plans to merge #1773 ?

[axelfontaine]

@filimonov The biggest impediment is this: https://db-engines.com/en/ranking

Maintaining ClickHouse support unfortunately currently has a very low power to weight ratio.

[filimonov]

Ok, sounds reasonable (of course I could say that CockroachDB is also not on the top of the list, but it can have some other reasons to add support).

And what about 'community-supported' extra DB engines? For example by plugins? That would allow to use flyway more widely, and after certain community-driven part will become popular / mature / stable you can merge it to the core. That will allow to use flyway in the environments which are not currently covered by flybase core, so flybase will be used wider, so for you it's also win-situation.

[filimonov]

That can also unblock a lot of other pull requests, which are waiting while corresponding DBMS will became enough popular to get some support from flyway :)

#1857 #1655 #1495 #1386 #1322 #773

[axelfontaine]

@filimonov No immediate plans for this. See #1608 (comment)

That is not to say neither of these DBs can ever be supported. It simply means that until they become much more popular a commercial agreement is needed to make it worth it for us. We would be more than happy to talk to your company or Yandex if this is an option for you in order to get ClickHouse support in sooner.

[tburch]

+1 for ClickHouse support! Also, if it can't be added to the roadmap without a commercial agreement, then it seems like it'd be nice to have "community-supported" extensions like @filimonov mentioned. I the meantime, I guess I'll try to add support to Liquibase...

[filimonov]

@tburch i've finished with that: https://github.com/filimonov/ClickHouse/wiki/Clickhouse-database-schema-migrations

Liquibase extension is also doesn't see like something very sophisticated (especially if not implement all automatic DDL generation logic).

[tburch]

Thanks @filimonov! I'll take a look. I was hoping for something that I could use in spring-boot, but maybe I can adapt this.

[jondeandres]

Any update on this?

[eugene-bright]

The latest related pull request #2981. Unfortunately it stuck

[filimonov]

@axelfontaine are there chances to merge a PR with clickhouse support in 2021/2022?

[anjanroy86]

Hi,
Is the support for clickhouse available now?

[waifairer]

Any chance of clickhouse support please?

[tianzhou]

Shameless plug, I am the author of Bytebase and it does support ClickHouse. We already have data teams using the GitOps feature branch workflow to apply schema change to ClickHouse in production. The steps are summarized here.

[sazonov]

I made a PR for this #3611. If someone knows who is an active maintainer, please tag. Really want to speed it up a bit.

[demidov163]

I made a PR for this #3611. If someone knows who is an active maintainer, please tag. Really want to speed it up a bit.

We also need this functional, Kindly ask support team pay attention to this PR.

[jianchengwang]

Is the support for clickhouse available now?

[Barry-RG]

Clickhouse support is now available.