The Curious Engineer

All blogs / Databases

QuestDB Blog

questdb.com/blog

Technical articles, tutorials and updates from the QuestDB team

DatabasesPerformance / optimizationJava / JVM

’20’21’22’23’24’25’26
Posts
236 from 2 Apr 2020 to 29 Oct 2026
Posting
weekly (74 in the last year)
Kind
company blog
Feed
https://questdb.com/rss.xml

2026 57

  1. One table, three readers: QuestDB, Polars and DuckDB on the same Parquet
  2. QuestDB Enterprise 4.1: governance for shared clusters
  3. QuestDB 10.1: fresher data, less I/O, and more analysis in SQL
  4. Ingesting live market data from Databento into QuestDB
  5. QuestDB's QWP under the hood: Gorilla timestamp compression
  6. Engineering
  7. Which time-series join? ASOF, WINDOW, HORIZON, LT or SPLICE
  8. Time-series
  9. DuckLake and QuestDB: the same Parquet, a different table format
  10. Parquet
  11. Parquet and Iceberg: how a table format builds on a file format
  12. QuestDB Enterprise 4.0: cold storage, QWP, and restart-free failover
  13. QWP: QuestDB's own binary wire protocol for ingestion and queries
  14. Streaming 500 million rows into Apache Arrow in 2.3 seconds
  15. Benchmark
  16. QuestDB 10.0: QWP, one binary streaming protocol for writes and Arrow reads
  17. Introducing QuestDB's new binary ingestion protocol: QWP
  18. Transaction Cost Analysis with QuestDB and Polars: VWAP, Slippage and Markout
  19. Tutorial
  20. HDFC Bank uses QuestDB for mule account detection across all major 25+ banking channels
  21. The Most Expensive Instruction Might Be… cmov
  22. Jvm
  23. The Best Time-Series Databases in 2026 (and How to Choose)
  24. The mask that compiles to nothing: how HotSpot's JIT learned to reason about bits
  25. Lies, Damn Lies and Database Benchmarks
  26. QuestDB Enterprise 3.3.1: storage policies, custom CA, and finer-grained access control
  27. Enterprise
  28. QuestDB 9.4.2: shareable queries, new aggregates, and a hardening pass
  29. Release
  30. Aeron and QuestDB: building open infrastructure for capital markets data
  31. Capital Markets
  32. One Trading runs a regulated 24/7 futures exchange on QuestDB
  33. Case Study
  34. QuestDB 9.4.0: Posting index, cross-column fill, and smarter Web Console
  35. How we made WINDOW JOIN parallel and vectorized
  36. Sparklines for traders: candlesticks and depth charts in SQL
  37. Code review turned a 3x speedup into 8.9x (off-heap HdrHistogram in QuestDB)
  38. SIX Group and Aquis Exchange run exchange-wide surveillance on QuestDB
  39. QuestDB 9.3.5: Lateral Joins, UNNEST & Window Stats
  40. Zero-Shot Time-Series Forecasting with QuestDB and Google's TimesFM
  41. Python
  42. QuestDB 9.3.4: Dynamic WINDOW JOIN & Parquet Bloom Filters
  43. Building a real-time multi-exchange charting platform with QuestDB
  44. Benchmark and comparison: QuestDB vs. ClickHouse
  45. From 3 Seconds to 38 Milliseconds: Why SAMPLE BY Order Matters
  46. QuestDB and the Modern Data Stack: Bridging Time Series, OLAP, and the Lakehouse
  47. QuestDB Enterprise 3.2.3: WAL cleaner, TLS metrics, and HORIZON JOIN
  48. QuestDB Wins Best Trading Analytics Platform at TradingTech Insight Awards Europe 2026
  49. QuestDB 9.3.3: HORIZON JOIN, twap(), and JIT on ARM64
  50. The Windows DLL loader lock: how a Rust thread can hang your JVM
  51. QuestDB 9.3.2: TICK, arg_max, and Exponential Moving Averages
  52. Building Real-Time Bollinger Bands Charts with SQL and Grafana
  53. 5 Best InfluxDB Alternatives (2026), Benchmarked
  54. Building the Market Depth Chart Grafana Never Made
  55. OKX relies on QuestDB for exchange-wide analytics
  56. How a 40-Line Fix Eliminated a 400x Performance Gap
  57. QuestDB 9.3: Window joins, views, PIVOT, and AI in the console

