▲ | joshstrange a day ago | ||||||||||||||||||||||||||||
Every time I use Clickhouse I want blow my brains out, especially knowing that Postgres exists. I’m not saying Clickhouse doesn’t have its place or that Postgres can do everything that Clickhouse can. What I am saying is that I really dislike working in Clickhouse with all of the weird foot guns. Unless you are using it in a very specific, and in my opinion, limited way, it feels worse than Postgres in every way. | |||||||||||||||||||||||||||||
▲ | mdaniel 20 hours ago | parent | next [-] | ||||||||||||||||||||||||||||
Anything in my life that uses Zookeeper or its dumbass etcd friend means I'm going to have a real bad time. I am thankful they're at least shipping their own ZK-ish but it seems to have fallen into the same trap as etcd, where membership has to be managed like the precious little pets that they are https://clickhouse.com/docs/guides/sre/keeper/clickhouse-kee... | |||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||
▲ | valyala 4 hours ago | parent | prev | next [-] | ||||||||||||||||||||||||||||
Just don't use ClickHouse for OLTP tasks. ClickHouse is an analytical database, which isn't optimized for transactional workloads. Keep calm and use Postgresql for OLTP, and ClickHouse for OLAP. | |||||||||||||||||||||||||||||
▲ | atemerev a day ago | parent | prev [-] | ||||||||||||||||||||||||||||
I mostly need analytics, all data is immutable and append-only. | |||||||||||||||||||||||||||||
|