didatus/doctrine-uuid-binary

UUID support for Doctrine using MySQL BINARY type and UUID_TO_BIN

1.0.1 2020-11-23 21:29 UTC

Requires

• php: >=7.1
• doctrine/doctrine-bundle: ^2.1
• doctrine/orm: ^2.7
• symfony/config: 5.2.*
• symfony/framework-bundle: 5.2.*
• symfony/http-foundation: 5.2.*

MIT

• Christian Hammer

README

There is a great extension for using UUIDs with Doctrine entities in Symfony projects: ramsey/uuid-doctrine

The extension uses VARCHAR or BINARY to store the UUID in the database. For the UUID binary type the extension uses PHP to convert the UUID to binary. I wanted to use the MySQL function UUID_TO_BIN and BIN_TO_UUID to convert the UUID to binary. The MySQL functions have a flag to optimize the binary data for more efficient indexes.

So if you want to use UUIDs with Symfony Doctrine and want to optimize the performance to the last bit, then you can try this extension. The performance advantage differs from case to case.