is there an easy way I can just run the migrations for a (simple) postgres database on a local sqlite instance for integration testing?

Hey there! If you are trying to run the actual

.sql

files from your

migration

folder, I don’t think they would work against SQLite if they were generated using a Postgres database. If you only cared about the end state of the database schema, you could potentially maintain a separate Prisma schema for your testing database. Then you could generate and import your SQLite Prisma Client in your integration tests. Relevant docs

ah I feared that would be the case, I was hoping there was a way to generate two sets of migrations from one schema