←back to thread

Why AO3 Was Down

(www.reddit.com)
151 points danso | 1 comments | 05 Jul 25 02:23 UTC | HN request time: 0.263s | 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 #
shakna ◴[05 Jul 25 08:02 UTC] No.44470940[source]▶
Salesforce is a rather popular platform.

Its defaults are also either a 18-character ID, or a 32bit integer. So, unless you take the effort to actually fight Apex, you're gonna hit this problem sooner or later.

replies(1): >>44473040 #
quickthrowman ◴[05 Jul 25 14:29 UTC] No.44473040[source]▶
Doesn’t an 18-character alphanumeric ID give you 18^36 combinations? 1.54 x 10^45 seems like enough combinations.
replies(1): >>44474228 #
1. shakna ◴[05 Jul 25 17:33 UTC] No.44474228[source]▶
That's the point of the "or". You probably don't know which you're getting. It's what makes that particular design decision bite you more often.