Altinity Blog

Join over 2,000 ClickHouse® developers who receive our content directly in their inbox.

Squeezing JuiceFS with ClickHouse (Part 2)
Blog

Squeezing JuiceFS with ClickHouse (Part 2): Bringing The Two Together

 • 
JuiceFS  is a POSIX-compatible filesystem over S3 storage that allows applications to store and share data without directly using S3 API. Since directly managing servers running ClickHouse and JuiceFS is complex, we use Kubernetes as our test environment. In Part 1, we...
Squeezing JuiceFS with ClickHouse (Part 1):
Blog

Squeezing JuiceFS with ClickHouse (Part 1): Setting Things Up in Kubernetes

 • 
JuiceFS is a POSIX-compatible filesystem which can be used over S3 object storage. It is a distributed and cloud-native file system with many features, including consistency, encryption in transit and at rest, BSD and POSIX file locks, and data compression. Every...
Into the Deep End: Learning SQL by Taking On Project Euler Puzzles (Part 2)
Blog

Into the Deep End: Learning SQL by Taking On Project Euler Puzzles (Part 2)

 • 
We continue learning SQL by solving math puzzles from Project Euler. This article shows how to extend ClickHouse capabilities with a user defined function (UDF) written in C++.
Into the Deep End: Learning SQL by Taking On Project Euler Puzzles (Part 1)
Blog

Into the Deep End: Learning SQL by Taking On Project Euler Puzzles (Part 1)

 • 
Solving math puzzles from Project Euler is a great way to learn about ClickHouse SQL, especially array functions. Math can also help you speed up queries by orders of magnitude.
Open Source Analytics Conference 2024
Blog

OSA Con 2024: Submit Your Proposals on Open Source Analytics Today!

 • 
Get ready! The Open Source Analytics Conference is making a triumphant return from November 19th to 21st, 2024! We're on the lookout for exciting proposals. Submit a talk and join the list of world-class speakers.
Blog

Learning from Rockset: Avoiding the Dangers of Lock-in to Cloud Database-as-a-Services

 • 
The news that the popular Rockset cloud service is going to be terminated is shocking. So the question arises – is there a way to keep benefits of DBaaS service providers but remove the downside of vendor lock-in, including risks...
Using Altinity’s Grafana ClickHouse® Plugin in Grafana Cloud
Blog

Using the Altinity Grafana Plugin for ClickHouse® in Grafana Cloud

 • 
The Altinity Grafana plugin for ClickHouse makes it easy to use the world's best open-source observability platform to visualize data from the world's best open-source analytics database. First released in 2017, the Altinity plugin is mature and the most popular,...
Webinars

Showing Beautiful ClickHouse® Data with the Altinity Grafana Plugin

 • 
The Altinity Grafana Plugin for ClickHouse® is the most popular plugin for creating dashboards on ClickHouse data with over 16M downloads. In this webinar, we’ll reveal how it works and how you can use it to create flexible, attractive dashboards...
S3 and ClickHouse part 3
Blog

ClickHouse® MergeTree on S3 – Keeping Storage Healthy and Future Work

 • 
The final article of our series on managing large datasets in ClickHouse MergeTree covers how to clean up orphan S3 files. We conclude with ideas for future improvements to S3 storage management.
Blog

ClickHouse® MergeTree on S3 – Administrative Best Practices

 • 
Our series on managing large datasets in ClickHouse MergeTree tables continues. In Part 2 we discuss best practices for S3 bucket configuration, storage policies, and MergeTree table administration.
Blog

ClickHouse® MergeTree on S3 – Intro and Architecture

 • 
ClickHouse datasets are getting big. Store MergeTree table data on S3 object storage to handle them economically and flexibly. Part 1 covers architecture and storage organization.
Webinars

Petabyte-Scale Data in Real-Time: ClickHouse®, S3 Object Storage, and Data Lakes

 • 
These days new ClickHouse applications start with petabyte-sized datasets and scale up from there. Fortunately, ClickHouse gives you open-source tools for real-time analytics on big data: MergeTree backed by object storage as well as reading on data lakes. We’ll start...