2025 45

  1. QuestDB 2025: Year in Review
  2. How to Build Market Depth Charts from Order Book Data with QuestDB
  3. How a Kernel Bug Froze My Machine: Debugging an Async-profiler Deadlock
  4. Multi-stream market data with Databento & Grafana
  5. Ingesting Financial Tick Data Using a Time-Series Database
  6. Time-Series Data Visualization with Apache Superset and QuestDB
  7. InfluxDB 3 Core Benchmarks: QuestDB Comparison
  8. Visualizing IoT Data with MQTT, QuestDB, and Grafana
  9. How to increase Grafana refresh rate frequency
  10. Fluid real-time dashboards with Grafana and QuestDB
  11. K-line candlestick charts with QuestDB & Grafana
  12. Mastering Grafana Map Markers and Geomaps
  13. Benchmark and comparison: QuestDB vs. InfluxDB v1/v2
  14. TimescaleDB vs QuestDB: 2026 Benchmark Results
  15. We finally benchmarked InfluxDB 3 OSS Core (Alpha)
  16. QuestDB 9.2: Exact arithmetic and smarter temporal joins
  17. Building an FX Liquidity Stress Analysis Workflow with QuestDB
  18. Reflexivity switched from InfluxDB to QuestDB
  19. The Mystery of the Phantom Quote in My CI Builds
  20. Order Book Imbalance Analysis with QuestDB Arrays
  21. QuestDB 9.1: Precision, Profiling, and Power
  22. QuestDB + Hacktoberfest 2025: Build Something That Lasts
  23. From Rust to Reality: The Hidden Journey of fetch_max
  24. Why Parquet Matters for Time Series and Financial Services
  25. Immutable images when embedding QuestDB Java library and noexec /tmp
  26. Highly Available Reads with QuestDB
  27. Leveraging LLMs to Interact with QuestDB Data
  28. When AI Optimizations Miss the Mark: A Case Study in Array Shape Calculation
  29. Copenhagen Atomics trusts QuestDB for real-time monitoring
  30. Ingesting L2 order book data with multidimensional arrays
  31. Order book analytics using the N-Dimensional array
  32. Real-Time Order Book and FX Market Data Dashboard
  33. Don't get stale! Fine-tuning ASOF JOIN with TOLERANCE in QuestDB
  34. QuestDB 9.0: Armed with Arrays
  35. Real-time analytics with an all-in-one system: Are we there yet?
  36. Streaming market data from Arroyo into QuestDB
  37. How to create a materialized view
  38. Energetech powers commodity trading strategies with QuestDB
  39. Why AI needs a database
  40. Design by Decision Fatigue
  41. XRP Ledger uses QuestDB for real-time blockchain analytics
  42. Automating Workflows in QuestDB: Bash scripts, Dagster, and Apache Airflow
  43. QuestDB 8.2.2 - New real-time monitoring, Table TTL and more
  44. Exploring high resolution foreign exchange (FX) data
  45. Build candlestick charts in minutes with QuestDB and React

