Product
Introducing Enhanced Alert Actions and Triage Functionality
Socket now supports four distinct alert actions instead of the previous two, and alert triaging allows users to override the actions taken for all individual alerts.
clickhouse-ts
Advanced tools
Readme
import { Clickhouse } from 'clickhouse-ts'
import fs from 'fs'
import dayjs from 'dayjs'
import { serializeError } from 'serialize-error'
import Redis from 'ioredis' // for correct work use only this package
const clickhouseInstance = new Clickhouse(
{
url: 'url',
port: 8443,
user: 'user',
password: 'password',
database: 'database',
ca: fs.readFileSync('cert.crt')
},
{
/* debug may be undefined */
debug: {
mode: true,
/* List of providers to exclude from logging */
exclude: [...providers]
},
/* cache may be undefined */
cache: {
/* after this time chunk will be completed */
chunkTTLSeconds: 3600,
/* interval of checking chunks */
chunkResolverIntervalSeconds: 180,
/* count of rows in one chunk */
chunkSizeLimit: 10_000,
/*
'events': on completed chunk emits event 'chunk'. You can save rows as you want
'autoInsert': on completed chunk inserts rows automatically
*/
chunkResolveType: 'events'
},
defaultResponseFormat: 'JSON',
/*
any clickhouse options
https://clickhouse.tech/docs/en/operations/settings/settings/
*/
clickhouseOptions: {
send_progress_in_http_headers: '1'
}
}
)
clickhouseInstance.useCaching('redis', new Redis())
clickhouseInstance.onChunk((chunkId, table, rows) => {
// do want you want
})
const response = clickhouseInstance
.cache(
'strings',
[
{ date: '2021-01-01', string: 'str1' },
{ date: '2021-01-02', string: 'str2' }
],
{
responseFormat: 'CSVWithNames' // or another format
// another query options
}
)
.then(response => response)
.catch(e => serializeError(e))
response
/*
{
cached: 2,
chunk: chunkId
}
*/
const response = clickhouseInstance
.insert(
'strings',
[
{ date: '2021-01-01', string: 'str1' },
{ date: '2021-01-02', string: 'str2' }
],
{
responseFormat: 'CSVWithNames' // or another format
// another query options
}
)
.then(response => response)
.catch(e => serializeError(e))
response
/*
{
inserted: 2,
data: [...rows]
}
*/
clickhouseInstance
.query('WITH now() as t SELECT t', {
responseFormat: 'TSV',
// ...another query options
})
.then(result => result.data.data)
.catch(e => serializeError(e))
clickhouseInstance.query(`
CREATE TABLE strings (
date DateTime('UTC'),
string String
) Engine = ReplacingMergeTree()
PARTITION BY toMonday(date)
ORDER BY (date, string)
`)
FAQs
Light stable Clickhouse client
The npm package clickhouse-ts receives a total of 101 weekly downloads. As such, clickhouse-ts popularity was classified as not popular.
We found that clickhouse-ts demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Product
Socket now supports four distinct alert actions instead of the previous two, and alert triaging allows users to override the actions taken for all individual alerts.
Security News
Polyfill.io has been serving malware for months via its CDN, after the project's open source maintainer sold the service to a company based in China.
Security News
OpenSSF is warning open source maintainers to stay vigilant against reputation farming on GitHub, where users artificially inflate their status by manipulating interactions on closed issues and PRs.