This may be more of a posgres question but I’m trying to create a user and as part of this generate a unique username for that user. Any suggestions on the best way to go about this? My initial research showed postgres ‘triggers’ might be one way to do it but I’m not sure how to accomplish that with prisma. My naive implementation would otherwise be to include some random values along with lets say the user’s firstName.lastName and repeat until there are no collisions, but that’s probably not the best way to do this

do you have character requirements for this username? will it be overwritten by the user at some point?

I’d like to give users the opportunity to edit their username, yes. Ideally would have a minimum length and be alpha-numeric

you could combine first name and last name (sounds like you’re already requiring those) and mark it as unique

Gotcha. Yeah that was basically what I was getting at with my naive implementation. I guess that would be fine for now I’m just envisioning that’s probably not actually sufficient if you have a lot of users since you might have to ‘add something to the end of it’ more than once to avoid a collision. Thanks!

again, uuid would work

Yeah I think i’ll just do it as apart of my registration flow