Problem
The migrate dev or migrate reset commands in Prisma Migrate require a shadow database. Prisma Migrate assumes the same credentials used for the development database can be used to create it. When using a local DBMS, this can be achieved by granting the user privileges to create new databases.
Some of our users develop on the cloud and don't run their DBMS locally. This prevents these users from using Prisma Migrate in development unless they switch to using a local DBMS.
Solutions
We could allow users to provide a URL to a shadow database that can be used as the shadow database. Example: a user could provision two Postgres databases on Heroku, one for the development another the shadow database.
In order to do this, we'd need to enable a way to supply this configuration, i.e., config file, env variable, etc.
Problem
The
migrate devormigrate resetcommands in Prisma Migrate require a shadow database. Prisma Migrate assumes the same credentials used for the development database can be used to create it. When using a local DBMS, this can be achieved by granting the user privileges to create new databases.Some of our users develop on the cloud and don't run their DBMS locally. This prevents these users from using Prisma Migrate in development unless they switch to using a local DBMS.
Solutions
We could allow users to provide a URL to a shadow database that can be used as the shadow database. Example: a user could provision two Postgres databases on Heroku, one for the development another the shadow database.
In order to do this, we'd need to enable a way to supply this configuration, i.e., config file, env variable, etc.