roq-clickhouse#

Purpose#

  • Monitor event-logs streamed to a filesystem

  • Upload history to a Clickhouse timeseries database.

Conda#

$ mamba install \
  --channel https://roq-trading.com/conda/stable \
  roq-clickhouse
$ roq-clickhouse \
      --name "clickhouse" \
      --service_listen_address "$TCP_LISTEN_PORT" \
      --event_log_dir "$EVENT_LOG_DIR" \
      --flagfile "$FLAG_FILE"

Flags#

$ roq-clickhouse --help

--event_log_dir

One or more event-log directories

--event_log_exclude

One or more exclude regex patterns

--event_log_include

One or more include regex patterns

--uri

ClickHouse URI, e.g. tcp://localhost:8123

--username

Username (optional)

--password

Password (optional)

--retention_policy_time_to_live_days

Time-to-live (in days) (optional)

--print_ddl

Print the basic DDL script (useful for manually creating a database).

Environments#

# flagfile

--uri=http://localhost:8123
--database_name=roq
--create_database=True
--retention_policy_time_to_live_days=2