questdb

What it is and what it does

QuestDB is a Python client for the QuestDB time-series database. It implements the QuestDB Wire Protocol (QWP) over WebSocket for pooled connections and queries, plus legacy InfluxDB Line Protocol (ILP) transports over HTTP and TCP for row-level writes. The library supports two API layers: a deployment-level `questdb.connect()` for connection pools and bulk operations, and a connection-level `Sender` for individual row writes and lower-level transport control.

The package depends on numpy and uses compiled Cython and Rust extensions for performance. It requires Python 3.10 or later and supports modern platforms (macOS, Linux with glibc or musl, Windows). Authentication and TLS encryption are built in. The library is actively maintained and production-stable, with recent releases and no known security vulnerabilities.

Use it for:

• Stream individual metric rows (price ticks, sensor readings) to QuestDB via ILP/HTTP or ILP/TCP.
• Query a QuestDB deployment through a pooled connection without managing individual sockets.
• Send time-series data with optional TLS encryption and authentication in regulated or secure environments.
• Ingest numpy arrays as columns in QuestDB tables for scientific or financial data analysis.
• Write time-series data with symbol columns and timestamp precision control.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

A Python client library for QuestDB that sends data via the QuestDB Wire Protocol over WebSocket, HTTP, TCP, or UDP, with support for bulk ingestion and row-by-row writes, optional TLS encryption, and authentication.

Yes. The package is actively maintained, production-stable, permissively licensed, and has no known vulnerabilities. Install friction is moderate due to compiled wheels, but binaries are available for Python 3.10 and 3.11 across common platforms. Install it if you need to ingest data into QuestDB from Python with authenticated or encrypted connections.

Install

questdb on PyPI

pip install questdb

uv add questdb

poetry add questdb

Installing questdb

Before you install

Medium install friction due to compiled wheels (Cython and Rust). Wheels are available for Python 3.10 and 3.11 across macOS (x86_64 and ARM64), Linux (glibc and musl), and Windows. Active maintenance with a release 18 days old; repository shows recent commits and stable production status.

License in practice

Apache-2.0 permissive license allows commercial and private use with minimal restrictions; you must include a copy of the license and state significant changes, but no copyleft obligation applies.

Quickstart

pip install questdb

import questdb
from questdb import TimestampNanos

with questdb.connect('ws::addr=localhost:9000;') as db:
    with db.sender() as sender:
        sender.row('trades', symbols={'symbol': 'ETH-USD'}, columns={'price': 2615.54}, at=TimestampNanos.now())
        sender.flush(wait=True)

Requires QuestDB server running and accessible at the configured address; NumPy float64 arrays require QuestDB server >= 9.0.0.

Verify before relying

• Performance characteristics (throughput, latency) for different transport protocols and payload sizes.
• Behavior and error handling when QuestDB server is unavailable or connection drops mid-operation.
• Memory overhead and efficiency when ingesting very large datasets or streaming many rows.
• DataFrame ingestion API details and whether optional dataframe extra is required for bulk loads.

Package facts

Evidence: questdb-5.0.0-cp310-cp310-macosx_10_9_x86_64.whl; questdb-5.0.0-cp310-cp310-macosx_11_0_arm64.whl; questdb-5.0.0-cp310-cp310-manylinux_2_28_aarch64.whl; questdb-5.0.0-cp310-cp310-manylinux_2_28_x86_64.whl; questdb-5.0.0-cp310-cp310-musllinux_1_2_aarch64.whl; questdb-5.0.0-cp310-cp310-musllinux_1_2_x86_64.whl; questdb-5.0.0-cp310-cp310-win32.whl; questdb-5.0.0-cp310-cp310-win_amd64.whl; questdb-5.0.0-cp311-cp311-macosx_10_9_x86_64.whl; questdb-5.0.0-cp311-cp311-macosx_11_0_arm64.whl; questdb-5.0.0-cp311-cp311-manylinux_2_28_aarch64.whl; questdb-5.0.0-cp311-cp311-manylinux_2_28_x86_64.whl; questdb-5.0.0-cp311-cp311-musllinux_1_2_aarch64.whl; questdb-5.0.0-cp311-cp311-musllinux_1_2_x86_64.whl; questdb-5.0.0-cp311-cp311-win32.whl; questdb-5.0.0-cp311-cp311-win_amd64.whl; questdb-5.0.0-cp312-cp312-macosx_10_13_x86_64.whl; questdb-5.0.0-cp312-cp312-macosx_11_0_arm64.whl; questdb-5.0.0-cp312-cp312-manylinux_2_28_aarch64.whl; questdb-5.0.0-cp312-cp312-manylinux_2_28_x86_64.whl

Tags

More Libraries packages