grace charles Comments - Answer Overflow

grace charles

•Created by grace charles on 4/18/2025 in #help-and-questions

Anyone have Prisma ORM working with React Router 7? I get Internal server error

Digging around in the index-browser.js file I think I found the problem ... we're importing PrismaClient from ../generated/prisma. Once I changed that to @prisma/client then it started working. Might want to update the documentation on that.

7 replies

PPrisma

•Created by grace charles on 3/22/2024 in #help-and-questions

Pulse error: Could not reach the specified datasource db url

understood and agreed. this is most helpful. thank you so much for pointing me in a good direction! you are awesome!!!

37 replies

PPrisma

•Created by grace charles on 3/22/2024 in #help-and-questions

Pulse error: Could not reach the specified datasource db url

essentially intercepting a create to the webhooks table, fire/forget an async function for processing the webhook and meantime allowing the create to proceed as normal.

37 replies

PPrisma

•Created by grace charles on 3/22/2024 in #help-and-questions

Pulse error: Could not reach the specified datasource db url

oh interesting ... I think i see what you mean. I just did a bit of reading on a client extension, and it looks like I can modify a query operation on a given table. so perhaps something along these lines might do what we need:

const prisma = globalForPrisma.prisma || new PrismaClient().$extends({
  query: {
    webhooks: {
      async create({ model, operation, args, query }) {
        processWebhook();
        return query(args);
      }
    }
  }
});

const prisma = globalForPrisma.prisma || new PrismaClient().$extends({
  query: {
    webhooks: {
      async create({ model, operation, args, query }) {
        processWebhook();
        return query(args);
      }
    }
  }
});

37 replies

PPrisma

•Created by grace charles on 3/22/2024 in #help-and-questions

Pulse error: Could not reach the specified datasource db url

Yes, updates are just through Prisma ORM, other than using raw sql query for one table where we need to store encrypted tokens and Prisma doesn't seem to support pgp_sym_encrypt. But I don't quite follow what you mean by "a client extension". If you wouldn't mind elaborating, that would be most apprecaited! The use case we have is this: on webhook receipt, we want to store the webhook info into a table and reply back immediately with a 200 next response. And then have some way to fire off a series of actions once that particular table is updated. So the "trigger" we need is new entry created in 'webhook' table. Hopefully that makes sense.

37 replies

PPrisma

•Created by grace charles on 3/22/2024 in #help-and-questions

Pulse error: Could not reach the specified datasource db url

You got it - will do. And thank you for taking time on a Friday night to help. Most appreciated. One final question if I might: do you know if Prisma ORM supports working with Postgres event triggers. Really we just need a way to take action when a particular table is updated.

37 replies

PPrisma

•Created by grace charles on 3/22/2024 in #help-and-questions

Pulse error: Could not reach the specified datasource db url

OK, thanks for your help. It's back to the drawing board for us to create a semblance of real-time update triggers. Was really hoping Pulse would be the answer.

37 replies

PPrisma

•Created by grace charles on 3/22/2024 in #help-and-questions

Pulse error: Could not reach the specified datasource db url

We don't use Accelerate - so this is all new to us.

37 replies

PPrisma

•Created by grace charles on 3/22/2024 in #help-and-questions

Pulse error: Could not reach the specified datasource db url

That's too bad. I was hoping the Enable Pulse stuff was just to get an API key and that at that point the port could be closed and that the local @prisma/extension-pulse would handle the communication without needing to report back to your servers

37 replies

PPrisma

•Created by grace charles on 3/22/2024 in #help-and-questions

Pulse error: Could not reach the specified datasource db url

Speaking of AWS though, how would you recommend running in production? Would users need to publicly expose their database just so Prisma can "talk" to it? If so, that would be a showstopper for us.

37 replies

PPrisma

•Created by grace charles on 3/22/2024 in #help-and-questions

Pulse error: Could not reach the specified datasource db url