Mohammad Orabi Posts - Answer Overflow

Mohammad Orabi

Explore posts from servers

•Created by Mohammad Orabi on 7/18/2024 in #help-and-questions

Types are broken because of read replicas extension

I am exporting this singleton in my whole application

 const prisma = new PrismaClient({
  log: ['info', 'error', 'warn'],
}).$extends(
  readReplicas({
    url: databaseUrlReplicas,
  }),
);

export { prisma };

 const prisma = new PrismaClient({
  log: ['info', 'error', 'warn'],
}).$extends(
  readReplicas({
    url: databaseUrlReplicas,
  }),
);

export { prisma };

now I want to pass prisma as a type so that I pass transactions for example

  await prisma.$transaction(async (prisma) => {
    await prisma.gameDailyStreak.create({
      data: {
        userId,
        gameId,
        day: 1,
        lastStreak: new Date(),
        total: 1,
      },
    });
    return await claimReward({ userId, gameId, day: 1, prisma });
  });

  await prisma.$transaction(async (prisma) => {
    await prisma.gameDailyStreak.create({
      data: {
        userId,
        gameId,
        day: 1,
        lastStreak: new Date(),
        total: 1,
      },
    });
    return await claimReward({ userId, gameId, day: 1, prisma });
  });

in claimReward I used this

prisma: Prisma.TransactionClient;

prisma: Prisma.TransactionClient;

typescript will shout out me , once I remove the $.extends it works how do I grab the correct type

1 replies

PPrisma

•Created by Mohammad Orabi on 5/16/2024 in #help-and-questions

Setting Connection limit in gcp cloud run and cloud sql

What is the best practice when setting the connection limit of prisma in gcp cloud run? * I am using postgres from cloud sql * I have a master database with 14 cpu and 20GB ram * 3 replicas each with 10 cpus and 20GB ram , each can handle 500 connections * cloud run with multiple instances , each instance with 2 GiB memory and 2 cpus how can I know what is the best connection limit to set , as I noticed increasing them is disconnecting cloud run from the sql sometimes ps : I am using replicas extension

const prisma = new PrismaClient().$extends(
  readReplicas({
    url: DATABASE_URL_REPLICAS
  })
);

const prisma = new PrismaClient().$extends(
  readReplicas({
    url: DATABASE_URL_REPLICAS
  })
);

20 replies

Gaming

Programming