4 ms·
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-xxx
by Quarrelsome 4y 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'.
- vbezhenar 4y agoOn 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 4y agoyeah, 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.