News for hackers. Stuff that matters.
Re:PostgreSQL and UUID as Primary Key by lazide on Friday July 05, 2024 @11:55PM (#40888061)
By sitting in every parking lot, yes. Which requires physical presence. And hedge funds do indeed do it against some targets specifically as a leg up, and pay quite a bit of money to do so, presumably because it is worth it to them.

It certainly helped the Allies in the war, as previous intelligence had the rate of tank production much higher, and they were expending a lot of effort trying to exceed that previous false number.

Information is power, etc. etc.

As to if it's worth it for your SaaS to mitigate is up to you of course. I know I notice when things like Invoice #'s, my userID, customerID, etc. get shown, and it's a small number, or small delta. And that impacts my behavior. Does it also impact someone like a VC’s behavior? Or a competitor? Unknown.

But Hell, a bunch of people right now are probably launching SaaS's with NO-OP auth flows for documents or images, or with trivial external SQL injection flaws, which is a way bigger problem.

But it doesn't make the vulnerability/problem non-existent. Also feel free to use 16 bit auto incrementing primary keys for all your core tables if you want.

But if we're in an engineering discussion on the topic, knowledgeable folks will bring up the issues with it, because that is what they do. Most would feel it is their duty to do it, even.

Re:PostgreSQL and UUID as Primary Key by sgarland on Saturday July 06, 2024 @09:22AM (#40890311)
> But if we're in an engineering discussion on the topic, knowledgeable folks will bring up the issues with it, because that is what they do.

To be clear, this is not directed at you specifically, and I have no idea what your level of expertise is on anything.

In general, I’ve found HN commenters level of knowledge to be fairly bimodal. They’re either regurgitating things they read on a Medium blog, or they really know their shit.

Every time this topic comes up, people delightedly mention the German Tank Problem, but I have never, not once, seen anyone post an actual example of when a modern business got rekt by a competitor using knowledge gained from monotonic IDs.

Re: security viz. AuthZ, my stance is the same as SQL injection – it’s such a trivially easy problem to avoid that it shouldn’t be a consideration for harming the performance of the DB. (Not that SQL injection mitigations cause performance impacts; sorry, that analogy didn’t work well)

Re:PostgreSQL and UUID as Primary Key by melody_calling on Saturday July 06, 2024 @06:34PM (#40893861)
> Every time this topic comes up, people delightedly mention the German Tank Problem, but I have never, not once, seen anyone post an actual example of when a modern business got rekt by a competitor using knowledge gained from monotonic IDs.

At $previous_job (payments provider), the sales engineers would often spot merchants using sequential order IDs and mention it to the account managers.

Rekt? I guess not, but knowing what percentage of their business we processed was extremely valuable information when it came to renegotiate the contract.

Re:PostgreSQL and UUID as Primary Key by akira2501 on Saturday July 06, 2024 @01:45PM (#40891920)
> Which requires physical presence.

It requires physical access. Presence can be achieved by placing a dash camera or window camera strategically.

> and they were expending a lot of effort trying to exceed that previous false number.

The idea here being that if the allies just made more tanks than the axis they would automatically win? It's a lionized story of intelligence agency cleverness built squarely on the back of insane military "strategy."

Re:PostgreSQL and UUID as Primary Key by lazide on Saturday July 06, 2024 @10:40PM (#40894882)
Having a dashcam in this situation is only useful if that dashcam is physically there during the times you care about eh? Which is the physical presence part. With some applied statistics, that can be reduced (no need to sit in every parking lot 24/7 for instance), but there is definitely some sitting in parking lots involved.

No, it’s that they would set tank production quotas (and budgets) based on what they expect to need to produce to crush the enemy. Modulo whatever level of effectiveness had been apparent so far.

Which, for any given set of resources, would mean taking away resources from something else. Either manpower, steel, oil/gas, etc.

So overproducing tanks means fewer aircraft, or less artillery, etc.

Convincing the enemy you’re producing too much (or too little) of something to get them to waste their time and energy is a classic counter intelligence move.

WW2 was won largely with logistics and economic might + reasonable tactics. Applying the economic might effectively was part of that.

Re:PostgreSQL and UUID as Primary Key by akira2501 on Saturday July 06, 2024 @11:15PM (#40895018)
> Convincing the enemy you’re producing too much (or too little) of something to get them to waste their time and energy is a classic counter intelligence move.

So much so that it calls into question the entire idea of clandestine wartime intelligence having any exceptional value.

> WW2 was won largely with logistics and economic might + reasonable tactics.

I think people who say this simply haven't counted the dead.

> Applying the economic might effectively was part of that.

Which had essentially no bearing on our problems with Japan.

Re:PostgreSQL and UUID as Primary Key by lazide on Sunday July 07, 2024 @01:35AM (#40895487)
Uh huh. Populations of conscriptable soldiers or percent of the population killed totally didn’t matter? Those are part of the economic equation.

The war in the pacific was started by, and almost entirely dominated by, economic matters. Japan attacked the US because of US embargoes on fuel, for instance.

And the creation of the atom bomb (which ended it) was only possible due to the insane logistical feats of the US - and its excess economic capacity and resources. Which is why Germany failed, and the USSR only got one after getting the ‘ingredients list’ post war - once the wartime resources had been freed up.

War is hell, so don’t start them. But also, don’t think modern war isn’t won (or lost) based on logistics and economic factors. Which intelligence can help with.