2024 44

  1. Analyzing Bitcoin Options Data with QuestDB
  2. Scaling a trading bot with a time-series database
  3. How Airtel XStream Play uses QuestDB for real-time data
  4. Making a trading Gameboy: A pocket exchange and algo trading platform
  5. Revealing the stories in French real estate data
  6. Time-series and analytical databases walk into a bar
  7. Monitoring QuestDB with simple curl commands
  8. QuestDB and Raspberry Pi 5 benchmark, a pocket-sized powerhouse
  9. The future of fast databases: Lessons from a decade of QuestDB
  10. QuestDB 8.1.2 - Tabs & Balance
  11. QuestDB + Hacktoberfest 2024: Embrace the Season of Open Source!
  12. Combine Java and Rust Code Coverage in a Polyglot Project
  13. Virtual Global Trading leverages QuestDB for efficient energy data management
  14. Building a new vector based storage model
  15. Calibrating VWAP executions with QuestDB and Grafana
  16. The story of our SAMPLE BY enhancements
  17. A cloud engineer's first QuestDB Pull Request
  18. Tracking data changes (CDC) in QuestDB
  19. Unpacking time-series data for developers
  20. Debugging distributed database mysteries with Rust, packet capture and Polars
  21. QuestDB 8.1.0 - Parquet, smarter snapshots, improved SAMPLE BY, and more
  22. Why we opened a public Discourse forum (and you should too)
  23. QuestDB 8.0.3 - JSON support, smarter Web Console, and more
  24. Weather data visualization and forecasting with QuestDB, Kafka and Grafana
  25. ASOF Join — The "Do What I Mean" of the Database World
  26. Analyzing the beautiful charts and history behind ECB FX rates
  27. QuestDB 8.0: Major Release
  28. How to upgrade and benchmark a Raspberry Pi5
  29. Build your own resource monitor with QuestDB and Grafana
  30. Does "vpmovzxbd" Scare You? Here's Why it Doesn't Have To
  31. Create an ADS-B flight radar with QuestDB and a Raspberry Pi
  32. Build a temperature IoT sensor with Raspberry Pi Pico & QuestDB
  33. Create an IoT server with QuestDB and a Raspberry Pi
  34. Maximize your SQL efficiency: SELECT best practices
  35. 1BRC merykitty’s Magic SWAR: 8 Lines of Code Explained in 3,000 Words
  36. The Billion Row Challenge (1BRC): 71s → 1.7s
  37. Replace InfluxDB with QuestDB
  38. How crypto exchanges like Coinbase make money
  39. Tracking sea faring ships with AIS data and Grafana
  40. US Bitcoin ETFs: Understanding fair value
  41. Visualizing real-time NYC cab data and geodata
  42. Visualizing yield curves with Grafana and QuestDB
  43. NYC Taxi Data Analytics Dashboards
  44. Normalizing Grafana charts with window functions

2023 38

  1. OLAP vs Time-Series Databases: The SQL Perspective
  2. Tracking correlations across financial market assets
  3. Crypto Market Data Real-Time Dashboards
  4. Build your own custom trading dashboard
  5. Managing large lists of symbols with Grafana variables and QuestDB
  6. Moving average signals with QuestDB, Grafana and Coinbase
  7. Building a faster hash table for high performance SQL joins
  8. Solving duplicate data with performant deduplication
  9. QuestDB + Hacktoberfest 2023: 10 Years of Hacking
  10. Time-series IoT tracker using QuestDB, Node.js, and Grafana
  11. Our Website Source Is Now Private, A Cautionary Tale
  12. Leveraging Rust in our high-performance Java database
  13. Navigating Access Control Design: Pursuing Clarity and Simplicity
  14. QuestDB Enterprise: Role-based Access Control Walkthrough
  15. Concurrent Data Structure Design Walkthrough
  16. Fuzz Testing Is the Best Thing To Happen to Our Application Tests
  17. Max Open Files Limit on MacOS for the JVM
  18. Exploring Financial Tick Data with Jupyter Notebook and Pandas
  19. Optimizing the Optimizer: the Time-Series Benchmark Suite
  20. Investigating Linux Phantom Disk Reads
  21. Exploring Query Plan Scan Nodes with SQL EXPLAIN
  22. Integrate Apache Spark and QuestDB for Time-Series Analytics
  23. Comparing InfluxDB, TimescaleDB, and QuestDB Time-Series Databases
  24. Processing Time-Series Data with QuestDB and Apache Kafka
  25. The Inner Workings of Distributed Databases
  26. Migrating from Relational Databases to Time-series Databases
  27. MongoDB Time Series Benchmark and Review
  28. Loading Pandas DataFrames into QuestDB
  29. Running Databases on Kubernetes
  30. Unstable CI builds and open-source infrastructure
  31. QuestDB with Python, Pandas, and SQL in a Jupyter notebook
  32. UUID: Coordination-Free Unique Keys and Why They are Useful
  33. Data Integration for Time-Series: ETL, ELT, and CDC
  34. EXPLAIN Your SQL Query Plan
  35. Three SQL Keywords for Finding Missing Data
  36. Using QuestDB to collect infrastructure metrics
  37. Realtime crypto tracker with QuestDB Kafka Connector
  38. Change Data Capture with QuestDB and Debezium

