Clickhouse

ClickHouse is an open-source column-oriented DBMS (columnar database management system) for online analytical processing (OLAP) that allows users to generate analytical reports using SQL queries in real-time.

Getting Started

# In `perSystem.process-compose.<name>`
{
  services.clickhouse."clickhouse-1".enable = true;
}

Tips & Tricks

Change the HTTP default port

Clickhouse has HTTP Interface that is enabled by default on port 8123. To change the default port, use the extraConfig option:

{
  services.clickhouse."clickhouse-1" = {
    enable = true;
    extraConfig = {
      http_port = 9050
    };
  };
}

Initial database schema

To load a database schema, you can use the initialDatabases option:

{
  services.clickhouse."clickhouse-1" = {
    enable = true;
    initialDatabases = [
      {
        name = "sample_db";
        schemas = [ ./test.sql ];
      }
      # or just create the database:
      {
        name = "sample_db_without_schema";
      }
    ];
  };
}