4 ms·

How does one generate ordered UUIDs right on the PostgreSQL server?

• solicode 6y ago
  There's probably a nicer way (or more performant at least), but I created a function that uses the built-in `uuid_generate_v1mc` and then reverse the order of the time component so that high values come first.
• Tostino 6y ago
  Use this: https://github.com/tvondra/sequential-uuids https://github.com/tvondra/sequential-uuids If you cannot install extensions, I just wrote a PL/PGSQL implementation for the time-based generator I could share.
  • Sytten 6y ago
    Please do I have been looking for that. Posting it in the repo would help a few people k am guessing.
    • Tostino 6y ago
      https://gist.github.com/Tostino/ca104bff40e704b6db70b9af492664ef https://gist.github.com/Tostino/ca104bff40e704b6db70b9af4926... Posted it to the repo as well.