is there a reason why Prisma defaults table names to capital Prisma #prisma-client

is there a reason why Prisma defaults table names ...

iamtheworstdev

06/30/2021, 5:48 PM

is there a reason why Prisma defaults table names to capital letters ? like model User {} creates table User? That naming structure is explicitly shunned by postgres

Ryan

07/01/2021, 5:26 AM

We generally follow this convention that most JavaScript devs use. To keep database names to what Postgres recommends, you can use

@map

and

@@map

as described here.

janpio

07/01/2021, 8:36 AM

You can also just use lower case names! What we use in the docs is just a suggestion. If you database already uses lowercase, your schema will be lowercase. And when you create things, you can create them any way you want!

iamtheworstdev

07/13/2021, 8:22 PM

Based on what the people in #postgres have told me it seems like Prisma should maybe change it's recommendation. The convention that Prisma recommends could apparently cause honest issues for people further down the road

janpio

07/13/2021, 9:40 PM

Why? What are possible problems of not using some specific naming strategy for Postgres databases? Besides that: This is a Prisma schema level recommendation. With

@@map

you can name your underlying database table whatever you want.

iamtheworstdev

07/13/2021, 10:11 PM

https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_upper_case_table_or_column_names

iamtheworstdev

07/13/2021, 10:13 PM

maybe prisma should mention in the docs "if you're working with postgres we recommend this other naming convention".. otherwise, if you give people a footgun then they're gonna shoot themselves in the foot (see: Rails mass assignment vulnerability)

janpio

07/14/2021, 10:38 AM

That's a reasonable request for https://github.com/prisma/docs - suggestions where to put it and how to word that welcome.

5 Views

Open in Slack

Previous Next