quary icon indicating copy to clipboard operation
quary copied to clipboard

[BUG] Postgres DB not available in onboarding menu

Open lockmeister opened this issue 1 year ago • 2 comments

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:

lockmeister avatar May 16 '24 08:05 lockmeister

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 avatar May 16 '24 09:05 louisjoecodes

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.

louisjoecodes avatar May 24 '24 18:05 louisjoecodes