Are there any other native hashing methods such as SHA1/256 besides MD5 on kdb+?

Question

A quick search only yields this for MD5: http://code.kx.com/q/ref/strings/#md5

Are there any other ways to implement SHA1/SHA256 without writing it yourself?

Answer 1

There is nothing inbuilt in kdb for that. You need to use external libraries and write an extension (for ex in C) to use that.

Below link has implementation to use OpenSSL library (which has functions for SHA*) in KDB.

https://github.com/johnanthonyludlow/kdb/tree/master/QCrypt

Pdf in that link explains how to use that.

Answer 2

There is now a function for this in the .Q namespace: .Q.sha1 x returns the bytestream of the SHA-1 hash of the x, where x is a string.

You can use the .Q unreference card to view the documentation of this and other utility functions which are in the .Q namespace and not in the default namespace.