@watchdg/clickhouse-client

clickhouse-client

nodejs clickhouse client

Install

yarn add @watchdg/clickhouse-client
# or
npm install @watchdg/clickhouse-client

How to use

import {ClickhouseClient} from '@watchdg/clickhouse-client';

(async function () {
    const clickhouseClient = new ClickhouseClient();
    const {rows, data} = await clickhouseClient.query('select 1');
    console.log(data);
})();

Supported formats

• TabSeparated (TSV)
• TabSeparatedRaw (TSVRaw)
• TabSeparatedWithNames (TSVWithNames)
• TabSeparatedWithNamesAndTypes (TSVWithNamesAndTypes)

Supported types

Clickhouse	NodeJS
Int8	Number
Int16	Number
Int32	Number
UInt8	Number
UInt16	Number
UInt32	Number
Float32	Number
Float64	Number
Int64	BigInt
Int128	BigInt
Int256	BigInt
UInt64	BigInt
UInt128	BigInt
UInt256	BigInt
Bool	Boolean
DateTime	Date
String	String
UUID	String
IPv4	String
IPv6	String

• Nullable(T)
• Array(T)