AFAIK UUIDs as pks in databases is extremely standard. I would suggest the bigge... | Hacker News

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

		Quarrelsome on Nov 22, 2022 \| parent \| context \| favorite \| on: Moving Away from UUIDs (2018) AFAIK UUIDs as pks in databases is extremely standard. I would suggest the biggest downside is debugging where writing id = 5 is much easier than id = 'xxxx-xxxx-xxxx-xxxx'.

vbezhenar on Nov 22, 2022 [–]

On the other hand you won’t get wrong result if you wrote wrong table name. Was hit once. Deleted row from the wrong table.

Quarrelsome on Nov 22, 2022 | [–]

yeah, I seen bugs in multi-db systems where a dataset gets accidentally composed from data from each due to aligning ids. Was a very strange afternoon.

Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact