News for hackers. Stuff that matters.
Re:New UUID Formats by mewpmewp2 on Tuesday August 24, 2021 @01:42AM (#28285488)
Just curious when would you want timestamp to be in UUID rather than extra column that would make it easier to query, read, parse and modify in the future if it may be needed for whatever reason?

I usually include created_at, updated_at, and potentially deleted_at pretty much always in my tables as I don't think they affect storage and performance enough not to considering potential benefits down the line.

Re:New UUID Formats by taepper on Tuesday August 24, 2021 @05:21AM (#28286567)
AFAIK many queries are mostly a lot more efficient if the UUID is in insertion order which is facilitated by including the timestamp at the front of the UUID