Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Ten years of ClickHouse in open source

clickhouse.com

Post reply on HN
Print view View original

91–100 of 110 posts

Re: Ten years of ClickHouse in open source

#91

Post by rastignack »

nasretdinov wrote: post #86
ddorian43 wrote: post #9

Clickhouse is *really* gatekeeping the "zero copy replication" where you store data on object-storage and have high availability from the open source version.

That feature is central for ClickHouse Cloud offering which essentially is what lets others have (the rest of) ClickHouse for free. If you need that feature I think it's quite obvious you'll have to pay. I don't think it's an unreasonable stance at all. P.S. I don't believe you are right to call it "zero copy" either. The object storage itself is replicated and definitely does copy and/or split data a lot under the h…

The thing is you are going to be comoditized on this too. And it’s going to be faster to migrate off your database with AI. You are going to need to have a plan.

Re: Ten years of ClickHouse in open source

#93

Post by cpursley »

philippemnoel wrote: post #76
himata4113 wrote: post #6

ClickHouse recently has been a breath of fresh air compared to using timescaledb for a long time. Although psql is the greatest there is and I really enjoyed the fact that I could rely on a single database system to run everything, when it came to migration maintenance and deployment it's really a pain and it also feels like development on timescaledb is a bit wishy washy with all the structural changes from version…

There is significant work happening in the PostgreSQL ecosystem to make "use a single system to run everything" possible. ParadeDB is one such system pushing on full-text/vector search, with some light aggregations, at the index level. There is also work being done by DuckDB folks with pg_duckdb and others like Xata. (disclaimer: I work at ParadeDB)

What’s the closest extension or tooling that provides functionality similar to ClickHouse? I’m looking for something like that before making the full jump and adding another dependency.

Re: Ten years of ClickHouse in open source

#94

Post by cpursley »

murkt wrote: post #81
ksajadi wrote: post #67

For our metrics and autoscaling engine at Cloud 66, we went through 5 iterations before settling on Clickhouse: 1. Redis 2. Cassandra 3. Handrolled: Ruby + RabbitMQ 4. Handrolled: Go + RabbitMQ 5. Clickhouse Every time we reached some limit or huge optimization burdens that were unfeasible. Clickhouse has been rock solid for the past 4 years.

I am having a hard time picturing what could be the problem that you were solving. Redis, Cassandra, RabbitMQ and Clickhouse. RabbitMQ looks like a black sheep in this lineup.

I’m gonna guess that it’s because Ruby is dog slow and not concurrent.

Re: Ten years of ClickHouse in open source

#97

Post by mscdex »

kjuulh wrote: post #75

Love clickhouse it is just super performant. I've had to tweak a few queries for performance here and there but it has been more than stellar. I'd initially set up a real time pipeline ingest for us to handle our larger incremental ingests when i started (used redshift in the past, very expensive and quite slow in comparison), it has been unnecessary so far, as clickhouse has just been able to chew through tons of da…

What "heavy handed tracing" was turned on by default?

Re: Ten years of ClickHouse in open source

#98

Post by curt15 »

malkia wrote: post #79
KebabCase wrote: post #33

Earlier quoted context omitted.

[flagged]

There is an awesome amount of software written by Russians - nginx, clickhouse, 7zip, Far Manager, WinRAR, even Kotlin (his creator) - I grew up, as bulgarian, with Russian books (especially math) that were indispensible. Do I like the Russian goverment, or any of their goverments (current, soviet or royal ones) - Hell no! We were liberated "two" or was it "three" times by then only to screw things for us badly (Bulg…

All the Jetbrains tooling as well.
Post reply on HN