4 ms·

I was surprised to see that ClickHouse and ElasticSearch have the same number of contributors. That's pretty astounding given how much older and more prominent

I was surprised to see that ClickHouse and ElasticSearch have the same number of contributors. That's pretty astounding given how much older and more prominent ElasticSearch has been. https://github.com/ClickHouse/ClickHouse/graphs/contributors https://github.com/ClickHouse/ClickHouse/graphs/contributors https://github.com/elastic/elasticsearch/graphs/contributors https://github.com/elastic/elasticsearch/graphs/contributors Edit: I was very off. The Github contributor graph does not show all actual contributors. ElasticSearch has somewhere around 2-3 times as many contributors as ClickHouse.

rohitnair 5y ago
As per the landing pages of the projects, ES has 1.6k contributors whereas ClickHouse has 803. The contributors page likely only lists the top contributors to keep the page load time manageable.
- eatonphil 5y ago
  That makes much more sense. Thanks for pointing that out.
LoriP 5y ago
ClickHouse has gained a huge following and honestly that's been pretty well earned. For the kinds of apps that they target it's a great choice, it's great technology with a very able team behind it.
AdamProut 5y ago
Clickhouse is by far the leading open source columnar SQL data warehouse at this point. We have had strong open source operational SQL DBs for many years (MySQL, Postgres), but no open source systems that mirrored closed source MPP columnstore until clickhouse. Its interesting that it took "this long" for a strong open source SQL DW to emerge.
hodgesrm 5y ago
ClickHouse now has more unique contributors with merged PRs on an annual basis. The lines crossed early this year, or even late last year.
- eatonphil 5y ago
  Thanks! Could you point me at something concrete. :)
  - hodgesrm 5y ago
    Go to one of the several public ClickHouse endpoints and run this query: -- Elastic vs CH in a single table. SELECT toYear(created_at) Year, uniqIf(creator_user_login, repo_name in ('elastic/elasticsearch')) "Elastic", uniqIf(creator_user_login, repo_name in ('yandex/ClickHouse', 'ClickHouse/ClickHouse')) "CLickHouse" FROM github_events WHERE event_type = 'PullRequestEvent' AND merged = 1 AND repo_name in ('yandex/ClickHouse', 'ClickHouse/ClickHouse', 'elastic/elasticsearch') GROUP BY Year ORDER BY Year You can access the ClickHouse web UI for this dataset here: https://github.demo.trial.altinity.cloud:8443/play?user=demo https://github.demo.trial.altinity.cloud:8443/play?user=demo. The password is "demo" (type it in the left side.) This is the Altinity.Cloud copy of Alexey Milovidov's excellent github_events dataset. When I run this query I get the following numbers. Year|Elastic|CLickHouse| ----|-------|----------| 2015| 191| 0| 2016| 299| 40| 2017| 296| 85| 2018| 284| 142| 2019| 341| 232| 2020| 339| 300| 2021| 243| 294| Just speculation on my part but the drop Elastic contributors may be a side effect of the licensing change.

rohitnair 5y ago

As per the landing pages of the projects, ES has 1.6k contributors whereas ClickHouse has 803. The contributors page likely only lists the top contributors to keep the page load time manageable.

eatonphil 5y ago
That makes much more sense. Thanks for pointing that out.

LoriP 5y ago

ClickHouse has gained a huge following and honestly that's been pretty well earned. For the kinds of apps that they target it's a great choice, it's great technology with a very able team behind it.

AdamProut 5y ago

Clickhouse is by far the leading open source columnar SQL data warehouse at this point. We have had strong open source operational SQL DBs for many years (MySQL, Postgres), but no open source systems that mirrored closed source MPP columnstore until clickhouse. Its interesting that it took "this long" for a strong open source SQL DW to emerge.

hodgesrm 5y ago

ClickHouse now has more unique contributors with merged PRs on an annual basis. The lines crossed early this year, or even late last year.

eatonphil 5y ago
Thanks! Could you point me at something concrete. :)
- hodgesrm 5y ago
  Go to one of the several public ClickHouse endpoints and run this query: -- Elastic vs CH in a single table. SELECT toYear(created_at) Year, uniqIf(creator_user_login, repo_name in ('elastic/elasticsearch')) "Elastic", uniqIf(creator_user_login, repo_name in ('yandex/ClickHouse', 'ClickHouse/ClickHouse')) "CLickHouse" FROM github_events WHERE event_type = 'PullRequestEvent' AND merged = 1 AND repo_name in ('yandex/ClickHouse', 'ClickHouse/ClickHouse', 'elastic/elasticsearch') GROUP BY Year ORDER BY Year You can access the ClickHouse web UI for this dataset here: https://github.demo.trial.altinity.cloud:8443/play?user=demo https://github.demo.trial.altinity.cloud:8443/play?user=demo. The password is "demo" (type it in the left side.) This is the Altinity.Cloud copy of Alexey Milovidov's excellent github_events dataset. When I run this query I get the following numbers. Year|Elastic|CLickHouse| ----|-------|----------| 2015| 191| 0| 2016| 299| 40| 2017| 296| 85| 2018| 284| 142| 2019| 341| 232| 2020| 339| 300| 2021| 243| 294| Just speculation on my part but the drop Elastic contributors may be a side effect of the licensing change.