Can we use ULIDs without a dedicated cluster?
We are looking for some solution between a Postgres serial and a long UUID. So ULIDs are a natural choice. I would use something like https://github.com/geckoboard/pgulid or https://github.com/pksunkara/pgx_ulid.
But without a dedicated cluster we cannot create types/functions. So is there another way to use ULID-like IDs?
I've seen that
But without a dedicated cluster we cannot create types/functions. So is there another way to use ULID-like IDs?
I've seen that
select ('rec_'::text || (xata_private.xid())::text) produces a similar result. Can we use this for the foreseeable future for our own ID fields?GitHub
Universally Unique Lexicographically Sortable Identifier (ULID) for PostgreSQL - geckoboard/pgulid