This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I have beed made software for decades, but I have never done performance testing for ID vs UUID. I am designing a pretty large C# project, and automatically I always used an int ID in the database, and IDs for relationships, but I have been wondering if it would be safer to use UUID?
I was initially thinking to keep the auto inc integer ID for internal operations, then UUID for any requested interaction, but still having an ID I would assume _could_ in edge cases where for example a DTO mistakenly keeps an ID to be open to guessing an ID.
So in 2024, whats the most accepted approach.
Keep both an ID and GUID, refer to ID internally, and UID externally
Ditch the int ID and use GUID as primary key
Other?
Subreddit
Post Details
- Posted
- 4 days ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/learnprogra...