Hi guys, does prisma client getting data over http graphql endpoint or connecting to prisma server directly?

Hey everyone, would anybody be willing to share some of their graphql resolvers while using prisma and a sql database? I'm having issues with connecting one type to another inside the resolvers. Thanks!

Quick question. Is there a way to set the service name and the stage without changing my endpoint? I'd rather my mongodb database not be named default_default and I would also rather not have my endpoint be at the route /<servicename>/<stage>

I am reading about the prisma.yml and it seems like the only way service name and stage can be set is through prisma inferring it from the endpoint specified.

Hey everyone, have a question about working with Expo. My backend code works well with a React Web app but I always get a network error on the React Native version

Is it possible to use

pgcrypto

as ID generation within

datamodel.prisma

? How can this be achieved? I am using Prisma 1.30 with Postgres

hey, I have been trying to figure out how to get a count of rows that are a group by...

like if I have a property, say,

tagName

, and I want to see how many rows have the same tagname, and order it by that count

Prisma doesn't currently have a group by feature, but it is frequently requested

@James is there any way to even get this data out

man it seems like a huge oversight

I'm not sure. If you are using mysql or postgres then it's pretty simple to do groupBy queries on the database. Prisma has an execute raw sql queries feature now, but it isn't fully documented, just says "coming soon". There is plan to have an aggregations api to allow many of the things like max, min and groupBy that are pretty easy to do in SQL but it is just a plan at this point @CCBCodeMonkey

yea im trying to figure out how to use executeRaw

I don't see the function on my prisma client

all I've been able to figure out is that it needs to be enabled first, add

rawAccess: true

to your prisma config file

is there an easy way to see the schema?

dunno, but this github issue seems to have some useful info about how to use execute raw https://github.com/prisma/prisma/issues/3300

when I try add rawAccess: true to my

prisma.yml

I get this

bleh... seems like you have to add it to some config file that I don't have because I used prisma cloud

yeah it needs to be added to PRISMA_CONFIG environment variable, so for me that would be in the docker-compose.yml, but I'm not sure about prisma cloud

ah I see it in heroku

actually I don't

not sure how to set it

with prisma cloud

You might try it and see if rawAccess isn't actually aleady enabled

@James I don't see it on my list of functions on my generated prisma client

this really sucks, usually I can work around what prisma is missing but I don't how how to work around this aside from querying every single row in the table

nor do I and I've got rawAcess set to true

Anyone ever successfully used executeRaw who can tell us how to use it?