为什么很多网站(MySQL)的查询参数都是很神秘的长整数? [英] Why are the query parameters for many websites(MySQL) very cryptic long integers?

问题描述

考虑这个 URL http://twitter.com/#!/sravfeyn/status/114003158891634689 ，为什么查询整数这么长，如果它是MySQL数据表中的主键，并且可以从零开始并自动递增?为什么要实现他/她的网站查询像这样神秘?有任何安全原因吗?

Consider this URL http://twitter.com/#!/sravfeyn/status/114003158891634689 , why is the query integer so long, if it's a primary key in MySQL data table, and can be started from zero and be auto-incremented? Why should one implement his/her website's queries cryptic like this?Any security reasons?

推荐答案

这不是出于安全原因，而是因为有太多推文使用自增 ID 字段已达到其最大无符号整数长度，并且可能会导致某些构建的应用程序崩溃推特.

It's not for security reasons, it's because there are so many tweets that using an auto increment ID field has reached it's maximum unsigned integer length and may crash some apps built for twitter.

状态 ID 现在由时间戳和其他详细信息组成.

The status ID's are now made up of timestamp and other details.

http://techcrunch.com/2009/06/12/all-hell-may-break-loose-on-twitter-in-2-hours/

http://engineering.twitter.com/2010/06/annoucing-雪花.html

这篇关于为什么很多网站(MySQL)的查询参数都是很神秘的长整数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！