📈 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!
TypeScript chartsclickhousedockergdprgoogle-analyticsmetricsmonitoringmysqlnestjsprivacyredisself-hostedselfhostedstatisticstailwindcssweb-analyticswebanalyticswebsite
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 }