Developers can now streamline the lifecycle of user-defined functions by deploying locally verified code directly to ClickHouse Cloud. ClickHouse Managed Postgres introduces enhanced monitoring capabilities, including raw Prometheus endpoints, server log inspection, and support for 29 additional configuration settings. The update also moves saved queries to general availability as HTTP Query API endpoints and integrates continuous BigQuery CDC replication through ClickPipes. Users can easily update in place or install the tool via pip, npm, cargo, and uv.
Key points
Command-line automation is simplified through uniform selectors, global organization sele…: Command-line automation is simplified through uniform selectors, global organization selection, and consistent JSON error reporting.
Cloud database security and monitoring are bolstered with IP allow rules, Prometheus endp…: Cloud database security and monitoring are bolstered with IP allow rules, Prometheus endpoints, and expanded Postgres configurations.
Operators can deploy or upgrade the utility across environments using distribution system…: Operators can deploy or upgrade the utility across environments using distribution systems such as pip, npm, cargo, and uv.
Sources checked by our analysis pipeline: 1
clickhousectl
(chctl
) is one CLI for ClickHouse and Postgres, both on your laptop and in ClickHouse Cloud.
Locally it installs and switches ClickHouse versions, runs project-scoped ClickHouse servers and Docker-backed
Postgres, and connects clients. In Cloud it covers the whole lifecycle of ClickHouse, ClickHouse Managed Postgres,
ClickPipes, ClickStack, backups, keys and members.
v0.4.0 left beta and added horizontal autoscaling and ClickPipe schema discovery. The highlights in v0.5.0:
- UDFs end-to-end: scaffold, test locally, then ship to Cloud with one command.
- ClickHouse Managed Postgres: metrics, server logs, slow-query patterns, read-only SQL over HTTP, and IP allow rules.
- A more consistent, automation-friendly CLI: uniform selectors,
--file
inputs, global org selection, JSON errors everywhere. Note that some of these are breaking; see the breaking changes. - Saved queries and Query API endpoints: saved queries are GA, and can be exposed as HTTP endpoints.
- BigQuery CDC ClickPipes: continuous replication from BigQuery, on an interval or a cron schedule.
- ClickStack comes to the CLI: dashboards, alerts, webhooks, saved searches, sources and roles.
Hackers sabotaged cooling systems across European retail chains, shutting down critical cooling units and prompting widespread inventory write-offs. Retail operations spanned seven nations, with Belgium and Luxembourg taking the brunt of the operational disruption. Financial damages are already mounting rapidly for individual grocers dealing with ruined merchandise.
The emerging software development enables individuals to interact directly with their devices through silent communication methods. By removing the need for audible speech, this system aims to enhance personal privacy while expanding hands-free accessibility in quiet or crowded environments. The approach represents an evolving shift in user interface design and human-computer interaction.
Development teams are actively scaling back feature sets to prioritize basic functions like FaceTime and lighting automation, leaving the product's release window in limbo between next year and 2028. Although the hardware has sat completed for about two years, critical software roadblocks are preventing the company from bringing its stationary tabletop assistant to market.