I have a query, and I'm wondering if there's a way to only return

stats

from

matches

that have the same

player id

as the

id

returned from

players

.

const TEAM_QUERY = gql`
  query TEAM_QUERY($name: String!) {
    team(where: { name: $name }) {
      id
      name
      players {
        id
        summonerName
        matches {
          id
          duration
          stats {
            player {
              id
            }
            damage
            gold
          }
        }
      }
    }
  }

Hello, I thought I would share this with you before leaving the community. For the past two years I have been running a service alone on

Graphcool

. It has been a smooth experience to be honest, no downtime until 3 days ago. All our functions hosted on Graphcool started failing returning an obscure error. Among those functions, the one handling authentication failed making the application unavailable for our 400~ paid users. During 2 days, we had no response for support, other users were impacted. Then yesterday they contacted us to confirm a fix was deployed. A first look at the #graphcool-framework showed positive feedback, but our functions were still throwing errors. Someone from support sent me a DM and we tried several things, but to no avail. At some point, the support person told me they couldn't help me further, then signed off. You can imagine the frustration, I have been cooling down my users, offering refunds for the past 2 days. Now I am 3 days into downtime, and the only solution would be to migrate to Prisma or another service and refund all my clients while I make it happen. Unfortunately, this is going to take some time because I was running that thing alone, so I decided to refund all my clients and close the service. This is going to put a dent on my personal revenue, but at least on the bright side it's impacting only me. As a conclusion, guys if you are still running something on Graphcool, migrate ASAP and if I were you I would think twice using any cloud offering from Prisma. They seem to always go for new shiny toys and abandon their previous projects, pretty sure they'll do the same thing to Prisma once Prisma 2 comes out. I realize this might come off bitter, and the worst is I absolutely love the products, but the unreliability of Prisma as a company makes it impossible for me to base my future projects on their offering.

Quick question: when is prisma 2 scheduled to have a stable version? I am about to start a new project and wondering whether to take the chance and use

prisma2

or stick with

the current prisma

Hey everyone! I was wondering if someone could point me to an example of using Prisma with read replica support? The use case would be using an AWS aurora database which has an endpoint for write (primary DB instance) and a read-only endpoint which points to the various read replicas. Any help would be appreciated!

Hi guys, I have a simple question regarding subscriptions, here is my post if anyone can help me out https://www.prisma.io/forum/t/how-to-make-a-subscription-resolver-for-sub-type/7848

Following Andrew Mead to the letter ... docker-compose up -d -> Creating prisma_prisma_1 ... done, $ prisma deploy = Could not connect to server at http://localhost:4466. Please check if your server is running. CurrPorts says nothing running on 4466. Appreciate a hint on how to start debugging this. docker ps= 0.0.0.0:4466->4466/tcp prisma_prisma_1

if anyone needs help part-time on prisma/graphql projects from a senior dev let me know…currently between gigs and looking for a new one

hello?

scalarlist filter or where query, I want to know about this.

If you know, please reply.

Hi, I started a Prisma server with MySQL in local docker from a tutorial. I would like to be able to look into MySQL database with Sequel Pro, but it fails to connect. It seems like the port is not public / available in the host:

$ docker port prisma-test_mysql_1 3306
Error: No public port '3306/tcp' published for prisma-test_mysql_1

Any ideas how I can do this?

hello, Prisma is great, thanks to all the staff for this advance, I am not relying anymore on ORMs when is too much for particular cases, instead, Prisma is doing the trick really well.

Something I would like to be pointed is on how to deploy in production environments, currently I am using the prisma+docker solution, but its time to move out to what could be the production stage, I have 3 parts now on my architecture, 0. the nodejs graphql yoga backend, 1. the docker+prisma data layer connected to a postgres instance and 2. the react apollo frontend, usually I use netlify to deploy 0 and 2, but how should I proceed to go with the #1? thanks in advance,

When I deployed my converted schema from GC to Prisma I got this error:

Valid values for the strategy argument of `@scalarList` are: RELATION

So I added

@scalarList(strategy: RELATION)

and it worked. But when I inspect my DB I see that the related table is empty after import from GC where there are values for this field. What happens is that for MyTable with myField: [String!] @scalarList(strategy: RELATION) another table is created with name: MyTable_myField with columns: nodeId, position, value. I got 4 different tables with this structure and all are empty after import. Any ideas on how I could fix this?

Hi hi, are all many-to-many relations in prisma directed?

hello guys how to use graphql aliases if i dont know how many records in my database ? thanks

hello everyone, Hi everyone, I followed the installation process on the prisma docs but when i try to

deploy

it replies with this error.

Could not connect to server at <http://localhost:4466>. Please check if your server is running.,

What could be the problem, by the way I am running on a windows pro.

Check that you have the server running, if not, try to remove the container and compose it again.

Hi, I am trying to deploy prisma to a GCP cluster and a CloudSQL database which is turning out to be very tricky. I have a frontend React client hosted in AppEngine on GCP and have deployed a graphql-yoga backend container into my GKE cluster and packaged the prisma-prod:1.34.8 official image with GCP’s cloud_sql_proxy and deployed that container also. This got the database connected to Prisma server, but then I ran into the issue of primary/secondary Prisma servers and the managementAPI when I tried to connect to my server from Prisma Cloud. There is very little documentation that I can find on how to deploy to GCP GKE so I have gone through days of trial and error and wondering if anyone has any tips/advice on how to set this all up.

Hi I am new to Prisma and I was flowing to a tutorial, and I came to a place that the instructor is using authentication that Prisma implemented but when I create a new project I can't found a typescript-advanced graphql server( database+ authentication) as he used. How can I make get it?

hello i’d like to ask one question about rules to one admin/moderator/team member ?

How do I go from https://github.com/graphql-boilerplates/react-fullstack-graphql into the prisma "admin" panel for that project?

I got it running; how do I go from here?

The advanced typescript sample gives "TSError: ⨯ Unable to compile TypeScript:" when starting it.

But it directs me to the admin panel, which is nice

https://www.prisma.io/blog/announcing-prisma-2-zq1s745db8i5 fails on the 'seed' step

And the link to GraphQL's example is broken too

Hi 👋 all 🙋🏻‍♀️

Has anyone here every setup authentication / authorization with apollo-server, express-session and redis? If you have, can you please take the time to help me out.

What is your best practice on how to create a schema.graphql from the generated prisma-schema.js? Type it manually? Use nexus? Something else?