Many applications have very different requirements for acceptable latencies / processing speed on different parts of the database. In time-series use cases most of your requests touch only the last day of data (‘hot’ data). Those queries should run very…
Jupyter Notebooks are an indispensable tool for sharing code between users in Python data science. For those unfamiliar with them, notebooks are documents that contain runnable code snippets mixed with documentation. They can invoke Python libraries for numerical processing, machine…
The ClickHouse Meetup at Cloudflare went great! It was a pleasure to see old friends and to meet new people enthusiastic about ClickHouse. Robert Hodges gave an intro talk about the ClickHouse execution model and how it contributes to rapid…
In our previous articles we demonstrated that ClickHouse — a general purpose analytics DB — can easily compete with specialized DBMSs for time series data: TimescaleDB and InfluxDB. There were, however, certain queries, pretty typical for time series, where ClickHouse…
Python is a force in the world of analytics due to powerful libraries like numpy along with a host of machine learning frameworks. ClickHouse is an increasingly popular store of data. As a Python data scientist you may wonder how…
Jan 25, 2019FunCorp is an international developer of entertaining Apps. The most popular is iFunny – a fun picture and GIF app that lets users to pass the time looking at memes, comics, funny pictures, cat GIFs, etc. Plus, users…
Altinity greets everybody with a New Year 2019! As a small gift to our friends we are happy to announce ClickHouse 18.14.19 Altinity Stable release. This is a last stable release in 2018, and funny enough that release minor version…
The year 2018 approaches the end. It has been a great year for ClickHouse and the ClickHouse community — a lot of events, new features and interesting projects. Now it is time to see what is next. ClickHouse development team…
Dec 4, 2018Our previous take on time series benchmarks attracted a lot of interest so we decided to dig into more details. We conducted 3 different ClickHouse scalability tests using the same TSBS dataset and benchmarking infrastructure. In this article…
Today’s world is fulfilled with a large amount of data coming from social media networks, smart devices, customer behaviors, call data records, billing information, and there are many other ways to produce a huge amount of data. For many telecom…
Altinity is happy to introduce ‘Altinity stable’ ClickHouse release marking. Altinity stable releases undergo additional testing from our side, we carefully monitored community feedback for any issues, as well as operated such releases in some heavy loaded production systems.That being…
Nov 15, 2018Once upon a time we spotted TSBS (https://github.com/timescale/tsbs) — Time Series Benchmark Suite, started by InfluxDB engineers and polished to perfection by TimescaleDB team. The suite allows to compare apples-to-apples when testing different databases: it is a framework…
