windmill-labs / windmill

Open-source developer platform to power your entire infra and turn scripts into webhooks, workflows and UIs. Fastest workflow engine (13x vs Airflow). Open-source alternative to Retool and Temporal.
https://windmill.dev
Other
10.44k stars 506 forks source link

feature: dynamically set source of database studio #3808

Open ImSingee opened 5 months ago

ImSingee commented 5 months ago

I want to change the database source with a select control dynamically.

image image

Both databases have nearly the same schema (just for two different environments), so I want to be able to change database sources easily via a select control. All other settings should remain the same.

fatonramadani commented 5 months ago

Hi,

You can have two Database Studios in a conditional tab component, and control which tab is displayed with the select:

https://www.windmill.dev/docs/apps/app_configuration_settings/conditional_tabs#component-controls

ImSingee commented 5 months ago

@fatonramadani Thanks for your recommendation! That's just what I'm doing now. But since my dev and prod environments are likely the same, I have to sync the two settings manually. And that's a bit tedious. And the state gets even worse since I have tens of tables and I also have more than two environments.