Discussion on: Has anyone used Apollo Server 2 w/ Prisma?

[Alan]

Great answer!

My limitations so far with Prisma are:
-the 1000 max node. In my backend, sometimes, I have to sum all Prices: invoice { id price }. If you used ctx.db.query.invoices(), you will get a max of 1000 nodes.. (stackoverflow.com/questions/573132...). I also used in parallel a server SQL to run my customs queries to solve that issue.. (youtube.com/watch?time_continue=15...)

-running in production. Because everything is in docker, the database and the Apollo server are in the same image. I could not find any documentation regarding the good practices.

-they started with graphCool, then Prisma and now Prisma2. Hard to follow. And Im really afraid of the breaking changes.

-Order by related fields: You have a table wit column companyName/UserName. you pull id Invoice user { id UserName} with ctx.db.query.companys(). You can order the table by companyName, but Not by UserName. (1 user has 1 company)
(github.com/prisma/prisma/issues/95)

For the rest, Prisma is amazing.. I recommend it!

[Kosek]

I think you can set up the limit for yourself from Prisma 1.32.1

port: 4466
        databases:
          default:
            connector: postgres
            host: postgres
            port: 5432
            user: prisma
            password: prisma
            queueSize: 10000