crypto.md

warning	title	excerpt	docs	extension	repo	extension_star_count	extension_star_count_pretty	extension_download_count	extension_download_count_pretty	image	layout
DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there	crypto	DuckDB Community Extensions Cryptographic hash functions and HMAC	extended_description hello_world `crypto` provides two functions: - `crypto_hash` applies cryptographically secure hash functions and returns the result as a hex encoded value. - `crypto_hmac` calculates the HMAC using a secret key and a specific hash function. The supported hash functions are: - `blake2b-512` - `keccak224` - `keccak256` - `keccak384` - `keccak512` - `md4` - `md5` - `sha1` - `sha2-224` - `sha2-256` - `sha2-384` - `sha2-512` - `sha3-224` - `sha3-256` - `sha3-384` - `sha3-512` -- Calculate the MD5 hash value of 'abcdef' SELECT crypto_hash('md5', 'abcdef'); ┌──────────────────────────────────┐ │ crypto_hash('md5', 'abcdef') │ │ varchar │ ├──────────────────────────────────┤ │ e80b5017098950fc58aad83c8c14978e │ └──────────────────────────────────┘ -- Calculate a HMAC SELECT crypto_hmac('sha2-256', 'secret key', 'secret message'); ┌──────────────────────────────────────────────────────────────────┐ │ crypto_hmac('sha2-256', 'secret key', 'secret message') │ │ varchar │ ├──────────────────────────────────────────────────────────────────┤ │ 2df792e08cefdc0ea9900c67c93cbe66b98231b829a5dccd3857a03baac35963 │ └──────────────────────────────────────────────────────────────────┘	build description language license maintainers name requires_toolchains version excluded_platforms cmake Cryptographic hash functions and HMAC C++ MIT rustyconover crypto rust 1.0.1 windows_amd64_rtools;windows_amd64_mingw	github ref rustyconover/duckdb-crypto-extension d73e47816d84e132019005411c3f2e5607326c2d	17	17	549	549	/images/community_extensions/social_preview/preview_community_extension_crypto.png	community_extension_doc

Installing and Loading

INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};

{% if page.docs.hello_world %}

Example

{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}

### Added Functions

<div class="extension_functions_table"></div>

| function_name | function_type |                                                   description                                                    | comment |                             examples                              |
|---------------|---------------|------------------------------------------------------------------------------------------------------------------|---------|-------------------------------------------------------------------|
| crypto_hash   | scalar        | Apply a cryptographic hash function specified as the first argument to the data supplied as the second argument. | NULL    | [SELECT crypto_hash('md5', 'test');]                              |
| crypto_hmac   | scalar        | Calculate a HMAC value                                                                                           | NULL    | [SELECT crypto_hmac('sha2-256', 'secret key', 'secret message');] |