←back to thread

Why AO3 Was Down

(www.reddit.com)
151 points danso | 2 comments | 05 Jul 25 02:23 UTC | HN request time: 0s | source
Show context
notorandit ◴[05 Jul 25 05:15 UTC] No.44470235[source]▶
> typical database column

Typical for 70s and 80s.

Honestly, designing a 21st century database is a different thing if compared to back then.

You can use 128 bit integers, provided that you really want to use integers. And maybe you put a timestamp along.

replies(6): >>44470283 #>>44470544 #>>44470799 #>>44470940 #>>44471428 #>>44471545 #
throwawaysoxjje ◴[05 Jul 25 07:34 UTC] No.44470799[source]▶
Nah I made the same mistake back in 2009 for a system that was storing behavior events during malware analysis.

You don’t often expect to have two billion of something until you do.

replies(1): >>44470939 #
1. 9dev ◴[05 Jul 25 08:02 UTC] No.44470939[source]▶
It's not like those two billion things just materialise in your database, right? Someone must have watched that graph climb, and climb, and climb, approaching the limit.
replies(1): >>44470996 #
2. detaro ◴[05 Jul 25 08:11 UTC] No.44470996[source]▶
If they have that graph and remember the limit they choose 15 years ago... It's not something you think about constantly running a mostly stable code-wise site.