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.
Comments URL: https://news.ycombinator.com/item?id=43332226
Points: 7
# Comments: 0
Login to add comment
Other posts in this group
Article URL: https://lumalabs.ai/news/inductive-moment-matching
Been making this rasterizer engine in C++ for the past few months, now also adding ray-tracing functionality to the system.
Simply load a model or generate a mesh, add some lights, and render.
Hey HN, I built XPipe as I always wanted to have an easy file system and terminal access to all of my remote systems, including containers, virtual machines, clusters, and more that you normally c
Article URL: https://www.theguardian.com/australia-ne
Article URL: https://blog.comma.ai/happy10kday/
Comments URL: https://news.ycombinat
