supabase-community / database-build

In-browser Postgres sandbox with AI assistance (formerly postgres.new)
https://database.build
Apache License 2.0
2.49k stars 197 forks source link

Issue with latest version of postgres-new UI when running npm i #125

Open dlado opened 1 month ago

dlado commented 1 month ago

I downloaded the latest code and run "npm i" and I'm getting errors.

The main problem seems to be with node-gyp when it tries to build the pgsql-parser package. It throws an error (MSB8066) related to build\queryparser.vcxproj, saying it can’t find the necessary binaries for my setup. This is because after some intents to get the binaries, it tries to compile them..

Here is what I'm getting. I tried to switch node versions, uninstall and install everything, install all the prerequisits for node-gyp and nothing....same error..... : image

What I don't understand is that when trying to get https://supabase-public-artifacts-bucket.s3.amazonaws.com/libpg-query-node/queryparser-v13.3.2-node-v108-win32-x64.tar.gz is not fond and is true....

If you look into https://supabase-public-artifacts-bucket.s3.amazonaws.com/ is not found.

Maybe is something wrong with the current version?

gregnr commented 1 month ago

Hey @dlado, thanks for reporting. This is actually an issue we're also facing in the main Supabase repo (affects Windows users only). We have a plan for a fix but it is still WIP. In the mean time if you are able to run this project under WSL2, that should resolve this issue.