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
Quick encode & decode example:
SELECT sqids_encode(1, 2, 3); -- 86Rf07
SELECT sqids_decode('86Rf07'); -- {1,2,3}If IDs are too short, you can pad them to a certain length:
SELECT sqids_encode(10::smallint, 1, 2, 3); -- 86Rf07xd4z
SELECT sqids_decode(10::smallint, '86Rf07xd4z'); -- {1,2,3}Create unique IDs by shuffling the alphabet:
SELECT sqids_encode('k3G7QAe51FCsPW92uEOyq4Bg6Sp8YzVTmnU0liwDdHXLajZrfxNhobJIRcMvKt', 1, 2, 3); -- XRKUdQ
SELECT sqids_decode('k3G7QAe51FCsPW92uEOyq4Bg6Sp8YzVTmnU0liwDdHXLajZrfxNhobJIRcMvKt', 'XRKUdQ'); -- {1,2,3}Full documentation is at https://github.com/sqids/sqids-postgresql
If you're looking for the original Hashids PostgreSQL, you can find it here: https://github.com/iCyberon/pg_hashids
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