●Change8

6.3.0

📦 prismaView on GitHub →
✨ 6 features🐛 3 fixes🔧 7 symbols

Summary

Prisma 6.3.0 introduces a revamped Prisma Studio, adds 'limit' support to bulk update and delete operations, and improves PostgreSQL performance by switching to 'NOT EXISTS' for relation filters.

Migration Steps

  1. Run 'prisma db pull' to apply the new deterministic sorting to your schema generator blocks (note: fields may re-order once during this first run).

✨ New Features

  • Added 'limit' support to updateMany() and deleteMany() queries to restrict the number of affected rows.
  • Introduced a brand new Prisma Studio with a model viewer, edit sidebar, and 'Close all' functionality.
  • Prisma Studio is now available in the Prisma Console for PostgreSQL and MySQL databases.
  • Fields inside 'generator' blocks in the Prisma Schema are now sorted deterministically.
  • Replaced 'NOT IN' with 'NOT EXISTS' for PostgreSQL relation filters (none/some) to improve performance.
  • Added 'onUpdate' data to the DMMF in @prisma/generator-helper.

🐛 Bug Fixes

  • Fixed issue where interactive transactions ignored DB exceptions on commit when using triggers (#17303).
  • Fixed non-deterministic sorting of generator fields during 'prisma db pull' (#17899).
  • Fixed 'no entry found for key' error occurring on views-to-model relations (#19249).

🔧 Affected Symbols

updateManydeleteManyprisma.user.deleteManyprisma.user.updateManygenerator@prisma/generator-helperDMMF