3 ms·

> greatly over-estimating the author's goal here Yeah it is clearly a showcase for ClickHouse which is worth bragging about since it is quite performant. And i

by sdesol 3y ago

> greatly over-estimating the author's goal here Yeah it is clearly a showcase for ClickHouse which is worth bragging about since it is quite performant. And it has a very strong community as the following shows: https://devboard.gitsense.com/ClickHouse/ClickHouse https://devboard.gitsense.com/ClickHouse/ClickHouse I am honestly not sure if my solution can handle HackerNews at this point since generating deep insights for ClickHouse (which has a lot of history) is very expensive. For those curious, I'm running DevBoard on a single 128 GB machine with 6TB of SSD in RAID 0 (I'm willing to take the risk) and the Postgres database has over 1000 partitions (including sub-partitions) that are optimized for my queries. I'm pretty sure ClickHouse can be more performant and if the creator of https://ghe.clickhouse.tech https://ghe.clickhouse.tech is reading this, I'm open to seeing if I can't get my solution working on ClickHouse.

tylerhannan 3y ago
That would be https://news.ycombinator.com/user?id=zX41ZdbW https://news.ycombinator.com/user?id=zX41ZdbW https://github.com/ClickHouse/github-explorer https://github.com/ClickHouse/github-explorer
- sdesol 3y ago
  Thanks. For a CTO, he is extremely active in the community. Only the ClickHouse robot is on par with his engagement. I'll reach out to him to see if ClickHouse is a viable option as my plan is to replace GitHub's insights tab with a useful dashboard (this is why DevBoard has such an minimal look), so I'll need a very performant DB that can work with my queries.
  - tylerhannan 3y ago
    We are lucky to have him. It also helps that he was the founding engineer on the product. Also, feel free to hit us up in GH (or we have a Slack). ClickHouse is used for a number of dashboarding implementations. It should work...but, as always, proof is in the testing. Good luck! (and OMG, a better insights tab would make me a happy human)

by sdesol 3y ago

tylerhannan 3y ago

That would be https://news.ycombinator.com/user?id=zX41ZdbW https://news.ycombinator.com/user?id=zX41ZdbW https://github.com/ClickHouse/github-explorer https://github.com/ClickHouse/github-explorer

sdesol 3y ago
Thanks. For a CTO, he is extremely active in the community. Only the ClickHouse robot is on par with his engagement. I'll reach out to him to see if ClickHouse is a viable option as my plan is to replace GitHub's insights tab with a useful dashboard (this is why DevBoard has such an minimal look), so I'll need a very performant DB that can work with my queries.
- tylerhannan 3y ago
  We are lucky to have him. It also helps that he was the founding engineer on the product. Also, feel free to hit us up in GH (or we have a Slack). ClickHouse is used for a number of dashboarding implementations. It should work...but, as always, proof is in the testing. Good luck! (and OMG, a better insights tab would make me a happy human)