> > Stop trying to fix clever idiots from shooting themselves in the foot. The > standard result from these actions is to make life a pain for regular or > better programmers while only adding mild speed bumps to those clever > idiots. > > Things like a numeric type will only encourage the clever idiots to write > half broken code. >
Hello, just want to chip in. I use "INT UNSIGNED" for the MySQL primary keys since ages, because negative primary keys make no sense. Well, mostly ID's for the records actually can stay strings, but I will have to remember to use a string type hint every time I pass a record ID. I expect a lot of times to forget that and write int... I was bitten a few times by the limits of 32 bit integer sizes too (moved to a 64 bit server that time), but there are also unsigned 64 bit integers that can and will be used in math operations and passed around. And we don't have the "unsigned int". Okay, we have GMP. I will have to use it. But let me just ask - if I work with a DB handling 64 bit integers (all I know handle them) or use a DECIMAL field - automaticly use GMP then? Oh gosh.... Arvids.
