Archives
Contributors
OWL Trainers Wanted (RFQ Deadline 17th April) by the OCA and AEOdoo
A bit of marketing: LinkedIn Banners for OCA contributors/members/delegates...
New module for uuid fields
Hello everyone,
I am currently working on a project where I wanted to use the native postgres type uuid, instead of storing the uuids in plain char fields. Since such a field does not seem to be available in Odoo yet, I threw together a very simple module: https://github.com/mkoeck/base-uuid-field/
Since I saw that there are some existing OCA modules using uuid’s (but storing them in plain char fields), I thought this module might also be interesting to others. I would be happy to integrate this into an existing OCA repo, if someone guides me what the best direction for this would be.
Do note, that I am quite the novice with JS / owl, so any feedback, but especially on that is appreciated J
Best regards,
Michael
by mkoeck - 01:15 - 1 Apr 2025
Follow-Ups
-
AW: New module for uuid fields
Yes, for sure in most cases you will set the field to be readonly. Still using a native uuid type over a char type can have various benefits. I am certainly not an expert but you can refer to this stackoverflow post, why you would want to use a uuid field over a char field even if only for display reasons: https://stackoverflow.com/questions/32189129/performance-difference-between-uuid-char-and-varchar-in-postgresql-table
Von: Vincent Hatakeyama [mailto:notifications@odoo-community.org]
Gesendet: Mittwoch, 2. April 2025 11:58
An: Contributors
Betreff: Re: New module for uuid fieldsHi,
I’ve had the need to use an uuid column in the past. The column was not meant to be filled by users. The table was built manually and a Char field was used to display the content.
The code can be viewed at https://orus.io/xcg/odoo-modules/xbus_common/-/blob/branch/18.0/models/xbus_message.py?ref_type=heads#L94
I believe the server-tools repository is the place to put a module adding UUID fields.
Regards,
--
Vincent Hatakeyama
Directeur du pôle développement " Orbeet
+33 1 83 62 72 88
27, boulevard Saint-Martin
75003 Paris
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by mkoeck - 12:25 - 2 Apr 2025 -
Re: New module for uuid fields
Hi,I’ve had the need to use an uuid column in the past. The column was not meant to be filled by users. The table was built manually and a Char field was used to display the content.The code can be viewed at https://orus.io/xcg/odoo-modules/xbus_common/-/blob/branch/18.0/models/xbus_message.py?ref_type=heads#L94I believe the server-tools repository is the place to put a module adding UUID fields.--Regards,Vincent Hatakeyama Directeur du pôle développement " Orbeet
+33 1 83 62 72 88
vincent.hatakeyama@orbeet.io
27, boulevard Saint-Martin
75003 Paris
https://orbeet.io
by "Vincent Hatakeyama" <vincent.hatakeyama@orbeet.io> - 11:56 - 2 Apr 2025 -
AW: New module for uuid fields
Hi Michael,this sounds interesting to me! Unfortunately, I can't access the repo.Can you share it?
Best,Friedrich
Email: friedrich.sauer@servicum.comPhone: 01721324603
Von: Elektro-Shop Köck GmbH - Michael Köck
Gesendet: Dienstag, 01. April 2025 13:17
Bis: Contributors
Betreff: New module for uuid fields
Hello everyone,
I am currently working on a project where I wanted to use the native postgres type uuid, instead of storing the uuids in plain char fields. Since such a field does not seem to be available in Odoo yet, I threw together a very simple module: https://github.com/mkoeck/base-uuid-field/
Since I saw that there are some existing OCA modules using uuid’s (but storing them in plain char fields), I thought this module might also be interesting to others. I would be happy to integrate this into an existing OCA repo, if someone guides me what the best direction for this would be.
Do note, that I am quite the novice with JS / owl, so any feedback, but especially on that is appreciated J
Best regards,
Michael
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by Friedrich Sauer - 04:11 - 1 Apr 2025