PeachQ 0.89: q tables in DuckDB, SQL beside qSQL, and Kafka
PeachQ 0.89 keeps q tables in DuckDB, where qSQL and SQL both query them. Kafka topics now stream straight into q tables, and q publishes back.
What's new
- External tables in DuckDB: qSQL on a DuckDB table runs inside DuckDB, and the same table answers SQL.
- SQL with q values as parameters, from a handle, an
s)line or a function. - Kafka: subscribe topics into q tables, keep bad messages, publish JSON or q IPC bytes.
- DuckDB 2.0, up from 1.5.5. On x86-64 it needs a CPU with AVX2; without
one, PeachQ reports
'duckdbwith the reason rather than crashing. .hashadds xxHash, rapidhash and MurmurHash3, agreeing with DuckDB's hash functions;.cryptoadds digests, HMAC and random bytes over the system's OpenSSL.- The API reference now covers every q library,
including
.kafka,.sqland.s. - From the 0.88 updates since our last post:
sum,avg,min,maxandreverseof small vectors are about 100x faster per call (select sum w by kon 7.8M rows drops from 21 s to 1.8 s), and HTTPS works on Windows with no setup, verifying against the system's root store. - q conformance reaches 89.0%, up from 88.0% at 0.88, and Windows matches Linux on all 1242 measured suites.