4 ms·

God clickhouse is such great software, if it only it was as ergonomic as duckdb, and management wasn't doing some questionable things (deleting references to co

God clickhouse is such great software, if it only it was as ergonomic as duckdb, and management wasn't doing some questionable things (deleting references to competitors in GH issues, weird legal letters, etc.) The CH contributors are really stellar, from multiple companies (Altinity, Tinybird, Cloudflare, ClickHouse)

simonw 1y ago
They have an interesting version that's packaged a bit like DuckDB - you can even "pip install" it: https://github.com/chdb-io/chdb https://github.com/chdb-io/chdb
- AYBABTME 1y ago
  They don't do static builds AFAICT, which would make it a real competitor to DuckDB.
  - auxten 1y ago
    chDB author here, You are right, we have not made a static libchDB. BTW, I guess you are a golang developer?
    - AYBABTME 1y ago
      Correct! Would love to have the Go package come as a single dependency without having to distribute `.so` files. That's what's stopping me from using `chDB` now instead of DuckDB. Being able to use chDB in a static manner would also help deepen my usage of the Clickhouse server. Right now the Clickhouse side of my project is lagging behind the DuckDB one because of this.
      - ryadh 1y ago
        That's great feedback, thank you! I just added your comment to the GH issue: https://github.com/chdb-io/chdb/issues/101#issuecomment-2824107674 https://github.com/chdb-io/chdb/issues/101#issuecomment-2824... Ps. I work for ClickHouse
- codedokode 1y ago
  What is the use case for an embedded terabyte-scale database, by the way?
skeptrune 1y ago
Tbh, I'm not too worried about CH management. Let them mod the GH if they want to, it's their company. Contribution is strong and varied enough that I think we're good for the long term.
memset 1y ago
chdb and clickhouse-local is nearly as ergonomic as duckdb with all of the features of ch. duckdb has unfortunately been leaning away from pure oss - the ui they released is entirely hosted on motherduck’s servers (which, while an awesome project, makes me feel like the project will be cannibalized by a proprietary extensions.)
- apwell23 1y ago
  > the ui they released is entirely hosted on motherduck’s servers who is they in this sentence ? afaik UI was released by motherduck a private company.
- rastignack 1y ago
  ClickHouse too. Their sharedmergetree is not open source at all. It makes ClickHouse OSS obsolete design-wise. Shame.
  - olavgg 1y ago
    Actually this is not important. Because they need to make a living, and with that they have to make some functonality of ClickHouse propritary. You can scale the pure open source project really far. And if you need more, you do have money to pay for it. People need to stop thinking that open source is free leech. Open source is about sharing knowledge and building trust between each other. But we are still living in a business world where we are competing.
    - rastignack 1y ago
      It is important to decorelate compute and Storage. I think people should be aware that the Core Storage work is not beeing done in the open anymore. The process of letting the open source core grow useless while selling proprietary addons is fine. I just have a problem with people calling this open source. Some prefer using open source. Are they leeches ? Regarding scaling open source projects, did Linux scale ?
deleted 1y ago
[deleted]

simonw 1y ago

They have an interesting version that's packaged a bit like DuckDB - you can even "pip install" it: https://github.com/chdb-io/chdb https://github.com/chdb-io/chdb

AYBABTME 1y ago
They don't do static builds AFAICT, which would make it a real competitor to DuckDB.
- auxten 1y ago
  chDB author here, You are right, we have not made a static libchDB. BTW, I guess you are a golang developer?
  - AYBABTME 1y ago
    Correct! Would love to have the Go package come as a single dependency without having to distribute `.so` files. That's what's stopping me from using `chDB` now instead of DuckDB. Being able to use chDB in a static manner would also help deepen my usage of the Clickhouse server. Right now the Clickhouse side of my project is lagging behind the DuckDB one because of this.
    - ryadh 1y ago
      That's great feedback, thank you! I just added your comment to the GH issue: https://github.com/chdb-io/chdb/issues/101#issuecomment-2824107674 https://github.com/chdb-io/chdb/issues/101#issuecomment-2824... Ps. I work for ClickHouse
codedokode 1y ago
What is the use case for an embedded terabyte-scale database, by the way?

skeptrune 1y ago

Tbh, I'm not too worried about CH management. Let them mod the GH if they want to, it's their company. Contribution is strong and varied enough that I think we're good for the long term.

memset 1y ago

chdb and clickhouse-local is nearly as ergonomic as duckdb with all of the features of ch. duckdb has unfortunately been leaning away from pure oss - the ui they released is entirely hosted on motherduck’s servers (which, while an awesome project, makes me feel like the project will be cannibalized by a proprietary extensions.)

apwell23 1y ago
> the ui they released is entirely hosted on motherduck’s servers who is they in this sentence ? afaik UI was released by motherduck a private company.
rastignack 1y ago
ClickHouse too. Their sharedmergetree is not open source at all. It makes ClickHouse OSS obsolete design-wise. Shame.
- olavgg 1y ago
  Actually this is not important. Because they need to make a living, and with that they have to make some functonality of ClickHouse propritary. You can scale the pure open source project really far. And if you need more, you do have money to pay for it. People need to stop thinking that open source is free leech. Open source is about sharing knowledge and building trust between each other. But we are still living in a business world where we are competing.
  - rastignack 1y ago
    It is important to decorelate compute and Storage. I think people should be aware that the Core Storage work is not beeing done in the open anymore. The process of letting the open source core grow useless while selling proprietary addons is fine. I just have a problem with people calling this open source. Some prefer using open source. Are they leeches ? Regarding scaling open source projects, did Linux scale ?

deleted 1y ago

[deleted]