Hacker News Reader

A more generous interpretation would be the assumption that primary keys are (as they frequently are) synthetic data, and perhaps not the most commonly queried field aside from direct get-that-resource queries.

The author clearly knows this based on the sentence you quoted. I’m very confused as to what your complaint is.

> I have almost no fruit, just a few apples.

Indicates that I do know that apples are a fruit. Not that I don’t.

GP edited their comment after I responded and didn’t mention it. Completely changed the comment. Was very antagonistic to the author of the article before.

What about tables without primary keys?

Generally not a good idea to have these at all.

These are usually stored in CSV files.

DBMS-s still have to identify a particular row somehow. That identifier is CTID in Postgres and ROWID in Oracle. Both will change if the data is moved around.