4 ms·

I remember playing with it a while ago and here are my 2c: - It's ridiculously fast, like, I didn't know where the performance was coming from. - Getting it u

by drej 8y ago

I remember playing with it a while ago and here are my 2c: - It's ridiculously fast, like, I didn't know where the performance was coming from. - Getting it up and running was a bit clunky (Docker saved me), but I hear it's better now. - It has non-standard (I mean, everyone is non-standard, but this is way off ANSI) and case-sensitive (???) SQL syntax. This annoyed me again and again. - It seemed (and still seems) like a project that lives and dies with one developer - and no matter how brilliant he may be, I'm not willing to invest in a technology that has this risk and it's so hard to migrate off of (because of the non-standard SQL). I'm sad about the last two points, because the database is rather brilliant otherwise.

dschuler 8y ago
By one developer you mean Yandex or that most commits are made by a couple of users? Being backed by a large company (the Russian Google apparently) that has an independent revenue stream seems like a large plus, but maybe not enough to cancel out. I'm wary of investing effort into a potentially unsupported project as well, but I wonder if ClickHouse only seems "out there" because we're not aware of the Russian tech ecosystem (at least I'm not). People don't seem concerned about building anything with Firebase, but Google doesn't have a good track record of changing its mind about priorities or service pricing. What would you recommend instead for a column-oriented db that you can self-host (commercial or open source)?
- drej 8y ago
  It's in the Yandex namespace and it is used by said company, which is a huge plus. But if you looked at the development history just a while ago, it was highly dependent on Alexey. It reminds me of Grumpy (https://github.com/google/grumpy https://github.com/google/grumpy), which was released by Google, but was later basically abandoned when the lead left Google. That being said, the situation is better than last time I checked this, there is a handful of somewhat active developers. https://github.com/yandex/ClickHouse/graphs/contributors https://github.com/yandex/ClickHouse/graphs/contributors
Grue3 8y ago
>It seemed (and still seems) like a project that lives and dies with one developer This project is developed by Yandex and they have a team working on it.
bsg75 8y ago
> It seemed (and still seems) like a project that lives and dies with one developer One major contributor (who may be project lead at Yandex?) and a lot of active contributors: https://github.com/yandex/ClickHouse/graphs/contributors https://github.com/yandex/ClickHouse/graphs/contributors
PeterZaitsev 8y ago
If you need Advanced SQL Support ClickHouse is not there (Yet) but if you need high performance for relatively basic queries ClickHouse is great. It is developed mostly by ClickHouse staff but there is at least one company https://www.altinity.com/ https://www.altinity.com/ which offers Commercial Support, Consulting, Trainin for ClickHouse

by drej 8y ago

dschuler 8y ago

By one developer you mean Yandex or that most commits are made by a couple of users? Being backed by a large company (the Russian Google apparently) that has an independent revenue stream seems like a large plus, but maybe not enough to cancel out. I'm wary of investing effort into a potentially unsupported project as well, but I wonder if ClickHouse only seems "out there" because we're not aware of the Russian tech ecosystem (at least I'm not). People don't seem concerned about building anything with Firebase, but Google doesn't have a good track record of changing its mind about priorities or service pricing. What would you recommend instead for a column-oriented db that you can self-host (commercial or open source)?

drej 8y ago
It's in the Yandex namespace and it is used by said company, which is a huge plus. But if you looked at the development history just a while ago, it was highly dependent on Alexey. It reminds me of Grumpy (https://github.com/google/grumpy https://github.com/google/grumpy), which was released by Google, but was later basically abandoned when the lead left Google. That being said, the situation is better than last time I checked this, there is a handful of somewhat active developers. https://github.com/yandex/ClickHouse/graphs/contributors https://github.com/yandex/ClickHouse/graphs/contributors

Grue3 8y ago

>It seemed (and still seems) like a project that lives and dies with one developer This project is developed by Yandex and they have a team working on it.

bsg75 8y ago

> It seemed (and still seems) like a project that lives and dies with one developer One major contributor (who may be project lead at Yandex?) and a lot of active contributors: https://github.com/yandex/ClickHouse/graphs/contributors https://github.com/yandex/ClickHouse/graphs/contributors

PeterZaitsev 8y ago

If you need Advanced SQL Support ClickHouse is not there (Yet) but if you need high performance for relatively basic queries ClickHouse is great. It is developed mostly by ClickHouse staff but there is at least one company https://www.altinity.com/ https://www.altinity.com/ which offers Commercial Support, Consulting, Trainin for ClickHouse