Tag Archives: date

Facebook 在 MySQL 裡存時間的型態

在 MySQL at Facebook 的這邊說明提到了,Facebook 內部是使用 INT UNSIGNED 儲存時間: Which gets us to the point that it is no different than storing INT (hello 2038?) or UNSIGNED INT (a bit later) or BIGINT (till the end of time) and possibly … Continue reading

Posted in Computer, Database, Murmuring, MySQL, Software | Tagged , , , , , , , , , , , , , | Leave a comment

DVD 的發行時間差異導致盜版

由 MPAA 資助的報告顯示 DVD 的發行時間差異導致盜版:「DVD Release Delays Boost Piracy and Hurt Sales, Study Shows」,報告在「Windows of Opportunity: The Impact of Piracy and Delayed International Availability on DVD Sales」這邊可以看到。 用真實資料計算得到: "When we run our regressions on Spain and Italy alone, we observe … Continue reading

Posted in Movie, Murmuring, Recreation, Television | Tagged , , , , , , , | Leave a comment

前幾天 Twitter 伺服器時間大爆炸的原因...

前幾天 Twitter 伺服器的時間大爆炸,跳到 2015 年: I MITMed Twitter for Android's login to see why it was failing. The Twitter servers think it's 2015. Amazing. pic.twitter.com/iEu4rEUub9 — Ninji the [REDACTED] (@_Ninji) December 29, 2014 剛剛在 Hacker News Daily 上看到原因:「If you're using YYYY … Continue reading

Posted in Computer, Murmuring, Programming | Tagged , , , , , | Leave a comment