News for hackers. Stuff that matters.

A comment on ClickHouse gets lazier (and faster): Introducing lazy materialization.

Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by dangoodmanUT on Tuesday April 22, 2025 @05:14PM (#43766367)
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)

[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by simonw on Tuesday April 22, 2025 @07:21PM (#43767210)
They have an interesting version that's packaged a bit like DuckDB - you can even "pip install" it: https://github.com/chdb-io/chdb
[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by AYBABTME on Tuesday April 22, 2025 @07:46PM (#43767351)
They don't do static builds AFAICT, which would make it a real competitor to DuckDB.
[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by auxten on Tuesday April 22, 2025 @09:44PM (#43767957)
chDB author here, You are right, we have not made a static libchDB. BTW, I guess you are a golang developer?
[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by AYBABTME on Wednesday April 23, 2025 @02:29AM (#43769224)
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.
[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by ryadh on Wednesday April 23, 2025 @08:23AM (#43771270)
That's great feedback, thank you! I just added your comment to the GH issue: https://github.com/chdb-io/chdb/issues/101#issuecomment-2824...

Ps. I work for ClickHouse

[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by codedokode on Wednesday April 23, 2025 @02:21AM (#43769187)
What is the use case for an embedded terabyte-scale database, by the way?
[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by skeptrune on Tuesday April 22, 2025 @09:32PM (#43767905)
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.

[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by memset on Tuesday April 22, 2025 @09:54PM (#43767987)
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.)

[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by apwell23 on Tuesday April 22, 2025 @11:43PM (#43768446)
> 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.

[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by rastignack on Wednesday April 23, 2025 @01:55AM (#43769048)
ClickHouse too. Their sharedmergetree is not open source at all. It makes ClickHouse OSS obsolete design-wise. Shame.
[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by olavgg on Wednesday April 23, 2025 @03:49AM (#43769633)
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.

[ Parent | on HN ]
Re:ClickHouse gets lazier (and faster): Introducing lazy mat... by rastignack on Wednesday April 23, 2025 @04:49AM (#43769938)
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 ?

[ Parent | on HN ]