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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

Warn HN: Flickr Photo ID is about to overflow a 32 bit unsigned int

7 点作者 edd超过 15 年前
Flickr is just about to have photo id number 4294967295 which is otherwise the size of an unsigned 32 bit integer. If you have any code which typed to an 32 bit unsigned int or if your database column is of type unsigned int its probably time to change it. I predict (at a rate of 5000 uploads a minute taken from http://flickr.com/photos/? ) it should reach that number in the next 2 hours.<p>If you were wondering what image it was that caused the overflow it will appear hear: http://www.flickr.com/photo.gne?id=4294967296

1 comment

lann超过 15 年前
Even better: stop storing photo ids as numbers entirely. From Flickr's API docs: "These IDs should always be treated as opaque strings, rather than integers of any specific type."<p><a href="http://www.flickr.com/services/api/misc.overview.html" rel="nofollow">http://www.flickr.com/services/api/misc.overview.html</a>