Upgrade from signed int to either signed or unsigned bigint on various values


1 Like

I tried reading this a few times, but I really have no clue what this is about

1 Like

Signed int is a datatype in programming (PHP in this case I guess) An int can only get so big before it reaches it’s max, and when it does and you add 1 more to it it becomes the minimum if it is a signed int (signed meaning with a sign in front of it , + or -).

A bigint can hold a much greater number, one that probably can’t possibly be reached in IC

1 Like

Same here :sweat_smile:

easy example of the range of numbers that can be stored in the database:

Signed Int: -2147483648 to 2147483647 (what IC uses now, and why steve cannot have any more population) (something like 2 Billion either side)

Unsigned Int: 0 to 4294967295 (only up to around 4 Billion)

Signed Bigint: -9223372036854775808 to 9223372036854775807 (something like 9 Quintilian either side)

Unsigned Bigint: 0 to 18446744073709551615 (up to something like 18 Quintilian)

using Bigint would mean that you can have a population of either 9 or 18 Quintilian depending on if you allow negative numbers or not (which for population you wouldn’t). This would be Bigint(8) (8 bytes (64 bits)).

The reason that 64 bit operating systems exist is for the same reason that steve has maxed pop, 32 bit (4 bytes (in mysql that’s int(4))) just wasn’t big enough.

The same problem applies to the market in infinitum. You can’t sell/buy more than that 2.1bill number.

It does beg the question… if originally it was inconceivable to reach the limit of a signed int, then why is it possible now?

1 Like

Infinitum stretches the limits. It was only a matter of time before we hit this. We saw this before in the old dev server too with the 1-minute ticks.

This issue is a red herring though. We should take the opportunity to question whether or not hitting this cap should be possible in the first place, even in Infinitum.

Are you suggesting something along the line of exponentials? To make it increasingly Infinite time to reach 2.1bil? Not sure how market would use that but pop could just be a multiplier/new empire event (such as population starving from overcrowding or whatever)-

Edit 2.1bil looks small for pop, being only 3k planets with some LQ

Please don’t actually spend time on this meaningless issue Pie

1 Like

Nah, this isn’t on my radar right now.

It’s good that @MaceWindex reported it, and we should look at the underlying problems, but it isn’t a priority in the short term.

Naah, i’m not saying it’s important or anything. I just wanted it on record so that it is known. Better to know that something exists than to not know.