can anyone from the @ponder_sh team help me understand why the blocknumber that i get from events has a type of bigint (numeric78) couldn't we be just fine with using an int4 or int8?

@0xabhk @ponder_sh At the EVM level, block numbers are uint256 values. While most chains aren't even close to these limits, it is possible for an EVM block number to exceed JavaScript's Number.MAX_SAFE_INTEGER and the Postgres int8 (alias: bigint) maximum value.

@typedarray @ponder_sh it's technically possible but when you run the math, the probability is just zero 2 million years before we reach that edge case even if the blocktime is 10ms

@0xabhk @ponder_sh Excellent. 2 million years from now, there will be one fewer GitHub issue to triage.

@typedarray @ponder_sh i love (&respect) you for giving us bful ponder, but cmon man that is batshit crazy