Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

I'd like to see a SHA-2 or SHA-3 hash functions for SQL (even MD5)

Sat, Jan 4 2014 2:31 PM	Permanent Link
Barry	I'd like to see SQL hash functions in EDB. The most reliable right now are SHA-2 or SHA-3. Even the older less reliable MD5 would be ok. https://en.wikipedia.org/wiki/Secure_Hash_Algorithm MySQL has had them for quite some time. https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html Thanks, Barry
Sat, Jan 4 2014 7:19 PM	Permanent Link
Raul Team Elevate	Barry, I assume you mean natively since you can add them today using External Modules: http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=External_Modules For MD5 there is a module available here by S.Forbes: http://www.elevatesoft.com/forums?action=view&category=edb&id=edb_extensions&page=1&msg=95#95 Raul On 1/4/2014 2:31 PM, Barry wrote: > I'd like to see SQL hash functions in EDB. > The most reliable right now are SHA-2 or SHA-3. Even the older less reliable MD5 would be ok. > https://en.wikipedia.org/wiki/Secure_Hash_Algorithm > > MySQL has had them for quite some time. > https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html > > Thanks, > Barry >
Sun, Jan 5 2014 5:41 PM	Permanent Link
Barry	Raul >I assume you mean natively ...< Yes, natively. The 3rd party modules are fine for a workaround, but these hash functions are used a lot in other databases and should be part of the SQL language. Barry
Sun, Jan 5 2014 11:41 PM	Permanent Link
Raul Team Elevate	On 1/5/2014 5:41 PM, Barry wrote: > Yes, natively. The 3rd party modules are fine for a workaround, but these hash functions are used a lot in other databases and should be part of the SQL language. Tim would have comment on adding these natively. Just to clarify these are not really 3rd party but something you'd compile. External modules are very powerful way to extend the EDB and adding something like hash function is very straightforward. Raul
Mon, Jan 6 2014 12:53 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Barry, << Yes, natively. The 3rd party modules are fine for a workaround, but these hash functions are used a lot in other databases and should be part of the SQL language. >> I don't foresee myself adding functionality like this. It's too likely to become out-dated or need constant revisions for performance reasons, and is much more suited to being surfaced via external modules. Tim Young Elevate Software www.elevatesoft.com