gingerwizard

6 ms·

1.
CryptoHouse – free blockchain analytics using ClickHouse(clickhouse.com)
9 points by gingerwizard 2y ago|0 comments
2.
by gingerwizard 2y ago
Few in this thread have suggested ClickHouse would do well here. We tested 1 trillon rows recently, albeit much simpler data - https://clickhouse.com/blog/clickhouse-1-trillion-row-challe... This is a good dataset thou
3.
by gingerwizard 3y ago
Author of the post here, would love to hear ideas for optimization to improve this.
4.
One billion row challenge in ClickHouse SQL(clickhouse.com)
9 points by gingerwizard 3y ago|1 comments
5.
by gingerwizard 3y ago
Hey author, here, so yes its not the most recent technique, but when coupled with rescoring like we propose it can be a simple speed up for linear scans. It also a pure SQL solution and requires no indices. It benefits from being easy to up
6.
by gingerwizard 3y ago
Some good examples and docs on this data https://clickhouse.com/docs/en/getting-started/example-datas...
7.
Enhancing Google Analytics Data with ClickHouse(clickhouse.com)
3 points by gingerwizard 3y ago|0 comments
8.
by gingerwizard 3y ago
Its about a billion rows a day. Nice idea, we could probably add a visual for possible malicious packages.
9.
Show HN: ClickPy – OSS project and service for Python analytics using ClickHouse(clickpy.clickhouse.com)
17 points by gingerwizard 3y ago|2 comments
10.
by gingerwizard 4y ago
Just use ClickHouse :) https://sql.clickhouse.com/play?user=play#U0VMRUNUICogRlJPTS...
11.
by gingerwizard 4y ago
I'd use clickhouse-local, ideal for this workload without needing to load into a full ClickHouse instance. https://clickhouse.com/blog/extracting-converting-querying-l...