UUID

Native storage

UUID has native support in the following database platforms:

  • H2
  • Postgres
  • SQL Server 17

When using these database platforms UUID is stored in a native manor.

Binary storage

Stored as BINARY(16), has the option of storing in optimised manor meaning the order of bytes is changed to provide a better distribution in index.

See ServerConfig.platformConfig.dbUuid

Varchar storage

Stored as VARCHAR(40).