Bardia Posts - Answer Overflow

Bardia

•Created by Bardia on 12/11/2023 in #help

Migration timing out in Next.js Route

I am building an app where I am provisioning user's their own databases in Neon. I am currently running into an issue where after I create the user's database and connect to it, I try and run the migrate function and it just times out. Not sure if I'm doing it incorrectly or not. I tried with two variations of the path to the migrations folder:

await migrate(userDb, {
        migrationsFolder: path.join(process.cwd(), 'drizzle/user/migrations'),
      });

await migrate(userDb, {
        migrationsFolder: path.join(process.cwd(), 'drizzle/user/migrations'),
      });

await migrate(userDb, {
        migrationsFolder: './drizzle/user/migrations'
      });

await migrate(userDb, {
        migrationsFolder: './drizzle/user/migrations'
      });

Neither have worked. I know this isn't a typical use case but I'm not sure if I'm doing something wrong, it's not supported or if there are any workarounds?

5 replies

Gaming

Programming