Can't run pnpm supabase db push

[StefanSpeter]

Hello,

I was trying to set up this project to see how to integrate Clerk with supabase using the new third party auth.

First thing is when I run pnpm install I end up getting this warning :

 Warning ───────────────────────────────────────────────────────────────────────────────────╮
│                                                                                            
│   Ignored build scripts: @clerk/shared, esbuild, sharp, supabase.                          
│   Run "pnpm approve-builds" to pick which dependencies should be allowed to run scripts.   
│                                                                                            
╰─────────────────────────────────────────────────────────────────────────────────────────
 WARN  Failed to create bin at D:\Utilisateurs\user\Mes documents\forks\quillmate\node_modules\.bin\supabase. ENOENT: no such file or directory, stat 'D:\Ulisateurs\userr\Mes documents\forks\quillmate\node_modules\supabase\bin\supabase.EXE'

If I ignore and run
pnpm supabase db push
I get this error :
Cannot find project ref. Have you run supabase link?

As a beginner I'm not sure what to do / how to fix this, I thought it would have been pretty straight forward by following the readme.
I've tried to run pnpm approve-builds and select supabase but still no luck.

Lastly I've tried to implement all the SQL files by hand but got some errors, one was a typo that I corrected (and sent as a PR) and the other one was a conflict but maybe because I imported it by hand, so I will wait to be able to run the pnpm supabase db push command and try again before opening another issue.

Hope this helps!
Let me know if there is anything I can do to help/if you need more informations.

[bmorrisondev]

Hey there! Did you follow the readme to get the project setup?

Yeah you definitely caught a typo in the SQL. Thanks for submitting the PR!

[StefanSpeter]

Hi, no worries!

Yeah I did read it all and tried to follow it as it's explained, maybe something messed up when I've imported by hand the SQL file, I will give it another try and see.

[bmorrisondev]

Hey @StefanSpeter just wanted to check back in before closing this ticket. Did you ever run into any more issues?

[StefanSpeter]

I'm having issues running supabase db push.
I've ran supabase link, it works, then I run supabase db push but I get time out by their CLI. I'm looking to fix this and will get back to you asap!
I want to try to run it through supabase to have the same implementation as you do.

[modelfy]

Same issue here with running supabase db push.

[bmorrisondev]

Hey @StefanSpeter and @modelfy !

I updated the readme and added some missing steps (mainly pnpm supabase link) as well as cleaned up the migration files. Give it another try and let me know if either of you run into any issues. Thanks!