[Snyk] Upgrade @clickhouse/client from 0.2.7 to 0.2.9 #1172

New Issue

MrUnknownDE · 2026-04-05T16:25:47+02:00

MrUnknownDE commented

2026-04-05 16:25:47 +02:00

Originally created by @simlarsen on 2/28/2024

This PR was automatically created by Snyk using the credentials of a real user.

Snyk has created this PR to upgrade @clickhouse/client from 0.2.7 to 0.2.9.

ℹ️ Keep your dependencies up-to-date. This makes it easier to fix existing vulnerabilities and to more quickly identify and fix newly disclosed vulnerabilities when they affect your project.

The recommended version is 2 versions ahead of your current version.
The recommended version was released a month ago, on 2024-01-19.

Release notes

Package name: @clickhouse/client

0.2.9 - 2024-01-19
New features
- It is now possible to set additional HTTP headers for outgoing ClickHouse requests. This might be useful if, for example, you have a reverse proxy with authorization. (@ teawithfruit)
```
const client = createClient({
  additional_headers: {
    'X-ClickHouse-User': 'clickhouse_user',
    'X-ClickHouse-Key': 'clickhouse_password',
  },
})
```
0.2.8 - 2024-01-12
New features
- (Web only) Allow to modify Keep-Alive setting (previously always disabled). Keep-Alive setting is now enabled by default for the Web version.
```
import { createClient } from '@ clickhouse/client-web'
const client = createClient({ keep_alive: { enabled: true } })
```
- (Node.js & Web) It is now possible to either specify a list of columns to insert the data into or a list of excluded columns:
// Generated query: INSERT INTO mytable (* EXCEPT (message)) FORMAT JSONEachRow
await client.insert({
table: 'mytable',
format: 'JSONEachRow',
values: [{ id: 42 }],
columns: { except: ['message'] },
})">
```
// Generated query: INSERT INTO mytable (message) FORMAT JSONEachRow

await client.insert({

table: 'mytable',

format: 'JSONEachRow',

values: [{ message: 'foo' }],

columns: ['message'],

})
// Generated query: INSERT INTO mytable (* EXCEPT (message)) FORMAT JSONEachRow

await client.insert({

table: 'mytable',

format: 'JSONEachRow',

values: [{ id: 42 }],

columns: { except: ['message'] },

})
```
See also the new examples:
- Including specific columns or excluding certain ones instead
- Leveraging this feature when working with ephemeral columns (#217)
0.2.7 - 2023-12-13
New features
- (Node.js only) X-ClickHouse-Summary response header is now parsed when working with insert/exec/command methods. See the related test for more details.
  NB: it is guaranteed to be correct only for non-streaming scenarios.
  The web version does not currently support this due to CORS limitations. (#210)
Bug fixes
- Drain insert response stream in Web version - required to properly work with async_insert, especially in the Cloudflare Workers context.

from @clickhouse/client GitHub release notes

Commit messages

Package name: @clickhouse/client

8b3d134 Prepare 0.2.9; Cleanup tests and restrict the headers type to string only
9b358ea Allow to specify additional HTTP headers for ClickHouse requests (#224)
67a2fac Update insert into a different database example
6c1904f Add an example on inserts into a different database
6104a1e Additional issue templates (#223)
aafc649 Allow to specify or exclude insert columns (#218)
927ca27 Add read-only user examples
eaa0713 Make keep_alive configurable in the Web version (#220)
df4839d Add JS Date test/example

Compare

Note: You are seeing this because you or someone else with access to this repository has authorized Snyk to open upgrade PRs.

For more information:

🧐 View latest project report

🛠 Adjust upgrade PR settings

🔕 Ignore this dependency or unsubscribe from future upgrade PRs

*Originally created by @simlarsen on 2/28/2024* This PR was automatically created by Snyk using the credentials of a real user. <h3>Snyk has created this PR to upgrade @clickhouse/client from 0.2.7 to 0.2.9.</h3> :information_source: Keep your dependencies up-to-date. This makes it easier to fix existing vulnerabilities and to more quickly identify and fix newly disclosed vulnerabilities when they affect your project. <hr/> - The recommended version is **2 versions** ahead of your current version. - The recommended version was released **a month ago**, on 2024-01-19. <details> <summary>Release notes</summary> <details> <summary>Package name: @clickhouse/client</summary> <ul> <li> 0.2.9 - <a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/releases/tag/0.2.9">2024-01-19</a><h3>New features</h3> <ul> <li>It is now possible to set additional HTTP headers for outgoing ClickHouse requests. This might be useful if, for example, you have a reverse proxy with authorization. (<a href="https://snyk.io/redirect/github/teawithfruit">@ teawithfruit</a>)</li> </ul> <div class="highlight highlight-source-ts notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="const client = createClient({ additional_headers: { 'X-ClickHouse-User': 'clickhouse_user', 'X-ClickHouse-Key': 'clickhouse_password', }, })"><pre>const client = createClient({ additional_headers: { 'X-ClickHouse-User': 'clickhouse_user', 'X-ClickHouse-Key': 'clickhouse_password', }, })</pre></div> </li> <li> 0.2.8 - <a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/releases/tag/0.2.8">2024-01-12</a><h3>New features</h3> <ul> <li>(Web only) Allow to modify Keep-Alive setting (previously always disabled). Keep-Alive setting is now enabled by default for the Web version.</li> </ul> <div class="highlight highlight-source-ts notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="import { createClient } from '@ clickhouse/client-web' const client = createClient({ keep_alive: { enabled: true } })"><pre>import { createClient } from '@ clickhouse/client-web' const client = createClient({ keep_alive: { enabled: true } })</pre></div> <ul> <li>(Node.js & Web) It is now possible to either specify a list of columns to insert the data into or a list of excluded columns:</li> </ul> <div class="highlight highlight-source-ts notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="// Generated query: INSERT INTO mytable (message) FORMAT JSONEachRow await client.insert({ table: 'mytable', format: 'JSONEachRow', values: [{ message: 'foo' }], columns: ['message'], }) // Generated query: INSERT INTO mytable (* EXCEPT (message)) FORMAT JSONEachRow await client.insert({ table: 'mytable', format: 'JSONEachRow', values: [{ id: 42 }], columns: { except: ['message'] }, })"><pre>// Generated query: INSERT INTO mytable (message) FORMAT JSONEachRow await client.insert({ table: 'mytable', format: 'JSONEachRow', values: [{ message: 'foo' }], columns: ['message'], }) // Generated query: INSERT INTO mytable (* EXCEPT (message)) FORMAT JSONEachRow await client.insert({ table: 'mytable', format: 'JSONEachRow', values: [{ id: 42 }], columns: { except: ['message'] }, })</pre></div> See also the new examples: <ul> <li><a href="/ClickHouse/clickhouse-js/blob/0.2.8/examples/insert_exclude_columns.ts">Including specific columns or excluding certain ones instead</a></li> <li><a href="/ClickHouse/clickhouse-js/blob/0.2.8/examples/insert_ephemeral_columns.ts">Leveraging this feature</a> when working with <a href="https://clickhouse.com/docs/en/sql-reference/statements/create/table#ephemeral" rel="nofollow">ephemeral columns</a> (<a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/issues/217" data-hovercard-type="issue" data-hovercard-url="/ClickHouse/clickhouse-js/issues/217/hovercard">#217</a>)</li> </ul> </li> <li> 0.2.7 - <a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/releases/tag/0.2.7">2023-12-13</a><h3>New features</h3> <ul> <li>(Node.js only) <code>X-ClickHouse-Summary</code> response header is now parsed when working with <code>insert</code>/<code>exec</code>/<code>command</code> methods. See the <a href="/ClickHouse/clickhouse-js/blob/0.2.7/packages/client-node/__tests__/integration/node_summary.test.ts">related test</a> for more details. NB: it is guaranteed to be correct only for non-streaming scenarios. The web version does not currently support this due to CORS limitations. (<a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/issues/210" data-hovercard-type="issue" data-hovercard-url="/ClickHouse/clickhouse-js/issues/210/hovercard">#210</a>)</li> </ul> <h3>Bug fixes</h3> <ul> <li>Drain insert response stream in Web version - required to properly work with <code>async_insert</code>, especially in the Cloudflare Workers context.</li> </ul> </li> </ul> from <a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/releases">@clickhouse/client GitHub release notes</a> </details> </details> <details> <summary>Commit messages</summary> <details> <summary>Package name: @clickhouse/client</summary> <ul> <li><a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/commit/8b3d1349fb5f769c0e1fbf80abf5e0f4e84d3dc8">8b3d134</a> Prepare 0.2.9; Cleanup tests and restrict the headers type to string only</li> <li><a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/commit/9b358ea37ab25ef7dbfe226e9eaa4c573ff0b032">9b358ea</a> Allow to specify additional HTTP headers for ClickHouse requests (#224)</li> <li><a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/commit/67a2facd2553d4e0a1e7a08ef0fd05ce1ef9d70f">67a2fac</a> Update insert into a different database example</li> <li><a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/commit/6c1904fba10a0d6b3319b563088e9d8a8672a619">6c1904f</a> Add an example on inserts into a different database</li> <li><a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/commit/6104a1e04591fd70ff5a37f1b5fb7036b4ed4c9a">6104a1e</a> Additional issue templates (#223)</li> <li><a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/commit/aafc649261acda914245cebcd3ac7ee4d7038b10">aafc649</a> Allow to specify or exclude insert columns (#218)</li> <li><a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/commit/927ca276d4d41d44e6b36b4315c5143a3467258a">927ca27</a> Add read-only user examples</li> <li><a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/commit/eaa07137d0d6640833ad5e88a3d4e2e21b3591cb">eaa0713</a> Make keep_alive configurable in the Web version (#220)</li> <li><a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/commit/df4839d1e48a38d66865f90e673d20cc2ae6d54d">df4839d</a> Add JS Date test/example</li> </ul> <a href="https://snyk.io/redirect/github/ClickHouse/clickhouse-js/compare/152b89a4a5faf91782acae149d1c7693f962a97f...8b3d1349fb5f769c0e1fbf80abf5e0f4e84d3dc8">Compare</a> </details> </details> <hr/> **Note:** *You are seeing this because you or someone else with access to this repository has authorized Snyk to open upgrade PRs.* For more information: <img src="https://api.segment.io/v1/pixel/track?data=eyJ3cml0ZUtleSI6InJyWmxZcEdHY2RyTHZsb0lYd0dUcVg4WkFRTnNCOUEwIiwiYW5vbnltb3VzSWQiOiIyODkyZmEzMy00YzU0LTQ5NzQtODEyNy0wZTc3Zjg1YzI3NjkiLCJldmVudCI6IlBSIHZpZXdlZCIsInByb3BlcnRpZXMiOnsicHJJZCI6IjI4OTJmYTMzLTRjNTQtNDk3NC04MTI3LTBlNzdmODVjMjc2OSJ9fQ==" width="0" height="0"/> 🧐 [View latest project report](https://app.snyk.io/org/oneuptime-RsC2nshvQ2Vnr35jHvMnMP/project/a2fb4fe1-f25f-4ff9-a58c-e78277b0a7fa?utm_source=github&utm_medium=referral&page=upgrade-pr) 🛠 [Adjust upgrade PR settings](https://app.snyk.io/org/oneuptime-RsC2nshvQ2Vnr35jHvMnMP/project/a2fb4fe1-f25f-4ff9-a58c-e78277b0a7fa/settings/integration?utm_source=github&utm_medium=referral&page=upgrade-pr) 🔕 [Ignore this dependency or unsubscribe from future upgrade PRs](https://app.snyk.io/org/oneuptime-RsC2nshvQ2Vnr35jHvMnMP/project/a2fb4fe1-f25f-4ff9-a58c-e78277b0a7fa/settings/integration?pkg=@clickhouse/client&utm_source=github&utm_medium=referral&page=upgrade-pr#auto-dep-upgrades)

MrUnknownDE closed this issue

2026-04-05 16:25:47 +02:00

Sign in to join this conversation.

Branches Tags

master

release

snyk-fix-0aa85871afc5c8eee83a20407bd9e063

new-dash

probe-runner

better-logs

merge-ui

api-ref-refactor

safe-vm

tf-demo

dash-chunk

mult-slack

episode-resolve

feat/homepage-seo-v2

seo/compare-pages-homepage-optimize

tf-sets

vite-build

alert-grouping-product

oneuptime-fix-exception-5f43cb12

deprecate-telemetry-service

oneuptime-fix-exception-b77cfaf1

workflow-ui-update

chore/bump-version-9.2.5-1764859493

chore/bump-version-9.2.5-1764857051

state-change

postmortem

chore/bump-version-9.1.3-1764685359

pricing-compare

use-cases

dashboard-logs

incident-declared-at

agent-lib

scim-patch-fix

files-notes

dropdown-labels

revoke-token

refresh-sessions

oneuptime-ssl

telemetry-attr

nativewind

oneuptime-mobile-app

timepkr

cert-kube

new-log-ui

ms-temas-bot

span-improve

teams-integration

cert-manager

final-ms-teams

new-markdown

scim-update

probe-proxy-impl

probe-proxy-url

fb-whatsapp

whatsapp-integration

ms-teams-conn

copilot-plus

vs-code-copilot

ms-teams

server-bucket-size

sp-scim

scim

probe-queue

queue-work

keda-autoscaler

otel-keda

telemetry-queue

otel-queue

mobile-responsive

add-state-to-title

file-tf

snyk-fix-21d325191a83f6e495f02680309be6df

new-terraform-provider

tf-provider

msp-server

announcement-templates

optmize-esbuild

ms-teams-workspace-integration

run-as-non-root

fix/team-member-service-test-error

feature/msteams-integration-backend

optmize-dash

split-dashboard

feature/responsive-navbar

feat/mobile-responsive-sidemenu

mobile-navbar

mobile-ui

fix-recurring-events

fix-monitor-test

snyk-fix-6d5b446d98eb30ad7cc48664f26e8dd3

snyk-fix-5f2a25c13d925a6df331a8db1b4b6bc3

snyk-fix-82cf608c1e34aadeec1e40be2dd7692c

snyk-fix-28fb72b74f8e210b21994c9d4a749db4

snyk-fix-9dd32ce4170d36a0032a14eca7bcc974

snyk-fix-33cfbfb6119028a909c55ae0b6f42134

snyk-fix-0d6c626395070c0bf0647893fd4ad82c

telemetry-decorator

snyk-fix-9dcd00f3db77cda7a8a956ad4c744638

snyk-fix-39e89b36dc9e401d2beb27cf134cb8f8

manual-workflow

sp-api

snyk-fix-476babcac00c78674ae2231bc91de4f0

snyk-fix-aba76b601f35a212295c529b373457fa

slack-app

otel-collector-queue-size

scheduled-maintenance-feed

add-proxy-to-server-monitor

snyk-fix-129563dbc737d32bc6bb8e3311b8bb86

metrics-monitor

snyk-fix-b3faaf7e1b0131c254a19d461fdfa12f

snyk-fix-49a541156a8e299f9158ecc2e1ce3e4e

snyk-fix-6fed1c2110e88e596893df3351740515

snyk-fix-7f3c8e70773dfe11ea8caed8e34b2573

snyk-fix-2643b617b033d0cbf19291b6ad7776a4

snyk-fix-1219e1241120fcf13feb7bc0b54e18e3

merge-monitor-metrics

dashboarding

oneuptime-copilot-oneuptime-copilot-improve-comments-ZlPvy

oneuptime-copilot-oneuptime-copilot-improve-comments-vThJD

oneuptime-copilot-oneuptime-copilot-improve-comments-veTFM

snyk-fix-1230088cdc5e6714c07c4043881095db

sp-custom-cert

realtime

snyk-fix-2267fc7afa5dd1aadc03bda66d835a26

snyk-fix-82eb97bf3553f75fcdec629b2375d091

snyk-fix-0ff1eeedd26324c34c4b6446c78d93ab

snyk-fix-7a5cb77d5e30b278d6086cc6ec7563dd

snyk-fix-80a68103cb676782e141f18725deae71

oneuptime-copilot-oneuptime-copilot-add-spans-Dcefh

oneuptime-copilot-oneuptime-copilot-improve-comments-YRJKG

oneuptime-copilot-oneuptime-copilot-improve-comments-PBqVE

snyk-fix-6390d5be9d2dcbe507da6d19b87bb581

oneuptime-copilot-oneuptime-copilot-improve-comments-dnfTZ

copilot-main

error-tracking

snyk-fix-616369b0f1423d8113422a2b0ea1798a

snyk-fix-ecde2433ac879fc83fcb7fbaef849ca2

snyk-fix-1436684cb4b974b4b38ec0de7c27678b

snyk-fix-929b1416ccb03655ff400075fc126a5d

merge-dir

snyk-upgrade-bc55cc4a3bed3c919d5253c5ccb89569

oneuptime-copilot-oneuptime-copilot-improve-comments-NXaNT

oneuptime-copilot-oneuptime-copilot-improve-comments-MhFUX

oneuptime-copilot-oneuptime-copilot-improve-comments-eHoNt

oneuptime-copilot-oneuptime-copilot-improve-comments-BWpyo

landing-page

clickhouse-optimization

attributes-cache

snyk-upgrade-b1d7fc785c4b347f9540423872d4f7eb

snyk-upgrade-b12f9d5ede2ce54b392c16e1398efc0d

snyk-upgrade-90863abe750274199042129d216ec458

snyk-upgrade-24742a40cc66c0ff20127c49b31c5b92

status-page-reports

monitor-reports

oneuptime-app-oneuptime-app-improve-comments-wPkHZ

oneuptime-app-oneuptime-app-improve-comments-zheFq

oneuptime-app-oneuptime-app-improve-comments-yGblU

oneuptime-app-oneuptime-app-improve-comments-XvJyI

oneuptime-app-oneuptime-app-improve-comments-Iigpp

oneuptime-app-oneuptime-app-improve-comments-BLqEd

oneuptime-app-oneuptime-app-improve-comments-BSWXD

oneuptime-app-oneuptime-app-improve-comments-iDNIR

oneuptime-app-oneuptime-app-improve-comments-FPiCN

oneuptime-app-oneuptime-app-improve-comments-hfdRa

oneuptime-app-oneuptime-app-improve-comments-yEhKY

oneuptime-app-oneuptime-app-improve-comments-iOjcB

oneuptime-app-oneuptime-app-improve-comments-tFtyx

oneuptime-app-oneuptime-app-improve-comments-sBvxI

oneuptime-app-oneuptime-app-improve-comments-IXAhB

oneuptime-app-oneuptime-app-improve-comments-YtccK

oneuptime-app-oneuptime-app-improve-comments-QCnqA

oneuptime-app-oneuptime-app-improve-comments-NMjBi

oneuptime-app-oneuptime-app-improve-comments-lDSQP

oneuptime-app-oneuptime-app-improve-comments-YdAAE

oneuptime-app-oneuptime-app-improve-comments-JVpQw

oneuptime-app-oneuptime-app-improve-comments-DncIm

oneuptime-app-oneuptime-app-improve-comments-iBzpC

oneuptime-app-oneuptime-app-improve-comments-GkOnn

telemetry-backend

snyk-upgrade-818024a85e0cd5b743112ffb7f513123

snyk-upgrade-2f9ef5e24aa83032721fce51c3a0b0ca

oneuptime-app-oneuptime-app-refactor-code-nDOMw

oneuptime-app-oneuptime-app-refactor-code-nzaSs

oneuptime-app-oneuptime-app-refactor-code-TIxRv

oneuptime-app-oneuptime-app-refactor-code-Llyxi

oneuptime-app-oneuptime-app-refactor-code-lfIez

oneuptime-app-oneuptime-app-improve-comments-FLlpf

oneuptime-app-oneuptime-app-improve-comments-DaGfY

oneuptime-app-oneuptime-app-improve-comments-XaYkK

oneuptime-app-oneuptime-app-fix-grammar-and-spelling-CDFoR

ai-copilot-main

oneuptime-app-oneuptime-app-fix-grammar-and-spelling-hueYU

oneuptime-app-oneuptime-app-fix-grammar-and-spelling-HQfro

oneuptime-app-oneuptime-app-fix-grammar-and-spelling-JVpKF

oneuptime-app-oneuptime-app-fix-grammar-and-spelling-mSRcD

oneuptime-app-oneuptime-app-fix-grammar-and-spelling-NXSdG

oneuptime-app-oneuptime-app-fix-grammar-and-spelling-CYFVx

oneuptime-app-oneuptime-app-improve-comments-UsHIA

oneuptime-app-oneuptime-app-improve-comments-ZBFjb

oneuptime-app-oneuptime-app-improve-comments-ggYpS

oneuptime-app-oneuptime-app-improve-comments-YUFeh

eval-over-time

oneuptime-app-oneuptime-app-improve-comments-LkJYk

ai-main-70b

eslint

oneuptime-app-test-branch-11

oneuptime-app-test-branch-10

oneuptime-app-test-branch-7

oneuptime-app-test-branch-6

test-branch

nz/metric-detail

ext-postgres

perms-refactor

filter-refactor

group-by

greenlock-refactor

attributes

react-app

otel

snyk-upgrade-3677f1da0f20b9341d779856ea606cce

snyk-upgrade-324862099bddfa90e5e0e06eb934c162

renovate/node-16.x-lockfile

snyk-upgrade-ac717665d10b7db0ddb20de9bdaf435b

snyk-upgrade-7b7ea7a1c722d2b7f48e290063771f7b

snyk-upgrade-520b5a017b5e7985121ef90b57317068

renovate/stripe-react-stripe-js-1.x-lockfile

renovate/heroicons-react-2.x-lockfile

renovate/headlessui-react-1.x-lockfile

renovate/clickhouse-clickhouse-server-23.x

snyk-upgrade-8a1c1f353568dcbc7b2c3e4beec4a6b7

snyk-upgrade-affb0a1678b57ae5a6f3183f5e8d302d

renovate/vm2-3.x-lockfile

renovate/start-server-and-test-1.x-lockfile

renovate/chrome-launcher-0.x-lockfile

renovate/mikepenz-release-changelog-builder-action-3.x

renovate/npm-xmldom-vulnerability

monitor-groups

feature-flags

logging

admin-dashboard

update-deps

metered-plan

fix-status-page-refresh

owner-emails

owners-in-form

monitoring

fix-small-issues

single-docker-container

workflow-fix

staus-page-fix

slack_workflow

emails

fix/ping-monitor-ipv6

fix-typescript-errors

issue/160-add-setup-alert

143-fix-github-actions-jobs-dont-run-on-prs-from-forked-repo

142-github-actions-build-job-to-run-home-tests

147-form-containers

131-add-styling-for-account-in-topbar

chore/setup-sonar-cloud-#21

96-css-for-login-page

97-css-login-page

35-write-docker-build-job-for-helmchart

ts-migrate

monitor-box

feature-github-actions-3

feature-github-actions

feature-github-actions-2

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/oneuptime#1172