News for hackers. Stuff that matters.

Show HN: Generate Version 7 UUID's for a Timestamp

https://uuidv7.org/

I use UUIDv7's in multiple places as an efficient index in Postgres. When querying this data I usually need to be able to query between a time range so wanted to have a quick way to generate a reference ID that I could use in a BETWEEN query.

All the simple, fast tools I found online were focused on generating bulk ids or converting from an ID to a timestamp rather than the other way around, so I wrote one myself.

For example if I wanted to find everything that happened between 2025-03-11T13:00:00.000Z and 2025-03-11T13:59:59.999Z I can type in the timestamp, select earliest (or latest) to get the min/max and copy the identifiers of 0195854a-6480-7000-8000-000000000000 and 01958581-52ff-7fff-bfff-ffffffffffff

Sharing in case someone else finds it as useful as I do.

( 3 comments | 18 points | on HN )
Re:Show HN: Generate Version 7 UUID's for a Timestamp by jasonthorsness on Tuesday March 11, 2025 @11:39AM (#43333563)
These time range queries using UUIDs are super useful. I don't understand why it took so long for UUIDv7 to become a standard. Even MongoDB had to use something custom (ObjectID) rather than UUID because this standard didn't exist.
Re:Show HN: Generate Version 7 UUID's for a Timestamp by ranger_danger on Tuesday March 11, 2025 @11:41PM (#43339751)
My understanding is UUIDv6 can also be sorted lexically as it also uses a timestamp (v1 has improper endianness for sorting).
Re:Show HN: Generate Version 7 UUID's for a Timestamp by esafak on Tuesday March 11, 2025 @11:22AM (#43333371)