Implement nanoid()

[janpio]

follow up to prisma/prisma-engines#3556

[andrictham]

@janpio Is this still planned?

[Piglow19]

Hello, can we have a update on this feature please ?

[janpio]

Yes, we will do this in the future - but I can not tell you when that will be as we currently do not have this work prioritized.

[ctsstc]

For anyone following the tangled web here's some useful links from other related issues to hold you over until this is implemented into Prisma.

• Main NanoID Repo: https://github.com/ai/nanoid/blob/main/README.md
  • Other Languages: https://github.com/ai/nanoid/blob/main/README.md#other-programming-languages
• SQL function: https://github.com/viascom/nanoid-postgres/
• PSQL Extension: https://github.com/spa5k/uids-postgres
• Utilizing a custom generator: https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#dbgenerated
  • https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#override-default-value-behavior-for-supported-types

Quick Holdover

Until it's implemented into Prisma it seems the quick route would be to:

1. Create an empty migration to add the SQL function here: https://github.com/viascom/nanoid-postgres/
2. Utilize it as a default custom value: https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#override-default-value-behavior-for-supported-types

[itzsaga]

My team verified that id String @id @default(nanoid()) works. Looks like it was added in 4.9.0. Pretty sure this can be closed @janpio.

[ctsstc]

@itzsaga confused why that says it was back in January, and #14004 doesn't seem like it provides anything useful from the 4.9.0 release notes, which just sends you on a rabbit hole to #3556 which doesn't solve it and ends in a comment telling you that you can go use it from the source via: prisma/prisma-engines#3556 (comment) linking out to: https://github.com/ai/nanoid

Are you sure someone hasn't already added it to your DB implementation?

[itzsaga]

@ctsstc just double checked and nothing has been done to the DB (spun op a fresh PostgeSQL container and ran against it to be safe, checked functions and what not in case a migration did something). No type errors when defining it:

If I change it something else random there are errors:

So there's some level of type checking what goes in there. I wish I knew the Prisma code base better to dig in and see if I could verify myself. 🤷🏻‍♂️

[itzsaga]

@ctsstc I just ran across #17199 which may be the best place to keep track of the final list of things to be completed before it goes "public".