bnc icon indicating copy to clipboard operation
bnc copied to clipboard

User + Connection ID refactoring

Open prawnsalad opened this issue 7 years ago • 1 comments

Currently user IDs are just the user names. Connections do not have an ID but the name is being used as an identifier.

To bring everything inline and easier to store in databases I propose we do the following:

  • Users and connections have both an ID and Name field.
  • Internally we use the ID fields for identifying instances, never the Name field.
  • We can then provide ways to change the Name field with suitable restrictions while the ID fields stay the same.

Baring in mind the different datastore backends that may be possible, I think that using standard UUIDs v4 would be the best ID format to use. Most database engines support these in some form and reduces friction in generating unique IDs in each datastore implementation.

Thoughts before I go ahead with this?

prawnsalad avatar Oct 06 '17 19:10 prawnsalad