QuestDB

Did you know we are working on a new binary ingestion protocol in #QuestDB? QWP is designed for high throughput ingestion, and in preliminary tests we are seeing north of 15M rows per second. More details coming soon.

Post at questdb.com/blog/clickhous…

We published a benchmark comparing #QuestDB and ClickHouse. The post focuses on time-series workloads, covering ingestion throughput, query performance, and storage efficiency under realistic conditions. Full methodology and results in thread 👇

Complete SQL recipe at questdb.com/docs/cookbook/…

We added a gamma scalping signal to the #QuestDB cookbook. It builds a realized vol to spread ratio in SQL to estimate when rebalancing can cover transaction costs. High ratio helps, but not enough. You still need to overcome theta decay. Details in thread 👇

Full post at questdb.com/blog/sample-by…

Did you know the order of SAMPLE BY, window functions, and filters can have a big impact on performance? This post explains how query execution order works in #QuestDB and how to structure queries for better efficiency. Details in thread 👇

Link to the QuestDB Enterprise page questdb.com/enterprise/. To learn more about QuestDB Replication, see the docs at questdb.com/docs/high-avai…

We often get questions about high availability in #QuestDB. We added new architecture diagrams to show how it works: WAL replication through object storage, automatic primary failover, and multi-region replicas serving concurrent queries. Details in thread 👇

@mcadariu Thanks!

@QuestDb Congrats!

We just achieved Red Hat Partner Ready status for #QuestDB. This recognition confirms QuestDB’s compatibility with the Red Hat ecosystem and our commitment to enterprise-grade deployments. Details in thread 👇

Blog post at questdb.com/blog/time-seri…

The line between databases and lakehouses is getting blurry. This post explains how the #QuestDB architecture handles real-time ingestion, OLAP queries, and tiered storage with Parquet while keeping everything queryable with SQL. Details in thread 👇

View the Red Hat Partner Ready badge: credly.com/badges/bad1958…

SQL window functions are incredibly powerful, but they can be tricky the first time you encounter them. We put together a practical guide in #QuestDB to help you understand how they work and when to use them. Details in thread 👇

Did you know you can rotate rows into columns with PIVOT in #QuestDB? It lets you turn values from a column into separate columns with aggregates, making it easy to build wide tables for reporting and analytics directly in SQL. Details in thread 👇

We introduced HORIZON JOIN in #QuestDB. ASOF JOIN gives a point-in-time match. WINDOW JOIN aggregates over a time range. HORIZON JOIN returns results at multiple time offsets before or after each row, letting you build curves that show how values evolve around events.

Agentic AI is changing how software gets built. Here an agent installs #QuestDB, ingests crypto orderbook data, and runs OHLC queries in seconds. Open standards like SQL, REST, and Parquet make it easy for agents to explore systems and generate working code quickly.