Generate random looking string from integer in Postgres

Question

I would like to convert integer ids in my database into something that is easier to remember.
Mapping function Int -> String should always return a unique 6 letter string for values in range, say, 1-10 000 000, with the same output for the same input. Example:

select old_id, gen_new_id(old_id)
from unnest(array[1, 2, 800, 289543, 1]) as foo(old_id)

could return

1, powaaa
2, iropwe
800, mnvfeq
289543, opasqa
1, powaaa

I could generate random string, check for uniqueness across the table and store as column in table, but it seems like someone before had to come up with better algorithmic approach.

Express the number in base 26 (a-z) or base 52 (a-zA-Z) instead of base 10. Adjust the range of numbers to ensure there are always six digits in the number. — rossum
– rossum, Commented Mar 1, 2022 at 14:48

dreptak · Accepted Answer · 2022-09-08 13:18:38Z

1

The technique I was looking for is named "ID obfuscating". There are various ways to accomplish the task in PostgresQL and here is a good article about it: https://czep.net/21/obfuscate.html

answered Sep 8, 2022 at 13:18

dreptak

3031 gold badge5 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Generate random looking string from integer in Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related