Acceleration at 1g lets you get to another galaxy in a single human lifetime (although earth will have been swallowed by the sun by the time you arrive). Relativity is pretty counterintuitive.

Perhaps I’m misremembering, but I feel sure that Siri was much better a decade ago than it is today. Basic voice commands that used to work are no longer recognised, or required you to unlock the phone in situations where hands free operation is the whole point of using a voice command.

There were certain commands that worked just fine. But they, in Apple's way, required you to "discover" what worked and what didn't with no hints, and then there were illogical gaps like "this grouping should have three obvious options, but you can only do one via Siri".

And then some of its misinterpretations were hilariously bad.

Even now, I get at a technical level that CarPlay and Siri might be separate "apps" (although CarPlay really seems like it should be a service), and as such, might have separate permissions but then you have the comical scenario of:

Being in your car, CarPlay is running and actively navigating you somewhere, and you press your steering wheel voice control button. "Give me directions to the nearest Starbucks" and Siri dutifully replies, "Sorry, I don't know where you are."

Neither does baking a cake mean you'll get to eat any - but it's clearly a better cake-obtaining strategy than deciding not to bake a cake.

The thing is that taking an interest in baking a cake doesn’t actually feed anyone. If you’re not going to spend your time baking (i.e. actually get involved in politics, to drop the metaphor), then what’s the point?

> Is it perfect? No. Neither is SQL parameterization against all injection attacks. But good is better than nothing.

What injection attack gets through SQL parameterization?

If you must generate nonsense with an LLM, at least proofread it before posting.

You doubt that it's a drug?

Or you doubt that internal messages describing IG as a drug are relevant to a lawsuit over social media addiction?

I think they might doubt that it will doom Meta

Correct, Meta won the war, just like loot boxes will keep existing, while proven to be designed to make you addicted.

People are just way to optimistic instead of realistic.

> People are just way to optimistic instead of realistic.

Apathetic is a more appropriate description. This is as optimistic as hoping to not contract lung cancer without ever bothering to quit smoking.

The hash technique for uniqueness isn’t supported for indexes because it doesn’t handle hash collisions. The authors proposed solution suffers the same problem- values which do not already exist in the table will sometimes be rejected because they have the same hash as something that was already saved.

This is completely untrue. While the index only stores the hashes, the table itself stores the full value and postgres requires both the hash and the full value to match before rejecting the new row. Ie. Duplicate hashes are fine.

For a unique index, that requires a table check, which - IIRC - isn’t implemented during index updates.

The article suggests using a check constraint to get around that - are you saying that does actually check the underlying value when USING HASH is set? If so, I think the docs need updating.

That's super interesting and I am convinced by the dbfiddle but is not very intuitive or well documented? https://www.postgresql.org/docs/current/hash-index.html

This is very good to know because it means this exclusion constraint workaround is a better approach over using a SQL hash function and a btree if you want to enforce uniqueness on values too long for a btree index.

Your comment is 100% not true: https://dbfiddle.uk/Iu-u886S

No, but ECC ram gives you _hardware_ parity checks, which is much faster and doesn’t require you to change your code.

Have you ever tried to make anything nontrivial out of clay? It’s not intellectually straightforward merely because it’s done with your hands.

Why are you right?

That's where the looking comes in.

Refusing to support your claims is not effective argumentation.

It ain't an argument.

No, but if there were something convenient for them to grab and hang from, like a power transmission line…

A fun alternative to "Snake on a Plane"

”Snake on a Surface”