←
QuestDB2,581 posts
QuestDB avatar

QuestDB

@QuestDb

QuestDB (YC S20) is the fastest open source time series database. github.com/questdb/questdb

◷ Joined June 2019▧ 763 Photos and videos
QuestDB avatar
QuestDB@QuestDb·2h

We just shipped #QuestDB Enterprise 4.2.1. - Adaptive durability on clusters: crash-safe commits without the cost of sync - An ACL audit log, in SQL - Audit tables nobody can write to - Access control in SHOW CREATE DATABASE - Built on QuestDB 10.2 questdb.com/blog/questdb-ent…

Post attachment
QuestDB avatar
QuestDB@QuestDb·Nov 17

Since 10.2, a materialized view in #QuestDB does not have to aggregate. A passthrough view is a filtered copy of a table that stays current as rows arrive. EXPIRE ROWS for row-level retention: a condition, KEEP LATEST per key, or the top N per group. questdb.com/docs/concepts/ma…

Post attachment
QuestDB avatar
QuestDB@QuestDb·Nov 13

Deduplication in #QuestDB now has two modes. UPSERT is latest write wins, like ON CONFLICT DO UPDATE. SKIP is first write wins, like ON CONFLICT DO NOTHING. With at-least-once delivery, a replayed row is dropped and the original keeps its values. questdb.com/docs/concepts/de…

Post attachment
QuestDB avatar
QuestDB@QuestDb·Nov 12

There is now a dbt adapter for #QuestDB Enterprise. Models are written in QuestDB SQL, so SAMPLE BY, LATEST ON and ASOF JOIN work. Tables carry a designated timestamp, partitioning, symbols, dedup keys and a TTL, and a model can be a materialized view. questdb.com/docs/connect/con…

Post attachment
QuestDB avatar
QuestDB@QuestDb·Nov 11

New on our blog: a community post on measuring port congestion from free public AIS data, with NATS and #QuestDB. Five Go services on one VPS, QuestDB capped at 2 CPUs and 1 GB. LATEST ON for current vessel state, ASOF JOIN against each ship's ETA. questdb.com/blog/port-conges…

Post attachment
QuestDB avatar
QuestDB@QuestDb·Nov 10

We just shipped #QuestDB 10.2.0. - Power-loss durability, without the cost of full sync - GROUPING SETS, ROLLUP and CUBE - Passthrough materialized views, plus EXPIRE ROWS for row-level retention - DEDUP SKIP - One-row QWP messages ~18x faster questdb.com/blog/questdb-10-…

QuestDB avatar
QuestDB@QuestDb·Nov 9

We will have a stand at FOSDEM 2027 with OpenC3 COSMOS: Open Mission Control for Satellites. Saturday 30 January, Brussels. A working desktop CubeSat on the table. Send it commands, then query its telemetry in SQL with #QuestDB. fosdem.org/2027/

Post attachment
QuestDB avatar
QuestDB@QuestDb·Nov 6

New in the #QuestDB third-party integrations: adbcBridge, ADBC drivers for QuestDB. Our Arrow-over-QWP clients are C/C++, Rust, Python and Ruby. In C#, Java, Go or TypeScript, or on a QuestDB older than 10, the bridge gets you there. questdb.com/docs/integration…

Post attachment
QuestDB avatar
QuestDB@QuestDb·Nov 4

How fast can you replay a full trading day of US equities? New on the #QuestDB blog: 353,657,441 rows of top of book, in strict order, to a Python client in 129s at 2.74M rows/s. Across 8 connections: 32.5s, at the network link's limit. questdb.com/blog/questdb-mar…

Post attachment
Jeremy Morgan avatar
⟳ QuestDB retweeted
Jeremy Morgan@JeremyCMorgan·Nov 4

Oliver Parkinson parses iRacing .ibt files in Go with zero-copy mmap reads: about 31M ticks a second on an M4 Pro, then stores them in QuestDB on a Raspberry Pi 5. Self-hosted telemetry, MIT licensed. github.com/OJPARKINSON/Telem…

QuestDB avatar
QuestDB@QuestDb·Nov 3

There is now a Ruby client for #QuestDB, published as a gem. QWP over WebSocket, ingest rows, columns or Arrow, and queries that come back as Enumerable or straight into Polars. Blocks release their leases for you, and I/O runs without the GVL. questdb.com/docs/connect/cli…

Post attachment
QuestDB avatar
QuestDB@QuestDb·Oct 30

New #QuestDB client, and this one runs in the browser: QWP over WebSocket straight from the page, no backend service in between. Writes with batching and transactions, streaming SELECT results, and values as real JS types rather than JSON. questdb.com/docs/connect/cli…

Post attachment
QuestDB avatar
QuestDB@QuestDb·Oct 29

New on our blog: one table, three readers. #QuestDB stores older partitions as Parquet, SQL spans native and Parquet in one query, and Polars and DuckDB read the same files directly. Counts, volumes and highs match. VWAP agrees to 12 significant digits. questdb.com/blog/questdb-par…

Post attachment
QuestDB avatar
QuestDB@QuestDb·Oct 28

New in the #QuestDB docs: a governance and auditing guide. Every governance feature on one page, grouped by the question it answers, from access control and entitlement review to read auditing, lineage, retention and recovery. questdb.com/docs/security/go…

Post attachment