When using

prisma migrate

, what are people using to deal with indexes and other "non-Prisma" stuff for migrations? A separate migration setup?

Hey @zth 👋 One thing you could do for custom indexes, functions and triggers is to manage it via SQL files and add a post migrate script that runs those SQL files or use another migration system like node-pg-migrate specifically for those.

Are post migrate scripts fully functional currently? I feel like the last time I checked they never got executed

I was more specifically talking about post migrate script via NPM scripts. So after running Prisma’s Migrate, you could run you own migrations automatically if successful .

Would be great if that could get implemented in prisma migrate - iirc when I looked into it there was some references to calling scripts in the migration directory before/after the migration run, but they're just not executed

Something like that is already in a feature request that you can follow.

Ah great thanks!