Comments (8)
Hmm... yes, this does look like something caused by #45. I'll have a closer look tomorrow.
from uuid-doctrine.
I don't think it's possible to fix this issue. However after inspecting the internals of doctrine/dbal I don't think it's worth fixing.
The main problem is in the readme of this package. I'm rather new to UUIDs so I believed that the documentation was correct which it isn't. It says that UuidType uses CHAR(36)
(and that's obviously bad for indexing so binary type seems better at first glance). This is true for MySQL and MariaDB. However for PostgreSQL this is incorrect. UuidType will use the internal UUID datatype on PostgreSQL and it's probably safe to assume that this type could easily be even faster for indexing uuids than bytea. It should be noted that UuidBinaryType is a MySQL/MariaDB specific optimization and that UuidType is just fine for PostgreSQL.
from uuid-doctrine.
Which type are you using? UuidBinaryType
or UuidBinaryOrderedTimeType
?
@enumag, can you look into this? Is this possibly a result of the changes in #45? I might roll a hotfix soon that reverts those changes until I can find a resolution for this.
Thanks!
from uuid-doctrine.
Thank you for reply
I use Ramsey\Uuid\Doctrine\UuidBinaryType::class
bytes got by Ramsey\Uuid::uuid1()->getBytes()
.
from uuid-doctrine.
I've reverted #45 in release 1.4.3. @forgie1, please try 1.4.3 and let me know if that fixes the problem you were facing.
from uuid-doctrine.
I have used before in composer:
"conflict": {
"ramsey/uuid-doctrine": "1.4.2"
}
Both 1.4.1 and now 1.4.3 don't throw this notice.
from uuid-doctrine.
@enumag , is this still true as of today (I expect yes)?
I am deploying my project to PostgreSQL and MySQL databases and would like to have one type that is good for all database systems. Can you recommend one to me?
from uuid-doctrine.
@flaushi Sorry, I'm only using PostgreSQL so I don't know what is best when using both MySQL and PostgreSQL. I would not recommend it.
from uuid-doctrine.
Related Issues (20)
- Type missmatch in generator with static PHP Mapping (LazyUuidFromString to property Uuid) HOT 3
- There is a bug in MariaDB 10.5.9, extremly slowing queris with UUID in binary form HOT 2
- uuid_binary_ordered_time not working with IN expression HOT 8
- Doctrine 3 compatibility HOT 1
- Imcompatible with the latest Doctrine 2.10 HOT 2
- doctrine.dbal.default_connection is set to 'default' and cannot be changed anymore HOT 2
- Deprecation notice after updating from Symfony 5.3 to 5.4 HOT 2
- Tag new release HOT 1
- Supportfor typed property. HOT 4
- Support other types of `EntityManagerInterface` too HOT 2
- Fetching metadata from an entity using the custom strategy is throwing an error. HOT 2
- Node of UUID is 0 HOT 1
- Additional usage of UUID v6/v7 for UuidBinaryOrderedTimeType HOT 7
- Converting my entities ids to uuids
- Tag a new release HOT 1
- Fetching association throws "Unknown parameter type, 116 given" exception HOT 6
- PostgreSQL UUID type returns a binary stream; DB to PHP conversion is always null HOT 5
- Object of class Ramsey\Uuid\Lazy\LazyUuidFromString could not be converted to int HOT 1
- Doctrine/dbal v4 is out!
- Symfony/Doctrine fail to find an entity based off of its binary UUID HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from uuid-doctrine.