←back to thread

Why AO3 Was Down

(www.reddit.com)
151 points danso | 3 comments | 05 Jul 25 02:23 UTC | HN request time: 0.427s | 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 #
1. Sharlin ◴[05 Jul 25 09:41 UTC] No.44471428[source]▶
One of the first things I internalized about databases was "just always use BIGSERIAL for primary keys". There are very few good reasons not to.
replies(2): >>44471889 #>>44472688 #
2. ◴[05 Jul 25 11:13 UTC] No.44471889[source]▶
3. looperhacks ◴[05 Jul 25 13:31 UTC] No.44472688[source]▶
Maybe don't: https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_s...