You didn't mention that, I just guessed that's how it might be. I've not spent any time looking at the DB yet.

I do hope in a future update, users will be able to change usernames. That's important to many especially in social media.

If you want something that is not supported then of course you need to hire someone to do it for you. Example Reddit doesn't allow you to change usernames. There are many reasons behind it.

Instead of using the username itself as the primary key or a foreign key in related tables, you would typically assign a unique identifier or surrogate key to each user.

I am not sure where did i said that username is primary key or a foreign key? it is not

Right, at an additional cost of something that should be a given in a social platform :).
I'll keep it in mind.

If you want users to change username you may get a custom component from openteknik please contact us and we can provide you custom component at additional cost.

I don't know, I've not taken a look at the database yet and I'm not an actual DB developer but do a lot of work on our DB's.
The problem in this case seems to be that the db designer is not using an effective method.

Instead of using the username itself as the primary key or a foreign key in related tables, you would typically assign a unique identifier or surrogate key to each user. This identifier is an internal, system-generated value that doesn't change, even if the username changes.

At least, this is how we design our own software so I'm hoping we'll see that in an upcoming future version. Members often want to change their usernames, it is something that should be flexible in any software.

How is username change done on the database side @Mick Dawlings?

I am afraid this is not true , OSSN doesn't automatically turns into username.

It's not so much that it's 'not true' but maybe I didn't explain it correctly.
I should have mentioned that I only saw this when creating the initial admin account and is why I thought all users would have that happen.

I've worked on many software projects and not allowing username changes is rare these days.
When they sign up, sometimes they don't use their real names or use a fake name just to try the site. Later if they like it, they might want to change it to something else but cannot. That would be very frustrating to members.

I hope you'll consider changing that. It's mainly how you reference the username across the DB.

Editing a username is not allowed because its referenced in many places.

Oddly, when creating an account, you're asked for first and last name which the code turns into your usename..

I am afraid this is not true , OSSN doesn't automatically turns into username.