3 ms·
Yes, we have already updated our in-app UUID generation to use v7 UUIDs and are storing them in regular postgres UUID columns (postgres 14). Works great!
by mplanchard 3y ago
Yes, we have already updated our in-app UUID generation to use v7 UUIDs and are storing them in regular postgres UUID columns (postgres 14). Works great!
- ghusbands 3y agoNote that, as jmull says in https://news.ycombinator.com/item?id=39262286 https://news.ycombinator.com/item?id=39262286 , embedding timestamps in every uuid can potentially expose private information.
- mplanchard 3y agoYes, you can check UUIDs to see if they’re v7, and extract the timestamp if so. This seems to me less problematic in most cases than being able to guess the next ID (as is the case with numeric IDs). At least for us, anybody with access to the ID also has access to the time the record was created, so there’s no new information being exposed. It’s a good thing to keep in mind though for sure.