3 ms·
I have exactly the reverse experience. I do comparisons using ```<uuid fieldname>::text like '<first few chars of the uuid>%``` when debugging in a command lin
by marcus_holmes 4y ago
I have exactly the reverse experience.
I do comparisons using ```<uuid fieldname>::text like '<first few chars of the uuid>%``` when debugging in a command line. Or just copy/paste the whole thing. Yes it's marginally more annoying than integers, but only marginally.
I have several times wondered why I was getting no match on a query. And then discovered that I was using a user_id on an account_id field. UUID's have saved me from shooting myself in the foot so many times.
- Aeolun 4y agoHow do UUID’s help in that situation? You get no result at all instead of the wrong result?
- marcus_holmes 4y agoyes, that. The extreme case (that I had and is the one where I was finally convinced that uuid's save me from myself) was setting admin permissions on a user. I accidentally copy/pasted their account_id instead of their user_id. If I had been using integers I would have given admin permissions to a random user and never been aware of it. But because I was using uuid's I got a nice, safe "updated 0 records" response and knew there was a problem.