TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

The Cost of GUIDs as Primary Keys (2002)

3 点作者 NathanOsullivan将近 3 年前

1 comment

NathanOsullivan将近 3 年前
It&#x27;s fascinating to me how some solutions in programming become &#x27;trendy&#x27; and get used everywhere, even when it may not be the right solution.<p>And then other solutions, like the &quot;COMB GUID&quot; from 2002 have stayed in relative obscurity despite neatly solving a small, concrete problem so many of us encounter.<p>The author&#x27;s 20 year old solution is amazingly similar to the recent UUIDv7 draft, right down to assigning 48 bits to the timestamp component; buried on page 6 of an otherwise unassuming article.<p>This should have been a revelation for everyone building database backed applications, but instead has either been outright ignored or reinvented in various ways over the years instead.<p>Makes me wonder what other solved-problems our profession has largely overlooked.