A few weeks ago, I posted the story of how I started QuestDB on Hacker News. As it seems several people found the story interesting, I thought I would post it here.

Photo by Raoul Droog on Unsplash

We've been upping our SWAG game a lot lately, and we want to share it with you, the valuable members of our community! We want to give you the chance to show off your projects, show off your love for QuestDB, and to show just off!

We've had a UDP version of the InfluxDB Line Protocol (ILP) reader in QuestDB for quite some time, but we've had customers ask for a TCP version of it, so we delivered!

Using it, and configuring it, are relatively simple so don't expect this to be a long post but I'll walk you through the basics of how to set it up and use it. For an added bonus I'll show you how to migrate from using InfluxDB to using QuestDB with a less than a line of configuration.

What happens when you put a SQL database on the internet? It's probably not what you'd expect.

But we did it. And then we posted it to Hacker News.

A short tutorial for Querying data from QuestDB in a Jupyter Notebook.

As you can well imagine, I've been super busy in my hew job at QuestDB so this has taken me longer than I would have liked, but here we are. If you know me at all, you know that one of the first things I always do with new things is, well, connect things to them! So I immediately went to connect an IoT device to QuestDB to see how it went. Unsurprisingly, it went quite well. So here's how it went, from start to finish.

In the world of databases, benchmarking performance has always been the hottest topic. Who is faster for data ingestion and queries? About a month ago we announced a new release with SIMD aggregations on HackerNews and Reddit. Fast. But were those results numerically accurate?

SIMD instructions are specific CPU instruction sets for arithmetic calculations that use synthetic parallelisation.

Inter-thread messaging is a fundamental part of any asynchronous system. It is the component responsible for transportation of data between threads. Messaging forms the infrastructure, the scaffolding of multi-threaded application and just like real-world transport infrastructure we want it to be inexpensive, fast, reliable and clean.

For QuestDB we wrote our own messaging and this post is about how it works and how fast it is.

InfluxDB is the current market leader in time series, and we thought it would only be fair if we had a stab at their ingestion format called InfluxDB line protocol (“ILP”) to compare data ingestion performance between QuestDB and InfluxDB.