Deploy Vike app with Prisma + Telefunc + PostgreSQL to Cloudflare Pages

[jasonhilldm]

I have created a test project that pulls data from a PostgreSQL database using Telefunc and Prisma. I am using the Prisma PostgreSQL driver adapter (@prisma/adapter-pg). This all works fine when running locally, but when I deploy to Cloudflare Pages, I get the following error when trying to access the PostgreSQL database:

TypeError: this.stream.once is not a function
    at Connection.connect (bundledWorker-0.26617208076261756.mjs:19491:21)
    at Client._connect (bundledWorker-0.26617208076261756.mjs:20603:15)
    at Client.connect (bundledWorker-0.26617208076261756.mjs:20639:16)
    at BoundPool.newClient (bundledWorker-0.26617208076261756.mjs:21213:16)
    at BoundPool.connect (bundledWorker-0.26617208076261756.mjs:21195:14)
    at BoundPool.query (bundledWorker-0.26617208076261756.mjs:21342:14)
    at PrismaPg.performIO (bundledWorker-0.26617208076261756.mjs:22651:44)
    at PrismaPg.queryRaw (bundledWorker-0.26617208076261756.mjs:22609:32)
    at bundledWorker-0.26617208076261756.mjs:24340:24
    at bundledWorker-0.26617208076261756.mjs:28064:27

I should also mention that I had to use the following option in my wrangler.toml file:

compatibility_flags = [ "nodejs_compat_v2" ]

When I used just "nodejs_compat", the wrangler deployment failed with the following errors:

Could not resolve "path""
The package "path" wasn't found on the file system but is built into node.
Add the "nodejs_compat" compatibility flag to your Pages project and make sure to prefix the module name with "node:" to enable Node.js compatibility.

[brillout]

This as well seems to be a vike-cloudflare question @magne4000.

[magne4000]

I'm not really familiar with all prisma adapters, but wouldn't https://www.npmjs.com/package/@prisma/adapter-pg-worker solve your issue?

[jasonhilldm]

Thanks for the pointer. I gave that one a try and then received a different error:

TypeError: Illegal invocation: function called with incorrect `this` reference. See https://developers.cloudflare.com/workers/observability/errors/#illegal-invocation-errors for details.
    at bundledWorker-0.6505292954156219.mjs:17468:23
    at async PrismaPg.performIO (bundledWorker-0.6505292954156219.mjs:18462:26)
    at async PrismaPg.queryRaw (bundledWorker-0.6505292954156219.mjs:18420:21)
    at async bundledWorker-0.6505292954156219.mjs:20151:18

I can post this on the adapter discussion page.

[magne4000]

Indeed seems more related to the prisma packages usage with cloudflare than to vike-cloudflare itself.