ALT QuestDB Enterprise banner titled 'Trading hours, in the filter.', tagged Enterprise · Exchange calendars, with a pill reading #XNYS, a MIC code, not a holiday list. Body text reads: no holiday list, no session window, no timezone math. A MIC code in the time filter, and daylight saving comes for free. On the right, under the heading 'january on the nyse, sessions only,' a code card shows: WHERE ts IN '[2026-01]#XNYS'. Below, under 'one filter, any market,' three rows read: XNYS, no weekends, no holidays, real early closes; XHKG, both sessions, lunch break taken out; and your own, custom sessions, overrides, internal codes. A footnote reads: NYSE, 14:30 to 21:00 UTC in winter, 13:30 to 20:00 in summer. Same filter.

ALT QuestDB banner titled 'Compression, without ZFS.', tagged Storage · Parquet, with a pill reading Parquet partitions, open source and Enterprise. Body text reads: Parquet partitions are compressed in the format itself and stay fully queryable. On Enterprise, storage policies convert them by age. On the right, under the heading 'where compression happens,' two stacks compare before and now. Before shows three layers: QuestDB table in native format, ZFS compression struck through as a filesystem layer, and disk. Now shows a pink QuestDB table box labeled Parquet partitions, compressed, sitting directly on disk. Below, a panel headed 'codec, set in server.conf' lists LZ4_RAW as the default, plus zstd, gzip, snappy and brotli. A footnote reads: ALTER TABLE converts existing partitions you point it at.

ALT QuestDB Enterprise banner titled 'Service accounts, not your login.', tagged Enterprise · Service accounts, with a pill reading no groups, nothing inherited. Body text reads: a principal for an application, not a person. Every permission it holds was granted to it explicitly, so the grants are the blast radius. On the right, under the heading 'one table, one protocol, nothing else,' a code card shows: CREATE SERVICE ACCOUNT ingest_app WITH PASSWORD 'pwd'; GRANT HTTP TO ingest_app; GRANT INSERT ON sensor_data TO ingest_app; ALTER SERVICE ACCOUNT ingest_app CREATE TOKEN TYPE JWK; Below, under 'memory limits too,' a card reads: SET MEMORY LIMIT 1G, per account, not inherited. A footnote reads: no personal login in the pipeline.

ALT A QuestDB Web Console notebook titled Energy Trading Dashboard in grid layout, with five variables and a 5 second refresh. Nine panels: intraday trading PnL by book in USD with drawdown, front months live with red and green change columns, a PnL and position blotter, limit utilisation now and intraday, the live curve versus last settlement, book as known versus as restated, a PnL explain bar chart across market move, new trades, late bookings, amendments and cancellations, and 1-minute OHLC candles on the front month. Instruments include Brent, WTI, TTF, NBP, JKM, gasoil, EUA, UKA and UK power across the carbon, crude, EU gas, LNG, products and UK power books.

ALT QuestDB banner titled 'Forgot a WHERE? Cancel it.', tagged SQL · Cancel query, with a pill reading SELECT * FROM trades, no WHERE. Body text reads: a runaway scan pulls every historical partition into the page cache and evicts the recent data your live queries need. On the right, under the heading 'no id needed, match on the text,' a code card shows: SELECT cancel_query(query_id) FROM query_activity() WHERE query LIKE 'SELECT * FROM trades%'. Below, under 'or,' two cards read: Web Console, has a button; and CANCEL QUERY, with the id from query_activity(). A footnote reads: quick, not instant. You save everything it has not read yet.