ClickHouse — колоночная база для аналитики

★ 49K

ClickHouse is an open-source column-oriented database for analytics that computes reports over enormous volumes fast. Reach for it when an ordinary database stops coping with questions like "how many events per day over the past year, broken down by source": on tens or hundreds of millions of rows such a query takes minutes in a classic RDBMS and seconds here. Typical uses: product and website event analytics, logs and metrics, real-time dashboards, a warehouse behind BI. The trick is the layout — data is stored by column, so a query reads only the fields it needs rather than whole rows. Install it with one command on Linux, macOS or FreeBSD, or use the managed cloud. Know the boundary: this is a database for reading and aggregation, not for operational transactions — it is not meant to run a shop or a CRM.