ClickHouse
Managed ClickHouse on DockHosting for analytics and event data.
ClickHouse is a column-oriented database built for analytical queries over large volumes of data — logs, events, time-series metrics — rather than as a general-purpose transactional database. Reach for it when Postgres or MySQL start to strain under aggregation-heavy analytical workloads.
Versions
24 and 23 are available when you create a database.
Connection
ClickHouse's native protocol runs on its own port; injected automatically when you attach the database to a project. The official clients (clickhouse-driver for Python, clickhouse-client for Go, @clickhouse/client for Node) all accept host, port, and credentials directly.
Connecting locally
Off by default — see Connect from your computer. Once public access is on, the clickhouse-client CLI or any HTTP-interface client can connect using the host and port shown in the database's connection details.
What it's good for
- Event and analytics pipelines
- Log aggregation and search
- Time-series metrics at a scale where row-oriented databases become slow for aggregate queries
Backups
Automatic, plus on-demand — see Backups.