unable to use migrations - Drizzle Team

ethan

E

ethanOP•3/18/24, 4:46 AM

fixed that error but now im getting this

ethan

Eethan fixed that error but now im getting this

Naeemgg

N

Naeemgg•3/18/24, 7:46 AM

can you show db and client file

Naeemgg

N

Naeemgg•3/18/24, 7:46 AM

maybe something is off there

Mykhailo

M

Mykhailo•3/18/24, 12:15 PM

@ethan do you get this error when you run migrations? Could you please provide migration code?

Naeemgg

NNaeemgg can you show db and client file

ethan

E

ethanOP•3/19/24, 5:28 PM

Mykhailo

MMykhailo @ethan do you get this error when you run migrations? Could you please provide m...

ethan

E

ethanOP•3/19/24, 5:29 PM

yep only when i run migrations. generating works fine though. what do you mean by the migration code? this is the js im using for that but if you mean the sql file thats generated lmk

Naeemgg

N

Naeemgg•3/19/24, 5:30 PM

You can use try catch within migrateDB and just call it after

Naeemgg

N

Naeemgg•3/19/24, 5:30 PM

Can you successfully run

Naeemgg

NNaeemgg Can you successfully run `drizzle-kit generate:pg`

ethan

E

ethanOP•3/19/24, 5:32 PM

yes it works for me

Naeemgg

N

Naeemgg•3/19/24, 5:32 PM

drizzle-kit introspect:pg

Naeemgg

N

Naeemgg•3/19/24, 5:32 PM

?

ethan

E

ethanOP•3/19/24, 5:33 PM

also works

Naeemgg

N

Naeemgg•3/19/24, 5:40 PM

Naeemgg

N

Naeemgg•3/19/24, 5:40 PM

You got connection string right

Naeemgg

N

Naeemgg•3/19/24, 5:40 PM

Then what could possibly the cause

Naeemgg

N

Naeemgg•3/19/24, 5:41 PM

Have you tried to delete and reinstall node modules??

Naeemgg

N

Naeemgg•3/19/24, 5:41 PM

Sometimes it does the job

ethan

E

ethanOP•3/19/24, 5:41 PM

yep ive tried deleting the whole project and recloning

ethan

E

ethanOP•3/19/24, 5:42 PM

and my friend is also getting the error on his end

ethan

E

ethanOP•3/19/24, 5:42 PM

connection string should be right drizzle is working fine for CRUD

Naeemgg

N

Naeemgg•3/19/24, 5:42 PM

Just to be clear, you're using postgres on localhost right?

ethan

E

ethanOP•3/19/24, 5:42 PM

yeah but im not hosting the db locally

ethan

E

ethanOP•3/19/24, 5:43 PM

im using supabase

Naeemgg

N

Naeemgg•3/19/24, 5:44 PM

Let me try it with supabase

Naeemgg

N

Naeemgg•3/19/24, 5:44 PM

I've tried with every driver except supabase and node

ethan

E

ethanOP•3/19/24, 5:45 PM

gotcha

ethan

E

ethanOP•3/19/24, 5:45 PM

im honestly just following this tutorial

ethan

E

ethanOP•3/19/24, 5:45 PM

1s

ethan

E

ethanOP•3/19/24, 5:45 PM

https://orm.drizzle.team/learn/migrate/migrate-from-prisma

Drizzle ORM - Migrate from Prisma to Drizzle

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

ethan

E

ethanOP•3/19/24, 5:46 PM

step 4 is where im stuck at

variable_name

V

variable_name•4/9/24, 1:19 PM

Hey, how did you solve this problem? I'm running into same issue.

variable_name

Vvariable_name Hey, how did you solve this problem? I'm running into same issue.

Naeemgg

N

Naeemgg•4/18/24, 6:36 AM

supabase?

variable_name

V

variable_name•4/18/24, 8:14 AM

It's fixed. There were some issues with environment variables in turbo repo.