Prisma

Okay so what's strange is that the @unique directive works when assigned to anything but the email field.

Why the hell does this error " unique constraint would be violated on User. Details: Field name = name, Location: [object Object], Path: createUser" not occur on field email

or even on field 'mail' after changing... is this a known bug ?

Maybe it's a bug with mongodb connector. `@unique` works well with postgresql connector.

docker-compose-yml.yaml

hi guys an new in prisma, so I appreciate your help :grin:
well, I follow de doc of prisma to conect with new db with docker. when i

when I run docker-compose up i got an error

image.png

<@UHZM23FGR> ```
volumes:
  mysql:
```
it's the syntax error in docker-compose file.

For example, from mongo and MySQL at the same time.

Although I am also new to it but I have some concept in it. For example you have one web application like facebook. You want to store the login/signup details and other logic in mysql and on the other side you want to create the mongodb for saving post details and some logic. Then for both of these you have to create separate servers. I do not know about combining     both mysql and mongodb to one.

While using multiple Databases can make sense, I think with your example you should just stick with MySQL. Or do you have any reason to use MongoDB?

It's currently not possible to use two databases, but I think it's planned (although that can take a lot of time)

You could create two separate Prisma servers, one for MongoDB and one for MySQL of course, but you don't get relations between those obviously

I think that would be useful for applications like Facebook's example.

I am constantly getting an issue of could connect to localhost:4466  when  use prisma deploy and I have tried everything like changing the end point to docker ip. Have anyone solution for

what  is your problem? Can  you show the error log?

replacing localhost with docker ip actually worked for me..

error1.JPG

<@UFR86U7V5> I get the following error when I am using the localhost:4466 as the endpoint

error2.JPG

<@UFR86U7V5> I also tried changing the endpoint to docker-machine default ip in prisma.yml but then I got the following error

docker file.JPG

<@UFR86U7V5> My docker-compose.yml file is following

If you're using docker-machine, you need to use the VM's IP address

Looks like you're running postgres in the host. I think `host.docker.internal` only works with Docker Desktop for Windows

Could you try with the compose file example from the docs: <https://www.prisma.io/docs/get-started/01-setting-up-prisma-new-database-JAVASCRIPT-a002/#set-up-and-connect-prisma-with-a-database>

But I recommend switching to Docker Desktop for Windows, if you can

Hello I wish to have some help, how can I represent multiple string values on an attribute in the prisma data model and then search them

for one attribute, multiple string values

like this? but how do I search tags

type Article {
  tags: [String!]!
}

<@UJAFQH1C7> you can't search the tags. You can check these issues:
<https://github.com/prisma/prisma/issues/4454>
<https://github.com/prisma/prisma/issues/4463>

Never mind, just seems to have resolved itself 

Have you exhausted all of your self-help search options?

<https://github.com/prisma/prisma/issues/60>

<https://www.prisma.io/forum/t/how-to-query-array-of-string-attribute-how-to-find-value-inside-it/6849>

Anyone know why can’t get the duplicate constraint to work with email field?

hi all, how do you guys run e2e / integration testing with Prisma? Do you use a test db? or is there a mocking library?

hey I'm having an issue with a query - it works the first time, but the second time it gets called, networkStatus = 2 and it stays loading = true forever.  the resolver on the server looks fine, it completes the query, but the data doesn't seem to make it back to the client.

Good morning everyone. I'm struggling to find a good example of Facebook/Google Oauth authentication for a frontend app implemented on a Prisma server. Does anyone know of a good example? Had a read through the intro docs: <https://www.prisma.io/docs/get-started/04-explore-features-f001/>

Found the answer, or at least I now have a better understanding of exactly where Prisma server sits in the stack: <https://www.prisma.io/forum/t/prisma-vs-apollo/3842>

I’m getting this after removing the `name` field from `User`, even tho I’m not using it anywhere:
`Error: Field name not found in type User`

definition(t) {
    t.prismaFields([“id”, “name”, “email”]);
  }

Hello All, I can’t really find resources about to store large &gt;256kb data as a string, or even best practices to doing this. Maybe i miss something as i try to store an editor state with a large richtext into a field. Is there a way to increase the limit of 256kb of a string field at Prisma?

Maybe you should storage large data in external files and just save the link to the file in Prisma

Hello how can I get websocket to work on Prisma server?

What is your question exactly? Prisma exposes subscriptions out of the box

I am using Apollo client and want to subscribe to an event

the prisma admin says this wss should work  <wss://eu1.prisma.sh/philip-andrew/demo/dev>

but I tried with chrome websocket client and not able to connect

maybe my question is, how can I use Apollo client to do a subscription to an event

Ehm like this: <https://www.apollographql.com/docs/react/advanced/subscriptions>

in my prisma directory there is a src/index.ts and a types.ts file, now does the index.ts run on the prisma server ?

so I need to add a subscription type object to it I think?

thanks your help, I worked out how to do subscription inside the admin

now I got to go try in the client side javascript

Where can I find this error: `Error: Whoops. Looks like an internal server error. Search your server logs for request ID: eu1:cvj_blablahbla`. Tried searching the `heroku logs` but it’s not there.

If your Prisma server is hosted on Heroku, then heroku logs should have this. Prisma writes to `stdout`

Maybe it takes a while for Heroku to aggregate logs or something?

I cannot find that exact log id, but I see this a couple of times: `Detail: User does not have CONNECT privilege.`

```2019-04-29T09:49:49.367032+00:00 app[web.1]: org.postgresql.util.PSQLException: FATAL: permission denied for database "postgres"
2019-04-29T09:49:49.367034+00:00 app[web.1]: Detail: User does not have CONNECT privilege.```

I deleted the service and deployed again and now it’s fixed. This wouldn’t be possible if the app was live and had users …

I too got this problem and had to restart my docker machine

:wave: How do you peeps interact with Prisma from the frontend?

You should have an application server between the Prisma server and the frontend

On the application server, you can use Prisma Client or prisma-binding to interact with Prisma

On the frontend, you can use apollo-client or other library, depending on what you're using