Install Steam
login
|
language
简体中文 (Simplified Chinese)
繁體中文 (Traditional Chinese)
日本語 (Japanese)
한국어 (Korean)
ไทย (Thai)
Български (Bulgarian)
Čeština (Czech)
Dansk (Danish)
Deutsch (German)
Español - España (Spanish - Spain)
Español - Latinoamérica (Spanish - Latin America)
Ελληνικά (Greek)
Français (French)
Italiano (Italian)
Bahasa Indonesia (Indonesian)
Magyar (Hungarian)
Nederlands (Dutch)
Norsk (Norwegian)
Polski (Polish)
Português (Portuguese - Portugal)
Português - Brasil (Portuguese - Brazil)
Română (Romanian)
Русский (Russian)
Suomi (Finnish)
Svenska (Swedish)
Türkçe (Turkish)
Tiếng Việt (Vietnamese)
Українська (Ukrainian)
Report a translation problem
Your special circumstance is irrelevant, especially considering the risk in changing that MASSIVE database.
I have to say, it's a little odd that the primary key is tied to the name of the account and not the unique steam id. Really bad design IMO
Yep, but when steam was first made it was a glorified updater for Valve, it was never planned that it would become what it is today.
Well, it could be manually edited by a SQL admin, but NO ONE wants the risk of that and it isnt a viable solution for the masses either. Far, FAR too risky.
Well, just as an asterisk some of this information is second hand and fairly old. We're not privy to the details of the whole design, or every update that occurs.
The username doesn't have to be a primary key, but it can be a unique value that is sometimes used for relationships and joins, nothing wrong with that. Valve's DB may follow SQL normal form design principles just fine.
And it's not as if usernames are always editable on all other systems. Ever try changing the user name on your email account? Whether a username is editable or not depends on implementation regardless of database designs and lots of systems don't allow it regardless of user feelings.
Even if Valve were to remove reliance on the unique username in their database (which they may have already done, it's not as we're updated day to day about DB changes) it really has nothing to do with whether Valve is going to implement editable usernames or not. No, is still a complete answer to requests and Valve doesn't need to satisfy anyone with their decisions.
There's some fair arguments why usernames should be immutable. If Valve feels the pros outweigh the cons usernames will remain immutable regardless of database design.
So, changing it now would be far too much of a task.
It's an old and huge database, you don't mess with what works without risking a lot of downtime and broken dependencies. As the saying goes "If it isn't broken, don't fix it".
Why odd?
Did Valve in the beginning realise how big Steam would become? Unlikely as Steam was originally only a updater for Valve games.
Secondly the account name is linked to the many parts which make up Steam, so imagine the chaos caused if they mess up and you cannot access your library for example.
And finally Sony tried it with PS4 and warned everyone certain trophies would be messed up. Bloodborne was one example where those with platinum lost it.
Note: I beta tested the account name change. I had a PS4, PS3 and PS Vita and Bloodborne. It totally messed up trophies for PS3, PS Vita because they no longer existed for anyone who also had those systems.
Fortunately the change could be reverted.
What you can do is create a new account and family share your librarry of your old account. Beyond that. well. you're just gonna have to deal with it. you're an adeult. You can handly a silly account name. heaven knows if something like that registers as a problem for you you are living a charmed life.
Of course that doesn't deny the troubles it has caused for a lot of users over the years. From people being deadnamed by their username to people having no-longer existing email accounts as permanent usernames.