What is the best way to generate unique ID for entries?

I need a unique ID set for each new row. Is it better to use something like short-key plugin to replace the primary key. Or should I just make a unique key for every column and check for duplicates?

silentworks•10/24/22, 5:42 PM

You can use uuid datatype and uuid_generate_v4()uuid_generate_v4() as the default value. But its probably better you mention your use case to better get help.

Ssilentworks You can use uuid datatype and `uuid_generate_v4()` as the default value. But its...

CoryOP•10/24/22, 7:27 PM

I found that PG_HASHID would be perfect for my use case

CoryOP•10/24/22, 7:27 PM

but I am sort of lost on how to have it run when new rows are created

silentworks•10/24/22, 9:27 PM

Is it this one? https://hashids.org/postgresql/

Hashids

Generate short obfuscated strings from integers. Use in url shorteners or as unique ids.

silentworks•10/24/22, 9:29 PM

You can do a before insert to generate the hash_id and add it as a column

silentworks•10/24/22, 9:34 PM

CREATE OR REPLACE FUNCTION hash_col() RETURNS trigger AS $$
BEGIN
        NEW.hash = hash_encode(NEW.id, 'this is my salt', 10);
        RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER some_table_hash_update 
BEFORE INSERT ON some_table 
FOR EACH ROW EXECUTE PROCEDURE hash_col();

CREATE OR REPLACE FUNCTION hash_col() RETURNS trigger AS $$
BEGIN
        NEW.hash = hash_encode(NEW.id, 'this is my salt', 10);
        RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER some_table_hash_update 
BEFORE INSERT ON some_table 
FOR EACH ROW EXECUTE PROCEDURE hash_col();

CoryOP•10/25/22, 1:03 AM

yes that's it!

Ssilentworks Is it this one? https://hashids.org/postgresql/

CoryOP•10/25/22, 1:21 AM

Thank you so much! Thats perfect

CREATE OR REPLACE FUNCTION hash_col() RETURNS trigger AS $$ BEGIN NEW.hash = hash_encode(NEW.id, 'this is my salt', 10); RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER some_table_hash_update BEFORE INSERT ON some_table FOR EACH ROW EXECUTE PROCEDURE hash_col();

What is the best way to generate unique ID for entries?

Similar Threads

Similar Threads

Similar Threads