ClickHouse
Real-time column-oriented analytical database for sub-second queries on billions of rows.
About ClickHouse
ClickHouse is a high-performance, open-source column-oriented database management system designed for real-time analytical data processing. It handles billions of rows with sub-second query response times, making it ideal for dashboards, event analytics, time-series data, and log analysis workloads.
ClickHouse supports SQL with advanced analytical functions, distributed queries across clusters, data compression (up to 10x), and integrations with common BI and data tools. It is used by enterprises like Cloudflare, GitLab, and 2K Games for high-velocity analytics. Runs on Linux, macOS, and FreeBSD with a single binary or Docker deployment.
Key Features
- Column-oriented storage with sub-second queries on petabyte-scale data
- Real-time data ingestion with linear horizontal scalability
- Advanced SQL with window functions, arrays, aggregates, and approximate deduplication
- Data compression up to 10x with vectorized query execution
Self-Hosting Notes
Single binary or Docker. High resource requirements for production (recommend 8GB+ RAM). Columnar storage uses more disk than row-based DBs. Apache 2.0 licensed.
More in Marketing, Analytics, & Finance
Actual Budget
Privacy-focused budgeting app with envelope-style budgeting.
Akaunting
Free, open-source online accounting software for small businesses.
BTCPay Server
Self-hosted, open-source Bitcoin payment processor with Lightning Network, POS, crowdfunding, and no transaction fees.
Bitcart
Free, open-source, self-hosted multi-currency payment processor supporting BTC, ETH, USDT, XMR, and 50+ cryptocurrencies.