Company
Date Published
Author
Christoph Wurm
Word count
1422
Language
English
Hacker News points
None

Summary

ClickHouse Cloud is now generally available and production ready, offering a managed service for users to focus on using ClickHouse rather than managing it. The new features include SOC 2 Type II compliance, uptime status and SLAs, availability in the AWS Marketplace, a lower priced development tier, an interactive SQL console, free ClickHouse Academy training, and support for PostgreSQL and MySQL engines, dictionaries, and SQL UDFs. A new Development tier is available with prices starting at $50 per month, making it affordable for non-production development, staging, and QA environments. Upcoming events include a 6-hour ClickHouse Workshop, a ClickHouse v22.12 Release Webinar, Meetups in Tel Aviv and Seattle, and the release of ClickHouse v22.11 with new features such as composite time intervals, recursive globs in paths, retry keeper during inserts, Hudi and DeltaLake table engines, readonly S3 disks, and object (JSON) inside types. Projections are a convenient alternative to materialized views for querying data from the same table, offering faster query performance by analyzing whether to use original or projection data. A holiday reading list is available with articles on various ClickHouse topics, including JIT compilation, user-defined functions, using dictionaries to accelerate queries, and more.