Prisma

also, is it possible to make the datasource provider tied to an env variable or a config file ?

Hey :wave:
Welcome to our community! :raised_hands:

No, it’s not possible to provide datasource through env variables for now.

Here’s the reason for not allowing data source to be dynamic: <https://www.prisma.io/docs/concepts/components/prisma-migrate/prisma-migrate-limitations-issues#you-cannot-automatically-switch-database-providers>

If you have 2 SGB, look around Micro Services and Message Broker (RabbitMQ)

Here are the GitHub Issues which had discussion regarding making data source dynamic: <https://github.com/prisma/prisma/issues/1487|#1487> and <https://github.com/prisma/prisma/issues/3834|#3834>