Skip to content

📈 Open source, privacy-first web analytics — a cookie-less Google Analytics alternative with built-in error tracking and performance monitoring. Self-host it or use our cloud. Get started for free!

2.2 KB
Raw Blame
import type {
  Logger as _CHLogger,
  LogParams,
  ErrorLogParams,
} from '@clickhouse/client'
import { createClient, ClickHouseLogLevel } from '@clickhouse/client'
import { Logger } from '@nestjs/common'
import 'dotenv/config'

class CHLogger implements _CHLogger {
  debug({ module, message, args }: LogParams): void {
    Logger.debug({
      type: '@clickhouse/client',
      module,
      message,
      ...args,
    })
  }

  trace({ module, message, args }: LogParams) {
    Logger.log({
      type: '@clickhouse/client',
      module,
      message,
      ...args,
    })
  }

  info({ module, message, args }: LogParams): void {
    Logger.log({
      type: '@clickhouse/client',
      module,
      message,
      ...args,
    })
  }

  warn({ module, message, args }: LogParams): void {
    Logger.warn({
      type: '@clickhouse/client',
      module,
      message,
      ...args,
    })
  }

  error({ module, message, args, err }: ErrorLogParams): void {
    Logger.error({
      type: '@clickhouse/client',
      module,
      message,
      ...args,
      err,
    })
  }
}

const clickhouse = createClient({
  url: `${process.env.CLICKHOUSE_HOST}:${process.env.CLICKHOUSE_PORT}`,
  username: process.env.CLICKHOUSE_USER,
  password: process.env.CLICKHOUSE_PASSWORD,
  database: process.env.CLICKHOUSE_DATABASE,
  request_timeout: 60000, // 1 minute
  clickhouse_settings: {
    connect_timeout: 60000,
    date_time_output_format: 'iso',
    max_download_buffer_size: (10 * 1024 * 1024).toString(),
    max_download_threads: 32,
    max_execution_time: 60000,
    output_format_json_quote_64bit_integers: 0,
    enable_http_compression: 0,
    log_queries: 0,

    compile_expressions: 0,
    compile_aggregate_expressions: 0,

    // Used for analytics & captcha stuff.
    // https://clickhouse.com/docs/en/optimize/asynchronous-inserts
    wait_for_async_insert: 0, // Return ACK (await) when row was added to the buffer, not flushed to the database
    async_insert_busy_timeout_ms: 15000, // 15 seconds; this is how long the buffer will be kept before writing stuff into the database
  },
  log: {
    LoggerClass: CHLogger,
    level: ClickHouseLogLevel.ERROR,
  },
})

export { clickhouse }