I am trying to migrate from postgres to sqlite but it appears sqlite prisma client does not have

createMany

? What is the current best practice workaround?

@Ethan Joffe 👋 Running individual

create

statements inside a transaction would be the way to go. I am also interested in your use case in migrating from Postgres to SQLite 🙂

the use case is a mostly readonly db (occasional updates), so postgres is overkill since it would need full cloud infrastructure

Using the command line sqlite3 would probably be the fastest

yah but the point was to have prisma be integral

Sure, the native tools can do a great job for one time migrations sometimes