I hope you count "stimulating our minds for either learning or imaginative purposes" as one of those outcomes because if you only count "work produced and kpis met" as an outcome then that sounds pretty bleak.
I believe the concern is if your primary key in the database is a serial number it might be exposed to users unless you do extra work to hide that ID from any external APIs and if there are any flaws in your authorization checks it can allow enumeration attacks exposing private or semi-private info. With UUIDs being virtually unguessable that makes it less of a concern.
There is a big difference though. Serial keys allow attackers to guess the rate at which data is being added.
UUID7 allows anyone to know the time of creation, but not how many records have been created (approximately) in a particular time frame. It leaks data about the record itself, but not about other records.
Far, far less than sequential Ids, and the random part is some pretty big values numerically... I mean there's billions of possible values for every MS on the generating server... you aren't going to practically "guess" at them.
It doesn’t help that much. Each tire of a fully loaded 18 wheeler carries 4.4x the weight of a typical car tire. 4.4 ^ 4 = 378x the damage per tire but there are also 4.5x the tires so your at 1,700x the damage.
That’s an oversimplification, but it doesn’t really matter if it’s 99.9% or 95% of the damage ware is still absolutely dominated by heavy vehicles.
And how many more SUVs go through that road? If there's a few hundred SUVs for every 18 wheeler, it's no longer negligible: it's 10 or 30% of the damage.
And it could be a lot more negligible, if that mostly drive alone, drove a car with half the weight.
I used 4,000lb for the car, a 2024 Chevrolet Suburban which is huge only clocks in at a 5,824 lbs. Load another 1,000lb for passengers etc and (6,824/4000) ^ 4 = 8.5x a car or 0.5% what I calculated for a full 18 wheeler.
Sure there’s more cars than 18 wheelers but 7,000lb is a rather extreme outlier in terms of SUV weight.
Well, my 7 seater has a kerb weight of 2780 lbs (and it's a hybrid, the petrol is lighter); fully loaded it's under 4400 lbs.
And it's probably heavier than most cars around here, because most cars are not 7 seaters, but 4/5 seat hatches.
US SUVs and pickup trucks wouldn't fit most parking lots around here (to tall, to wide to even get in), but somehow the problem is never the size/weight of cars people got used to drive.
reply