Clickhouse & Goldsky: CryptoHouse
summary
ClickHouse plus Goldsky deliver CryptoHouse, a free blockchain analytics service that ingests data in real time with no batching and exposes it over SQL. It stores ~300 billion rows, claims >20x compression versus CSV, supports millions of writes per second (Solana ~4,000 TPS for context), and runs queries scanning billions of rows/sec. Example: a 7‑second query reads 72M rows and processes 1.2B rows to find the day’s most active account. Quotas enforce fair use and results power simple visualizations.
AI-written summary · about
chapters (7)
- 0:00Introduction to CryptoHouse
- 0:16Understanding ClickHouse
- 0:55ClickHouse for analytics
- 2:25Trusted industry adoption
- 2:54CryptoHouse service features
- 3:46CryptoHouse live demonstration
- 5:04Getting started and closing
related talks
34mClickHouse® - What is Behind the Fastest Columnar Database?
42mClickHouse: what is behind the fastest columnar database
23mThe Open Source Analytic Universe, Version 2022
45mClickHouse: what is behind the fastest columnar database
30mBuilding For Fast
17mBuilding Real-Time Data Lake with ClickHouse
17mUsing ClickHouse® Database to Power an Analytics and Customer Engagement Platform
28mColumnstore Revolution