Hacker News new | ask | show | jobs
by sdesol 1068 days 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

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 is reading this, I'm open to seeing if I can't get my solution working on ClickHouse.
1 comments
tylerhannan 1068 days ago
That would be https://news.ycombinator.com/user?id=zX41ZdbW

https://github.com/ClickHouse/github-explorer

link
sdesol 1068 days 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.
link
tylerhannan 1067 days 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)

link