Untitled attachment

Notices where this attachment appears

1. Embed this notice
   Anton Zhiyanov (antonz@c.im)'s status on Friday, 14-Jun-2024 19:44:50 JST Anton Zhiyanov

   UUIDv7 is nice. Still a 128-bit unique identifier, but also time-sortable with 1 ms precision.

   A UUIDv7 value encodes a unix ms timestamp, and you can decode it back.

   To work with UUIDv7 in SQLite, there's the sqlean-uuid extension.

   https://github.com/nalgeon/sqlean/blob/main/docs/uuid.md