اتصال به دیتابیس ClickHouse در برنامه‌های NodeJS

npm install @clickhouse/client

CLICKHOUSE_HOST=http://rainier.liara.cloud:33273
CLICKHOUSE_USER=root
CLICKHOUSE_PASSWORD=x4y2LJvdFyG5wVO87VbXDrpg

require('dotenv').config();

const { createClient } = require('@clickhouse/client');

const client = createClient({
    url: process.env.CLICKHOUSE_HOST,
    username: process.env.CLICKHOUSE_USER,
    password: process.env.CLICKHOUSE_PASSWORD,
    request_timeout: 10000,
});

async function connect() {
try {
  await client.query({
    query: 'SELECT 1',
    format: 'JSONEachRow',
  });

  console.log('ClickHouse connection successful');
} catch (error) {
  console.error('ClickHouse connection failed');
  process.exit(1);
}
}

connect();