[BUG] Postgres DB not available in onboarding menu

quarylabs / quary

Open-source BI for engineers

https://www.quary.dev

Apache License 2.0

2.14k stars 48 forks source link

[BUG] Postgres DB not available in onboarding menu #207

Open lockmeister opened 3 months ago

lockmeister commented 3 months ago

Current Behavior:

installed quary VSCode extension
have existing postgres environment variables set, psql can connect
when "Quary: Initialise project" is run, postgres is not available as a choice

Expected Behavior:

Postgres to be available as a dropdown option.

Steps To Reproduce:

Environment:

louisjoecodes commented 3 months ago

Thanks for flagging! A workaround for now is to define the quary.yaml file manually and use the Quary: Import Sources command.

This Supabase/Postgres guide should get you to the same place for the time being: https://www.quary.dev/docs/quickstart-supabase

louisjoecodes commented 3 months ago

To introduce onboarding to databases that call out to the CLI (Postgres, now BigQuery etc.) we will need to introduce a headless mode that allows retrieving the list of projects and tables via the API without relying on a quary.yaml file. This will require some refactoring of the Rust database classes to support this functionality.