Hacker News new | ask | show | jobs
by Quarrelsome 1300 days ago
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'.
1 comments
vbezhenar 1300 days ago
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.
link
Quarrelsome 1299 days ago
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.
link