nikolasburk
DROP DATABASE
and CREATE DATABASE
, due to insufficient privileges. Prisma Migrate so far relied on these statements to ensure the database is empty when it needs to be reset.
Database resets in the context of Prisma Migrate now gracefully fall back to dropping constraints, indexes and tables, if there are insufficient privileges to reset the database using DROP DATABASE
.
🚪 Improvements and changes for prisma db push
• prisma db push
now handles unexecutable migrations better, offering a path forward by resetting the database. For example, adding a new required field without a default value when there are rows in the table is considered an unexecutable migration; in such situations you will be prompted to first reset the database.
• Changes to command options:
• The flag —-force
has been renamed to --accept-data-loss
to be more explicit - this is required for certain changes that involve losing data, e.g. dropping a table or dropping a column if there are rows.
• We've added a new flag —-force-reset
which first resets the database and then updates the schema - this can useful to start from scratch and as a way to deal with unexecutable migrations (see above).
🌱 prisma db seed
now supports custom schema locations
You can now point the prisma db seed
command to a custom schema location using either of two approaches:
• Use the --schema
option when running the command
• Define a default schema location in your package.json
which will be picked up every time you run the command
🦟 Lots of bug fixes in Prisma Client, Prisma Migrate & Prisma Studio
Check out the release notes to learn about all the bugs and other issues that were fixed in this release!
📚 Learn more in the release notes
For more info and links to documentation, you can read the release notes.
🌟 Help us spread the word about Prisma 🌟
To help spread the word about Prisma, we'd very much appreciate if you would star the repo 🌟 And if you're excited about the features in this week's release, then help us and share your excitement on Twitter.
📰 Join us on Thursday for the "What's new in Prisma" livestream
As usual, my colleague @ryan and I will discuss the latest release and other news from the Prisma ecosystem in a livestream on on Thursday at 5pm Berlin | 8am San Francisco. This week, we'll be joined by our VP of Product @Hervé - Product at Prisma as well as by @User from KeystoneJS 😄