cryptographic
3 cryptographic types: 1 a sibling also accepts and reads alike, 2 that decompose into parts.
The 3 cryptographic types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Cryptographic Hash hash · VARCHAR | 5d41402abc4b2a76b9719d911017c592 | token_urlsafe |
JSON Web Token jwt · VARCHAR | eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c | — |
URL-Safe Base64 Token token_urlsafe · VARCHAR | SFMyNDI5STExOjEwMQ | — |
Which cryptographic type is it?
2 of 3 cryptographic types accept it, and read it alike.
| Type | Reads it as |
|---|---|
Cryptographic Hash hash | 5d41402abc4b2a76b9719d911017c592 |
URL-Safe Base64 Token token_urlsafe | 5d41402abc4b2a76b9719d911017c592 |
Use it
CLI · DuckDB
$ printf '%s\n' '5d41402abc4b2a76b9719d911017c592' 'aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d' > column.txt
$ finetype infer -f column.txt --mode column
SELECT ft_profile(v) FROM (VALUES ('5d41402abc4b2a76b9719d911017c592'), ('aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d')) t(v);After aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d, 2 types remain: hash, token_urlsafe.