Are there any postgres migration libs that work on pages?

I use drizzle as an orm and it has a postgres-js adapter which works fine. but when I try to apply migrations using that adapter, cloudflare throws build errors because the migration client uses node:fs, which isnt supported on pages.

Are there any alternative ways to apply sql migration files to my postgres database?

zach•3/22/24, 4:33 AM

do you have node compat enabled

zach•3/22/24, 4:33 AM

alternative ways:

manually run migrations
run migrations in CI

Zzach do you have node compat enabled

x03OP•3/23/24, 8:42 PM

Yes, I have the nodejs_compat flag in the pages settings. Currently I just manually run the migrations through the connection string with my client. Exploring alternative migration tools that could hopefully automate this though.

zach•3/23/24, 9:37 PM

ohh, I know why when I think about it

zach•3/23/24, 9:38 PM

workers are just one .js file, and run in a context without a filesystem

zach•3/23/24, 9:38 PM

so no fs api is integrated (other than workers sites/adding them at build time)

zach•3/23/24, 9:39 PM

I'd go with a ci pipeline that runs them

zach•3/23/24, 9:39 PM

for me, doing it manually isn't that big of a chore — you only need migrations when you change the schema

Zzach for me, doing it manually isn't that big of a chore — you only need migrations w...

x03OP•3/23/24, 11:31 PM

Honestly this seems like the move. Migrations rarely happen so doing them manually isn't that big of a deal. I'll probably not waste any more time on this and just continue manually migrating. Thanks for your time and help!

Are there any postgres migration libs that work on pages?

Similar Threads

Similar Threads

Similar Threads