You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe your maintenance task
UUIDs make great sense when we need a unique ID for thousands of records, but in some cases they can be cumbersome in a referential DB context. Entities are one example. Because they ARE UUIDs and are regenerated if looked at, maintaining them add SIGNIFICANT overhead to any code changes we do. Self tests all change with the tiniest adjustment, and there are confusing loops and turns in the code to get entity_id from name and vice versa. It's a massive pain.
The proposed task is to:
Keep the entity_id column on configured_entities, but a unique text field like project_id is on project
Search for any code referencing entity_name and replace with entity_id
Remove any reference of the methods to look up name from id and vice versa
Update all the tests, db upgrade script etc
It a big job, but life will be so much simpler afterwards! :)
The text was updated successfully, but these errors were encountered:
Describe your maintenance task
UUIDs make great sense when we need a unique ID for thousands of records, but in some cases they can be cumbersome in a referential DB context. Entities are one example. Because they ARE UUIDs and are regenerated if looked at, maintaining them add SIGNIFICANT overhead to any code changes we do. Self tests all change with the tiniest adjustment, and there are confusing loops and turns in the code to get entity_id from name and vice versa. It's a massive pain.
The proposed task is to:
It a big job, but life will be so much simpler afterwards! :)
The text was updated successfully, but these errors were encountered: