Standardizing means for displaying and manipulating UUIDs

[sergeyprokhorenko]

@kyzer-davis @bradleypeabody

It makes sense to standardize the visual representation of UUID columns in IDE and UUIDs in hypertext (on web pages, in electronic documents, in program code, in export from database tables and queries in IDE, etc.):

• color highlighting of UUID columns' names (with/without DB index, for light/dark theme)
• additional graphical representation of UUID (identicons, emoticons) with corresponding context menus

The identicon of the same UUID (or a hyperlink with UUID) should look the same in all documents, programs and platforms, but the identicons of slightly different UUIDs should have large visual differences. At the same time, the ability to search for UUIDs by text, copy UUIDs, etc. should be preserved. The context menu should contain an indicator of the UUID (or hyperlink) matching the one saved in the clipboard, as well as an item for searching for the same UUIDs by text.

[bradleypeabody]

Can you outline what kind of change or document or spec you would envision for this? I don't think visual styling is within the scope of an RFC, but if you have an idea on this that you think could make sense that would be interesting to hear.

[sergeyprokhorenko]

Can you outline what kind of change or document or spec you would envision for this? I don't think visual styling is within the scope of an RFC, but if you have an idea on this that you think could make sense that would be interesting to hear.

This could be a separate RFC "Means for Displaying and Manipulating UUIDs" or anything like this.

This could be supplemented with:

1. A means of searching for related or identically named UUID columns in DB
2. Copying the UUID and UUID_192 format value with one left mouse click (without the need for preliminary selection) and pasting (without formatting) with one right mouse click to the appropriate place
3. Automatic merging of duplicate objects (user, etc.) that have different UUIDs
4. Tooltip for UUID in hypertext
5. Filtering and searching electronic documents (json, xml, hypertext), database lines and files by the UUIDs they contain with the required markup tags, in the specified columns of the database table or with the required URLs
6. Automatic search for primary and foreign keys among fields with the UUID type and construction of ER diagrams
7. Separate UUIDv7 generator for each DB table similar to autoincrement
8. A function that generates a key for partitioning a table using a UUIDv7 timestamp
9. Timestamp offset parameter
10. Short text format of UUID (Crockford Base 32)