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

New York / London
Joined June 2019
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
33
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
2
101
Version 0.25 of the #QuestDB Kafka connector is out. No config changes needed. High cardinality tasks no longer hit a ceiling past a couple of million distinct symbols, idle connections can be kept alive with keepalive_interval_millis, and offset commits are quicker.
69
One of the SQL extensions you only find in #QuestDB: exchange calendars. Put a MIC code in the time filter and the query sees only real trading sessions. Weekends, holidays, early closes and daylight saving shifts are already in the schedule. questdb.com/docs/query/opera…
76
Still running #QuestDB on ZFS to compress your tables? You can drop that layer. Partitions convert to Parquet, compressed in the format itself, so compression happens inside the database rather than under it. And they stay fully queryable.
1
107
Applications should not log into your database as a person. In #QuestDB Enterprise a service account cannot belong to any group, so every permission it holds was granted explicitly. And you can ASSUME one to check exactly what it can do before shipping.
96
The #QuestDB Enterprise Kubernetes Operator docs are now live: EKS and AKS, migration, runbook, backup and restore, HA, API reference, known limitations. The operator holds no cloud identity and does no object store I/O at all. The database pods do all of it. 🧵
1
84
I built this energy trading dashboard without writing any SQL or touching a chart config. I just described it to my agent, which drove my #QuestDB Web Console over MCP. Nine panels, refresh from 250ms to 5s, and the agent runs under the same grants as my own login.
1
1
2
239
Scheduled backups in #QuestDB Enterprise: a cron expression in server.conf, a timezone, and reload_config() to pick it up without a restart. Only the first one is a full copy. After that it uploads the partitions that changed, compressed and throttled. questdb.com/docs/operations/…
1
1
125
Final day at @SpaceSoftSummit 🚀 Today at 1:15 PM MT we're drawing the winner of the LEGO® NASA Artemis Space Launch System at the QuestDB booth. Grab a ticket before then, and be there when we draw.
1
111
Forgot a WHERE and now a scan is lifting every historical partition, filling the page cache with data nobody asked for? The #QuestDB Web Console has a stop button. From a client, query_activity() gives you the query ID and CANCEL QUERY takes care of it. questdb.com/docs/query/sql/c…
1
110
The #QuestDB Web Console has editor settings now. What a text selection means when you hit run, whether formatting uppercases your keywords, and how wide result columns get before they stop growing. Anything else you want to be able to set in there?
100
New on the #QuestDB blog: how QWP gets a timestamp down to a single bit. Gorilla encoding stores how much the gap between rows changed rather than the timestamp. On a steady cadence that is zero every time. 4.9x on a burst of crypto trades, about 57x on a sampled series.
1
1
168
A blotter that flashes on every tick, candles building in front of you, top of book across four ECNs. All of it inside a #QuestDB notebook, refreshing as new data arrives, with colours driven by your own thresholds. Coming soon to the Web Console.
2
164
You can now run #QuestDB Enterprise on your own data for 30 days. The full build: replication, restart-free promotion, cold storage, access control. No limits on cores or nodes. No discovery call. Fill the form, the download link arrives within one business day.
2
113