3 ms·
Related. Others? ULIDs and Primary Keys (2022) - https://news.ycombinator.com/item?id=40016413 https://news.ycombinator.com/item?id=40016413 - April 2024 (33 c
by dang 3y ago
Related. Others?
ULIDs and Primary Keys (2022) - https://news.ycombinator.com/item?id=40016413 https://news.ycombinator.com/item?id=40016413 - April 2024 (33 comments)
Ulid: Universally Unique Lexicographically Sortable Identifier - https://news.ycombinator.com/item?id=39878319 https://news.ycombinator.com/item?id=39878319 - March 2024 (6 comments)
ULID – Sortable Unique Identifier - https://news.ycombinator.com/item?id=34281969 https://news.ycombinator.com/item?id=34281969 - Jan 2023 (23 comments)
Using ULIDs at Incident.io - https://news.ycombinator.com/item?id=34230652 https://news.ycombinator.com/item?id=34230652 - Jan 2023 (1 comment)
Understanding UUIDs, ULIDs and string representations - https://news.ycombinator.com/item?id=29794186 https://news.ycombinator.com/item?id=29794186 - Jan 2022 (100 comments)
Going Deep on UUIDs and ULIDs - https://news.ycombinator.com/item?id=28948815 https://news.ycombinator.com/item?id=28948815 - Oct 2021 (2 comments)
Universally Unique Lexicographically Sortable Identifier - https://news.ycombinator.com/item?id=23160641 https://news.ycombinator.com/item?id=23160641 - May 2020 (2 comments)
ULID: Universally Unique Lexicographically Sortable Identifier - https://news.ycombinator.com/item?id=18768909 https://news.ycombinator.com/item?id=18768909 - Dec 2018 (129 comments)
Universally Unique Lexicographically Sortable Identifier in Go - https://news.ycombinator.com/item?id=13116308 https://news.ycombinator.com/item?id=13116308 - Dec 2016 (52 comments)
ULID: Universally Unique Lexicographically Sortable Identifier - https://news.ycombinator.com/item?id=12205158 https://news.ycombinator.com/item?id=12205158 - Aug 2016 (3 comments)
- s4i 3y agoThis topic resurfaces quite frequently, I've noticed. One thing I find quite frustrating is that most of the time this is discussed, people don't remember that exposing the creation time of a database row to the public is not acceptable in many systems. This makes v7 UUIDs, ULIDs, KSUIDs, etc. not appropriate for the task. In any application where the user is able to first create a draft of something (a video upload, a news article, a blog post, ...) and then release it some day in the future, we probably don't want the public to be aware of when the author created the initial draft. For instance, news websites often start drafting articles about people that are speculated to pass away soon. The problem also affects numeric/auto-incremented IDs. The "Finnish BBC" YLE uses numeric IDs in their news article URLs, making it possible to ballpark when the article was first started. Here's [1] an article about the death of former president Martti Ahtisaari from 2023/10/16 and here's [2] the next integer ID dated 2023/5/5 (5 months before). [1] https://yle.fi/a/74-20030335 https://yle.fi/a/74-20030335 [2] https://yle.fi/a/74-20030336 https://yle.fi/a/74-20030336