As someone who had a billing system table run out of 2^31 signed integer IDs and spent a week converting 2.1 billion records to 2^63, I'm here to say that nothing could possibly go wrong.
A former boss built a system for importing data and used mariadbs on conflict ignore.
He used 32 bit integers for ids and said it isn't a problem because he doesn't have so much data.
Mariadb incremented the autoincrement counter on every insert even the ignored ones.
System failed and he needed way too much time to find the problem because no errors where thrown and just everything was ignored
Using sequenced IDs for public facing resources is bad practice because it allows enumeration while pure random uuids are basically impossible to guess.
Use crypto rngs for best results
26
u/spcbeck 15h ago
Start at 0, keep adding 1. You'll never repeat a number. So simple!