Hi, quick question. What's the convention to name JOIN tables in explicit many-to-many. I see something like CategoriesOnPosts and PostToCategories

Any idea why

contains

does not work for this case? string =

"Incredible Soft Pizza"

term =

t

if I remove the entire

where

, all records are shown, although some do apply to that term

Am I the only one facing this?

It only returns results if

t

is the first letter

I tried the

insensitive

mode and still having the same issue

full text search didn't help either

Using PostgreSQL 13

some

returns the right results(with others of course)

every

returns nothing

I'm trying to set up my app to use the prisma data proxy. I've upgraded to v3.5.0 and added the dataproxy under preview features in schema.prisma, but I'm getting an error that the datasource url must start with mysql:// Anyone have any idea what I'm doing wrong?

How are you specifying the connection? Did you define a datasource url?

It should probably look something like

mysql://<username>:<password>@<ip or url of server>:<port of server if non-standard>/<database name on server>

datasource should be part of prisma.schema?

I mean, you have to define the database connection somehow. How else are you doing it?

the url is set via ENV vars

OH! it looks like I have to set a new ENV var called PRISMA_CLIENT_ENGINE_TYPE with the value

dataproxy

wonder if this is going to work when the generation happens on vercel though.

guess we will see

I guess it should.. It pulls in the other vars fine.

Haha, just went to the Data Proxy docs and saw that step 5. Glad you solved it. Good luck with deploying

@Brooks Yes! thanks so much for your time!

well now that's fixed, but now I have a

getUserbyEmail

is not a function from next-auth 😂

which adapter are you using

whoops, wrong one. Ensure this is updated to lastest or whichever is compatible w/ your version of prisma

@next-auth/prisma-adapter

Yeah, my guess is that something needs updated now that I've upgraded

@prisma/client

On a side note, I’m refactoring some code to use the

referentialActions

, and coming up w/ a weird issue I can’t find in the docs of the middleware not being called upon deletion of a referenced model. I only use prisma for this project so I might have missed something. https://github.com/prisma/prisma/discussions/10655

If anyone has experience with GraphQL, particularly Type-GraphQL and the typegraphql-prisma integration, please check out my question in #graphql 🙏

Hi

I am Iwamoto Yuki from Canada.