User talk:Leucosticte/Inclumedia2

Fields
Inclupedia will import revisions from Wikipedia, but also have its own revisions. These will all be stored together in the revision table, whose primary key is rev_id. rev_id is an unsigned int, which means that it will max out at about 4.2 billion revisions. Currently, it's at 600 million. I have two options:
 * 1) Change it to an unsigned bigint, and start Inclupedia revision auto-incrementing at 1 trillion. That way, it will be centuries before there is a collision between Inclupedia revisions and imported Wikipedia revisions. The main problem is that I'd have to change not only the primary key but every field that stores those keys. E.g. the value of is also stored in, , etc. so those would all have to be changed to bigint as well.
 * 2) Keep it as an unsigned int, and start Inclupedia revision auto-incrementing at 3 billion. Eventually, there will be a horrific collision when Wikipedia reaches its 3 billionth revision sometime in the mid-21st century. It will be even worse than dealing with a Y2K problem because there will be no possible solution that doesn't have severe drawbacks that cripple functionality. Users and developers will curse my name.

Let the record show that I, Nathan Larson, chief software architect for Inclupedia, on 4 February 2014, after considering these possible consequences, decided, "Option #2 requires less work right now, so I guess I'll go with that one." Leucosticte (talk) 16:23, 4 February 2014 (UTC)