clickhouse-deploy-integration

# ClickHouse Deploy Integration ## Overview Deploy applications that connect to ClickHouse Cloud from serverless and container platforms with proper connection management and secrets handling. ## Prerequisites - ClickHouse Cloud instance (or self-hosted with public endpoint) - Platform CLI installed (vercel, fly, or gcloud) - Application tested locally against ClickHouse ## Instructions ### Step 1: ClickHouse Connection Module (Platform-Agnostic) ```typescript // src/db.ts — singleton for serverless-safe connections import { createClient, ClickHouseClient } from '@clickhouse/client'; let client: ClickHouseClient | null = null; export function getClickHouse(): ClickHouseClient { if (!client) { client = createClient({ url: process.env.CLICKHOUSE_HOST!, // https://<host>:8443 username: process.env.CLICKHOUSE_USER!, password: process.env.CLICKHOUSE_PASSWORD!, database: process.env.CLICKHOUSE_DATABASE ?? 'default', request_timeout: 30_000, max_open_connections: 5, // Low for serverless (many cold starts) compression: { request: true, // Saves egress bandwidth response: true, }, }); } return client; } ``` ### Step 2: Vercel (Serverless Functions) ```bash # Set secrets vercel env add CLICKHOUSE_HOST production vercel env add CLICKHOUSE_USER production vercel env add CLICKHOUSE_PASSWORD production vercel env add CLICKHOUSE_DATABASE production ``` ```typescript // api/events...