postgres in pages

how can i use postgres using sveltekit with pages and drizzle ORM?
im using

pg

pg

atm but im getting these errors when building;

18:24:51.574        node_modules/pg/lib/stream.js:21:20:
18:24:51.574          21 │   var tls = require('tls')
18:24:51.574             ╵                     ~~~~~
18:24:51.574    
18:24:51.575      Cannot use "tls" when deploying to Cloudflare.
18:24:51.575    
18:24:51.575    
18:24:51.575    ✘ [ERROR] Could not resolve "fs"
18:24:51.575    
18:24:51.575        node_modules/pgpass/lib/index.js:4:17:
18:24:51.575          4 │   , fs = require('fs')
18:24:51.575            ╵                  ~~~~
18:24:51.576    
18:24:51.576      Cannot use "fs" when deploying to Cloudflare.

18:24:51.574        node_modules/pg/lib/stream.js:21:20:
18:24:51.574          21 │   var tls = require('tls')
18:24:51.574             ╵                     ~~~~~
18:24:51.574    
18:24:51.575      Cannot use "tls" when deploying to Cloudflare.
18:24:51.575    
18:24:51.575    
18:24:51.575    ✘ [ERROR] Could not resolve "fs"
18:24:51.575    
18:24:51.575        node_modules/pgpass/lib/index.js:4:17:
18:24:51.575          4 │   , fs = require('fs')
18:24:51.575            ╵                  ~~~~
18:24:51.576    
18:24:51.576      Cannot use "fs" when deploying to Cloudflare.

Giraffe•1/15/25, 6:55 PM

Did you find a solution to this?

James•1/16/25, 10:29 PM

you'll need to connect at the request level, not app level, serverless pages can't maintain a db connect

James•1/16/25, 10:30 PM

also those libs dont work w cf workers, no fs access, there are other ways to connect to postgres, like neon

JJames you'll need to connect at the request level, not app level, serverless pages can...

Maraciuca•1/17/25, 8:25 AM

Had the same issues yesterday, this seems it would work (at least on a theoretical level, haven't tried it out yet)

Borut Svara•1/17/25, 2:54 PM

Have you tried a serverless client https://orm.drizzle.team/docs/connect-vercel-postgres ? NOT TESTED

Drizzle ORM - Vercel Postgres

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Ssanser how can i use postgres using sveltekit with pages and drizzle ORM? im using `pg`...

danim47c•1/17/25, 3:48 PM

My recomendation is to use Cloudflare Hyperdrive. It manages a kind of connection pool between workers and your database. Also, postgres-js driver is more recommended for serverless environments. Note that you need to set https://developers.cloudflare.com/workers/configuration/compatibility-flags/#nodejs-compatibility-flag.