Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-1720

Switch persistence identifiers to UUID version 7

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.1.14, 3.0.1, 4.0.0
    • core

    Description

      As pointed out by several resources (for example this blog post), UUID version 4 are not particularly suitable as primary key identifiers, mainly because of their random nature which can cause issues with B-Tree database indexes.

      As pointed out, a better solution is to use UUID version 7, time-based UUID bit layout sourced from the widely implemented and well known Unix Epoch timestamp source.

      Attachments

        Activity

          People

            ilgrosso Francesco Chicchiriccò
            ilgrosso Francesco Chicchiriccò
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: