ulid / spec

The canonical spec for ulid
GNU General Public License v3.0
9.73k stars 174 forks source link

GUID comparison #76

Open orefalo opened 1 year ago

orefalo commented 1 year ago

Greetings,

I am compiling a GUID summary sheet which tries to aggregate different dimensions with the intent to help engineers pick the right generator.

Would you be kind enough to help me validate the ULID column and point to any issues?

Thank you

image

mrkpatchaa commented 1 year ago

Following... Is this published somewhere @orefalo ? I recently discovered TSID while searching for the best solution for my primary keys (https://vladmihalcea.com/uuid-database-primary-key/). Might be worth adding.

orefalo commented 1 year ago

Hi, thanks for the reminder

you may find the new comparison table at this URL https://docs.google.com/spreadsheets/d/1ZsXBH0z7GOJv3N69QbEDKBZt8IeE0CfRI9vhihV4teo/edit?usp=sharing

Working on a Medium article, will publish this weekend or earlier and report back here.

orefalo commented 1 year ago

Done - https://medium.com/@orefalo_66733/globally-unique-identifier-a-fair-comparison-12b114c78ead Would appreciate your feedback if any

mrkpatchaa commented 1 year ago

This is very helpful thanks.

mwarkentin commented 1 year ago

Just came across a proposal for UUIDv7 which supports time-ordered values: https://datatracker.ietf.org/doc/html/draft-peabody-dispatch-new-uuid-format-04#name-uuid-version-7