PeachQ 0.92: partitioned databases load
The largest gap we listed at 0.91 was on-disk storage: partitioned and segmented
databases did not load. In PeachQ 0.92 they do. \l mounts a partitioned or
segmented database, and .Q.dpft and its relatives write partitions in the
kdb+ layout.
What's new
- Partitioned and segmented databases:
\lmounts them and qSQL queries them, with the virtual columnsdateandi..Q.dpft,.Q.dpfts,.Q.dpt,.Q.dptsand.Q.hdpfwrite partitions, and.Q.bv,.Q.vpand.Q.chkhandle tables missing from a partition. - Splayed tables written in place:
upsertandinserton a splay directory append to each column file, all or none, and@[`:dir/;`col;…]amends one column on disk. - S3 and compressed containers:
s3://reads natively with AWS SigV4 signing and per-bucket.s3configuration. gzip, tar and zip files are recognised by their content and read through any transport. - TLS IPC:
hopentakestcps://addresses, and a failedhopennames its cause. - Restricted and blocked modes:
-u 1,-Uand-bfollow kdb+. - More q projects run: 14 of the 32 open-source projects on the compatibility page now fully work, up from 11 at 0.91, and 3 are broken, down from 6.
- q conformance reaches 92.1% (91.4% at the last 0.91 build), and Windows is at or above its target on all 1294 measured suites.