QuestDB

About QuestDB

A relational column-oriented database designed for real-time analytics on time series and event data. QuestDB uses SQL with time-series extensions and delivers exceptional ingestion performance, ideal for financial data, IoT, and application metrics.

Key Features

• 1High-performance time-series SQL database with columnar storage
• 21.6 million rows per second single-node ingestion via InfluxDB line protocol
• 3SQL extensions: SAMPLE BY, LATEST ON, and ASOF JOIN for time-series
• 4PostgreSQL wire protocol compatibility for standard Python drivers
• 5Built-in web console with SQL editor and charting

How Python Data Engineers Use QuestDB

Python data engineers use `psycopg2` (PostgreSQL-compatible) or the QuestDB Python client to ingest high-frequency sensor or financial time-series data. QuestDB's SAMPLE BY clause enables time-bucketed aggregations in a single SQL statement — engineers run these from Python to compute minute or hourly summaries of millisecond-granularity event streams.