News for hackers. Stuff that matters.

A comment on PostgreSQL and UUID as Primary Key. Parent comment

Re:PostgreSQL and UUID as Primary Key by dmurray on Friday July 05, 2024 @07:23PM (#40886962)
Take all the Roman alphabet apart from the vowels - 21 characters and length 6 gives you 100 million possibilities which is plenty for most applications.

You can still get vaguely offensive sequences like FKNNGR or BLKCNT, but at some point you have to put this down not to your software being offensive or hateful but to humans finding patterns in randomness.

[ Parent | on HN ]
Re:PostgreSQL and UUID as Primary Key by thwarted on Friday July 05, 2024 @07:56PM (#40887120)
Use Crockford encoding to reduce this. It has readability and dictation considerations too which makes it idea for things humans will interface with.
[ Parent | on HN ]
Re:PostgreSQL and UUID as Primary Key by solidsnack9000 on Friday July 05, 2024 @09:56PM (#40887674)
Removing Y turns out to be important, as well...
[ Parent | on HN ]
Re:PostgreSQL and UUID as Primary Key by alex_duf on Saturday July 06, 2024 @03:09AM (#40888686)
It's still bothering me that Y is a vowel in french but not in English. Can we all agree on something for once?
[ Parent | on HN ]