ASOF JOIN, WINDOW JOIN or HORIZON JOIN? If the sentence describing what you want has "during" in it, you want a window. If it has "earlier" or "later", you want a horizon.
New on the #QuestDB blog: a guide to the five time-series joins, with queries that run on the live demo.
481,132 EURUSD trades so far today. SUBSAMPLE sdt brings that to 3,300 rows, or to 46, depending on the error tolerance you give it.
It picks rows rather than computing them, so every point is a real trade with its original timestamp. New in #QuestDB.
Javier Ramirez is in the Data Engineering Theatre at Big Data LDN today, 15:20. How well an agent does data engineering depends less on the agent than on what the database gives them to work with.
What happens when you treat agents as first-class users of #QuestDB.
One table, many desks, each allowed to see only its own trades. In #QuestDB Enterprise that is a filtered view plus GRANT SELECT on the view.
Readers never need a permission on the base table, so the view is the only path to the rows.
The #QuestDB Kafka connector now speaks QWP. Offsets commit only after QuestDB confirms the rows, the connector pauses consumption when too many are waiting, and on Enterprise it follows the primary through a failover on its own.
