اتصال به دیتابیس 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();

npm install mysql2

const mysql = require('mysql2/promise');

const dbConfig = {
host: process.env.DB_HOST,
port: process.env.DB_PORT,
database: process.env.DB_NAME,
user: process.env.DB_USER,
password: process.env.DB_PASS,
waitForConnections: true,
connectionLimit: 10,
queueLimit: 0,
};
const pool = mysql.createPool(dbConfig);


(async () => {
try {
  const connection = await pool.getConnection();
  console.log('Connected to the MySQL server.');
  connection.release();
} catch (error) {
  console.error('Error connecting to the MySQL server:', error);
}
})();