TimeStored Blog

kx kdb – 2019 in Review – Changes

Shakti

The biggest shakeup in the KDB world was Arthur Whitney, the founder of KX and creator of KDB selling his stake in KX and moving on to creating a new version of the K language called Shakti. “Shakti merges database, language, connectivity and stream processing into one powerful platform “.  So far it appears to overlap heavily with kdb functionality, adding further cryptographic features, while not yet supporting on-disk storage.

KDB Version 3.7 Changes:

• App Direct Mode – give users control over Intel Optane DC Persistent Memory.
• Multi-Threaded Primitive Operations
• Data at Rest Encryption.

KDB Version 3.6 Changes:

• Websocket – Improvements and bugfixes
• Speed Improvements
  • When attributes present use them more often.
• Improved Error Reporting
  • Broken or closed handles report their number
  • Fatal memory errors log a timestamp

FD/KX Products:

• Kx Dashboards – Expanded chart options available
• Enterprise Platform – SAML/GIT integration
• Kx Developer free to all Kx users, and Kx Analyst free to enterprise users.
• Kx Machine Learning Toolkit
• AxLibraries and Q Build Utilities

kx kdb – 2018 in Review – Changes

kdb Version 3.6 Changes:

• Enums and linked columns now use 64 bit indices
  • This is a disk-format change, i.e. newly saved data will NOT be backwards compatible.
  • 3.6 will be able to read data in the old format
• AnyMap – Mapped Nested Types
  • Ability to save unmappable compound objects with >2 billion elements
  • Mapped list elements can be of any type and are data remains mapped NOT copied to heap.
    • Symbols are automatically enumerated against a file with three ###s in the name.
• Deferred Response – -30!x Allows a deferred response to a sync query. In practice it is difficult to use correctly.
• New Functions:
  • .Q.hg – HTTP get allows retrieving web page as a list of strings.
  • .Q.dtps/.Q.dpfts added to allow specifying the enum domain
  • .Q.sha1 – SHA-1 encode text
  • .Q.ts – Allows timing a function call similar to apply “.”.
  • xcol – Now supports dictionary to remap column names
  • -27! to allow formatting similar to .Q.d
  • .j.jd – Allows specifying dictionary of options when calling json serialization.
  • .Q.btoa – Base 64 encode
  • .Q.hp – HTTP Post – .Q.hp[url;mimeType;query]
• Performance Improvements on
  • grouping
  • filtering
  • particularly when attributes present
• SSL – Improvements and bugfixes
• WebSockets – Improvements and bugfixes