UUID data type
UUID data type
- Subject: UUID data type
- From: Samuel Pelletier <email@hidden>
- Date: Tue, 22 Mar 2016 10:03:30 -0400
Hi,
I'm working on adding uuid support as primary key with a prototype and ERRest support. Actually, my implementation uses a 16 bytes NSData as the adaptor value type. Before going too far in this, I would like to validate my choices...
I see 2 options:
1- A 16 bytes NSData
Pro: It seems the most efficient and adapted data type.
Cons: Hard to read and type in SQL queries. GlobalIds are cryptic.
2- A 32 char hex string (or a 36 one if pretty printed with the dashes).
Pro: Easier to read, especially with the dashes.
Cons: Uses more spaces, maybe less fast. Seems a bit awkward to deal with hex strings.
For the ERRest part, I managed to format the uuid in a primary key by detecting if it is a 16 bytes NSData in the formatted hex representation. I also found a way to get objects using the hex representation.
Any though on this ? Something I missed ?
Finally, is a presentation on using uuid for primary key in next WOWODC would be a good topic ?
Samuel
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden