openblocks-dev / openblocks

🔥 🔥 🔥 The Open Source Retool Alternative
https://cloud.openblocks.dev
GNU Affero General Public License v3.0
5.88k stars 360 forks source link

[Feature Request] Dynamic datasource #297

Open devendrakhatri opened 1 year ago

devendrakhatri commented 1 year ago

For the use cases where we have multiple environments (DEV, UAT, PROD) and each environment has a dedicated database with exactly same schema. Is it possible to build one dashboard with an option to switch between environments ? With current datasource capability, looks like dashboard is tightly coupled with a specific database.

Can we think of passing datasource dynamically?

Probably we can call it "environment manager" which can manage all the base URLs, database,. etc. at single place and dashboard can switch to environments using dropdown list?

Environment Service 1 Database 1 Database 2
DEV S1_DS_Dev D1_DB_Dev D2_DB_Dev
UAT SX_DS_Uat D1_DB_Uat D2_DB_Uat
PROD SY_DS_Prod D1_DB_Prod D2_DB_Prod