Pixilab
Home › Companies › Show HN launch › Generate Version 7 UUID's for a Timestamp

Generate Version 7 UUID's for a Timestamp

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

Generate Version 7 UUID's for a Timestamp operates in show hn launch.

Profile

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-b

Its activity falls under show hn launch; the profile below is assembled from public directory data.

Directory data places it at the Show HN launch stage.

SectorShow HN launch
StageShow HN launch

Website: uuidv7.org

Browse related

Sign in to view the contact information we hold for Generate Version 7 UUID's for a Timestamp.
Create a free account