2022 23

  1. Using Prometheus, Loki, and Grafana to monitor QuestDB in Kubernetes
  2. Listen to Your CPU - Full-table Scans Are Fast
  3. QuestDB 6.6.1 - Dynamic Commits
  4. SQL Extensions for Time Series Data in QuestDB - Part II
  5. QuestDB at Devoxx Belgium 2022
  6. Data Lifecycle with QuestDB
  7. QuestDB at Big Data LDN 2022
  8. DevStories #1: Time-series for sports prediction markets
  9. Join Hacktoberfest 2022 and contribute to QuestDB!
  10. Importing 300k rows/sec with io_uring
  11. Setting up Basic Authentication for QuestDB open source using Nginx
  12. Time Series Forecasting with TensorFlow and QuestDB
  13. 4Bn rows/sec query benchmark: Clickhouse vs QuestDB vs Timescale
  14. Enabling Machine Learning in QuestDB with MindsDB
  15. Demo of live crypto data streamed with QuestDB and Grafana
  16. Crypto Volume Profiles with QuestDB and Julia
  17. Crypto Data Visualization Dashboards with Grafana
  18. How to generate time-series data in QuestDB
  19. Calling on our community members to help us support Ukraine
  20. Order Flow Imbalance - A High Frequency Trading Signal
  21. QuestDB 6.2 January release, SQL JIT compiler
  22. How we built a SIMD JIT compiler for SQL in QuestDB
  23. Our two-year journey to raise $15m in venture capital

2021 17

  1. Analyzing Financial Time-Series Data via the Julia Language and QuestDB
  2. Why I joined QuestDB as a core database engineer
  3. How we built inter-thread messaging from scratch
  4. Real-time stock price dashboard using QuestDB, Python and Plotly
  5. Demo geospatial and timeseries queries on 250k unique devices
  6. Join Hacktoberfest 2021 and contribute to QuestDB!
  7. High frequency finance with Julia and QuestDB
  8. Launch a QuestDB droplet in 1-click via the DigitalOcean marketplace
  9. Using Telegraf and QuestDB to store metrics in a time series database
  10. How databases handle 10 million devices in high-cardinality benchmarks
  11. Streaming on-chain Ethereum data to QuestDB
  12. Automating ETL jobs on time series data with QuestDB on Google Cloud Platform
  13. Running QuestDB and Prometheus on GKE Autopilot
  14. Real-time stock price alerts using Python, Grafana and QuestDB
  15. Stream heart rate data into QuestDB via Google IoT Core
  16. A low-code bitcoin ticker built with QuestDB and n8n.io
  17. Monitoring the uptime of an application with Python, Nuxt.js and QuestDB

2020 12

  1. Building a garbage-free network stack for Kafka streams
  2. Community contribution from Alex Pelagenko improving our HTTP server
  3. Authentication for InfluxDB line protocol
  4. NYC taxi meter and options pricing
  5. Why performance matters in time-series data
  6. Fast IoT Stack with QuestDB, MQTT, and Telegraf
  7. Re-examining our approach to memory mapping
  8. My journey making QuestDB
  9. Demo launch on HackerNews retrospective
  10. Sending IoT sensor data from Arduino to QuestDB
  11. Things we learned about sums
  12. Aggregating billions of rows per second with SIMD