QuestDB (@QuestDb) header
QuestDB (@QuestDb) profile picture

QuestDB (YC S20) is the fastest open source time series database. https://teapawt.net/t.co/g0aLl6RpwB

New York / London
Joined June 2019
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…
35
Can a coding agent work out whether anyone is picking your desk off? New on the #QuestDB blog: 13 planted problems in a synthetic energy desk, agents running headless with read-only access. questdb.com/blog/agentic-tra…
1
156
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…
1
131
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…
118
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…
1
133
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-…
3
244
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/
1
1
2
152
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…
3
208
Several teams sharing one #QuestDB? Since Enterprise 4.1 a user only sees the objects it has a permission on. Pairs well with resource groups for shared clusters. questdb.com/docs/security/rb…
1
4
218
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…
1
100
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…
1
1
2
347
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…
2
1
98
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…
2
2
198
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…
7
7
194
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…
3
150
We just shipped #QuestDB Enterprise 4.1.0. - Resource groups: concurrency, CPU and memory limits per team - Audited views, every read recorded with its parameters - Users only see objects they have permission on - OIDC for services and managed identities - Built on QuestDB 10.1
3
4
174
We just shipped #QuestDB 10.1.0. - Merge-append partitions: late writes no longer rewrite the whole partition - SUBSAMPLE, find your most significant rows - Exact percentiles - Metrics history in sys.metrics - Parallel GROUP BY over joins - Faster LATEST ON and symbol filters
1
2
139
New on our blog: live Databento market data into #QuestDB Enterprise, end to end. A TOML config file for ingestion, order book analytics in SQL, a Web Console dashboard, and history ageing into Parquet in cold storage. 20,000 to 65,000 book updates a second at the open.🧵
1
1
3
137