Hello, been using prisma in a few projects and love it. However I am very disappointed I ran into an issue that makes prisma unstable and unfit for production envornment and I can no longer trust it on projects as it will break and not allow updates to the databse. Everything was going fine until updating prisma to 4.1.0, then trying to run the npx primsa migrate dev command after a very minor scheme update. there was an error saying prisma@latest was not installed or could not be found. I attempted to toruble shoot this without having to reset all the data in my database but found that to be impossible. No matter what the case prisma always required complete data reset.

Hey there 👋, Sorry to hear about your poor experience! Could you perhaps give me some more details so I can pass this feedback on to our engineering teams? What version of Prisma did you update from? Exactly what kind of schema change did you make? Do you have the exact error message you received?

Updated through npm, tried to run prisma migrate dev, got error something like could not find prisma@latest and some others. I ran prisma generate, I tried db push, I tried db pull I tried removing my migrations, I tried following the steps in your documentation regarding drift. Nothing worked and there was no option to retain database, I was always asked "this will wipe your data, are you sure" when attempting to use prisma migrate dev. So that's what I did and it's very inconveinenent to have to do that If I have to do that everytime you update prisma, I'm out and I was planning to be an ambassador for you but this is too much trouble. I can't be your beta tester.