> Every single time I've seen a primary key being defined with a natural key, it... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		hot_gril on Jan 20, 2023 \| parent \| context \| favorite \| on: Choosing a Postgres primary key > Every single time I've seen a primary key being defined with a natural key, it turned out that this set of attributes wasn't as immutable as we thought actually and it caused a world of pain. Yep, happens to the best of us. Never mess around with this, just use a bigserial.

hot_gril on Jan 20, 2023 [–]

(Or other things like UUIDs, which I would not use, are still way better than semantic keys.)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact