Time Series Data Analytics with QuestDB and Cube

Andrey Pechkurov

Andrey Pechkurov

QuestDB Engineering

This blog post is the outcome of collaboration between Isha Terdal from Cube, Andrey Pechkurov from QuestDB and Yitaek Hwang, a QuestDB contributor.

Time series data has now become a critical part of the data applications landscape. In this blog, we'll take a look at how QuestDB and Cube work together to provide a time series data pipeline that is fast, consistent, and reliable.

Demo of live crypto data streamed with QuestDB and Grafana

Nicolas Hourcard

Nicolas Hourcard

QuestDB Team

At QuestDB we are all about performance. To showcase querying capabilities of the database we have been running a live demo of historical taxi rides in NYC with 1.6 billion rows [1] and a geospatial dataset that contains the locations of 250k unique ships [2] moving over time. You can analyze this dataset with SQL on our live instance and see how fast each query is processed. Today, we introduce a new dataset on the same demo instance: crypto market data ingested in real-time from the Coinbase Exchange. For ingestion, we use a convenient Python library Cryptofeed, a cryptocurrency exchange feed handler that supports QuestDB. And for visualization, we use Grafana to create interactive live charts, which refresh every 5 seconds.

QuestDB 6.2 January release, SQL JIT compiler

Andrey Pechkurov

Andrey Pechkurov

QuestDB Engineering

We've just published 6.2 and it includes a lot of changes, such as SQL JIT compiler, JDK 17 support, SQL and ILP improvements, settings to improve the memory footprint when used with Grafana, autocomplete in the Web Console, improved ILP stability, and more. Here's a roundup of changes that have just landed in the latest and greatest version!

How we built a SIMD JIT compiler for SQL in QuestDB

Andrey Pechkurov

Andrey Pechkurov

Co-authored by Eugene Lysyuchenko

QuestDB 6.2.0 brings a brand new JIT (Just-in-Time) compiler as a part of the SQL engine. The compiler aims to significantly improve execution times for queries with simple arithmetic expressions used to filter the data. It took us 11K lines of code, 250+ commits, and plenty of coffee to ship it, and we'd like to share the story with you.

Why I joined QuestDB as a core database engineer

Miguel Arregui

Miguel Arregui

QuestDB Team

This post was written by Miguel Arregui, who describes how he developed a passion for computing early on, his experience in research at CERN and the ESA, and eventually working at QuestDB. Miguel works as a software engineer in the core database team, improving upon the internals of the fastest open source time series database.

How we built inter-thread messaging from scratch

Vlad Ilyushchenko

Vlad Ilyushchenko

QuestDB Team

Inter-thread messaging is a fundamental part of any asynchronous system. It is the component responsible for the transportation of data between threads. Messaging forms the infrastructure, scaffolding multi-threaded applications, and just like real-world transport infrastructure, we want it to be inexpensive, fast, reliable, and clean. For QuestDB, we wrote our own messaging system, and this post is about how it works and how fast it is.