Creating Dynamic ConfigProviders for Environment and Remote Database

I'm facing a case where I have to create a

ConfigProvider

ConfigProvider

dynamically. The

standalone

standalone

provider should read from the environment, but the

remote

remote

provider should read the configuration from a (remote) database. I saw that the

fromXX

fromXX

functions on the

ConfigProvider

ConfigProvider

are all synchronous. Pretty sure I'm missing something, but is there a way where I could basically do a

ConfigProvider.fromEffect

ConfigProvider.fromEffect

? In the end I want to create a

ManagedRuntime

ManagedRuntime

to which I pass the layer resulting from

Layer.setConfigProvider

Layer.setConfigProvider