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

npm install @clickhouse/client

CLICKHOUSE_HOST=http://rainier.liara.cloud:33273
CLICKHOUSE_USER=root
CLICKHOUSE_PASSWORD=x4y2LJvdFyG5wVO87VbXDrpg
NEXT_PUBLIC_APP_URL=http://localhost:3000 # replace it on production

import { createClient } from '@clickhouse/client';

export const clickhouse = createClient({
    host: process.env.CLICKHOUSE_HOST!,
    username: process.env.CLICKHOUSE_USER!,
    password: process.env.CLICKHOUSE_PASSWORD!,
    max_open_connections: 10,
    request_timeout: 10000,
});

import { NextResponse } from 'next/server';
import { clickhouse } from '@/lib/clickhouse';

export async function GET() {
try {
  await clickhouse.query({
    query: 'SELECT 1',
    format: 'JSONEachRow',
  });

  return NextResponse.json({
    success: true,
    message: 'ClickHouse connection successful',
  });
} catch (error) {
  return NextResponse.json(
    {
      success: false,
      message: 'ClickHouse connection failed',
    },
    { status: 500 }
  );
}
}

export default async function ClickHouseTestPage() {
const res = await fetch(
  `undefined/api/clickhouse`,
  {
    cache: 'no-store',
  }
);

const data = await res.json();

return (
  <main>
    <h1>ClickHouse Status</h1>

    <pre>
      {JSON.stringify(data, null, 2)}
    </pre>
  </main>
);
}