PrismaP
Prisma•4mo ago•
2 replies
sylvester stallone

Guidance on migrating to Rust-free from TS?

We have a decently complex Prisma instantiation logic at the moment, but our bundle size is getting absolutely ridiculous at this point, our builds take ages to run and our IDEs are impossible to use so we really need to migrate from the Rust engine ASAP (our builds are failing). When I try to upgrade to the latest Prisma version, and start following the migratio

- How do we handle our instatiation logic? We have a pretty complex setup here, and none of the examples really account for extension usage, typing, etc. 

import type { Prisma } from '@prisma/client';
import { PrismaClient } from '@prisma/client';
import type { DynamicQueryExtensionArgs } from '@prisma/client/runtime/library';
import { readReplicas } from '@prisma/extension-read-replicas';
import { drizzle } from 'drizzle-orm/prisma/pg';

import { writeTriggersExtension } from './extensions/write-triggers/extension';
import { ensureDatabaseCert } from './prisma/certs';

declare const global: Global & {
  prisma?: ReturnType<typeof createPrismaClient>;
  prismaWithoutWriteTriggers?: ReturnType<typeof createPrismaClient>;
};

export let prisma: ReturnType<typeof createPrismaClient>;
export let prismaWithoutWriteTriggers: ReturnType<typeof createPrismaClient>;

export function createPrismaClient(
  queryExtension?: DynamicQueryExtensionArgs<
    {
      [K in Prisma.TypeMap['meta']['modelProps'] | '$allModels']?: unknown;
    },
    Prisma.TypeMap
  >,
  options?: {
    withWriteTriggers?: boolean;
  },
) {
  if (
    process.env.DATABASE_URL &&
    !process.env.DATABASE_URL.includes('localhost')
  ) {
    ensureDatabaseCert();
  }

  const { withWriteTriggers = true } = options ?? {};
  const client = new PrismaClient()
    .$extends({
      query: {
        ...(queryExtension ?? {}),
      },
    })
    .$extends(withWriteTriggers ? writeTriggersExtension : {})
    .$extends(drizzle());

  // ALWAYS KEEP READ REPLICAS EXTENSION LAST THIS IS A LIMITATION OF THE PRISMA EXTENSION
  return client.$extends({
    ...readReplicas({
      url: [
        process.env.DB_REPLICA_URL_1 ?? '',
        process.env.DB_REPLICA_URL_2 ?? '',
      ],
    }),
  });
}

if (typeof window === 'undefined') {
  if (process.env['NODE_ENV'] === 'production') {
    prisma = createPrismaClient();

    prismaWithoutWriteTriggers = createPrismaClient(undefined, {
      withWriteTriggers: false,
    });
  } else {
    if (!global.prisma) {
      global.prisma = createPrismaClient();
    }

    if (!global.prismaWithoutWriteTriggers) {
      global.prismaWithoutWriteTriggers = createPrismaClient(undefined, {
        withWriteTriggers: false,
      });
    }

    prisma = global.prisma;
    prismaWithoutWriteTriggers = global.prismaWithoutWriteTriggers;
  }
}



- We use Supabase, and there are no drivers for Supabase at the moment; what should we use here? If I use the pg adapter, I get the following build error: 

@hou/web:build: Failed to compile.
@hou/web:build: 
@hou/web:build: ../../node_modules/pg/lib/connection-parameters.js:3:1
@hou/web:build: Module not found: Can't resolve 'dns'
@hou/web:build: 
@hou/web:build: https://nextjs.org/docs/messages/module-not-found
@hou/web:build: 
@hou/web:build: Import trace for requested module:
@hou/web:build: ../../node_modules/pg/lib/client.js
@hou/web:build: ../../node_modules/pg/lib/index.js
@hou/web:build: ../../node_modules/@prisma/adapter-pg/dist/index.mjs
@hou/web:build: ../../packages/db/client.ts
@hou/web:build: ../../packages/common-services/src/utils/feature-gates.ts
@hou/web:build: ../../packages/common-services/src/utils/index.ts
@hou/web:build: ./src/components/application-review/cards/assignment/phase-reason-view.tsx
@hou/web:build: ./src/components/application-review/cards/assignment/assignment-phases.tsx
@hou/web:build: ./src/components/application-review/application-review.tsx
@hou/web:build: ./src/pages/admin/applicants/review/[[...ids]].tsx
Was this page helpful?