What is Sqids?
Sqids (pronounced "squids") is an open-source library that lets you generate short unique identifiers from numbers. These IDs are URL-safe, can encode several numbers, and do not contain common profanity words. Read more .
This is what they look like:
https://example.com/Lqj8a0
ClickHouse
ClickHouse provides built-in SQL functions for generating Sqids with default parameters. This functionality is available since ClickHouse v23.12 .
Quick encode & decode example:
SELECT sqidEncode(1, 2, 3); -- "86Rf07"
SELECT sqidDecode('86Rf07'); -- [1,2,3]
Use Cases
The main use of Sqids is purely visual. If you'd like to use IDs instead of numbers in your project, Sqids could be a good choice.
Good For
- Encoding primary keys If you're using a relational database
- Saving database lookups By encoding multiple objects
- Temporary login tokens Profanity-free and URL-safe
Not Good For
- Sensitive data This is not an encryption library
- User IDs Can reveal user count if anyone finds out the encoding alphabet
Features
- 🆔 Generate short IDs from non-negative numbers
- ✅ Easy encoding & decoding
- 🫣 Auto-generated IDs do not contain common profanity
- 🎲 Support for custom IDs through shuffled alphabet
- 🥳 45 integrations (84% using new design)
- 📌 Every version produces the same IDs
- 🍻 Small library with a permissive license