v.22.6New Feature

Add support for hashids from unsigned integers

Add support for calculating hashids from unsigned integers. #37013 (Michael Nutt).
Adds support for calculating Hashids from unsigned integers within ClickHouse, enabling compact and obfuscated encoding of numeric IDs.

Why it matters

This feature allows users to generate short, unique, non-sequential string representations of unsigned integer values, which helps in obfuscating database IDs, making URLs cleaner and safer to share, and preventing direct exposure of raw numeric identifiers.

How to use it

Use the new Hashids function by passing unsigned integer values to obtain their Hashid representation. For example, in SQL:

sql<br>SELECT hashids_encode(your_unsigned_int_column) FROM your_table<br>

This encodes the unsigned integers into Hashids strings according to the default or user-specified salt and configuration.