Prisma 3.7.0 — Release Notes & Engineering Impact

Today, we are excited to share the `3.7.0` stable release 🎉 🌟 **Help us spread the word about Prisma by starring the repo or [tweeting](https://twitter.com/intent/tweet?text=Check%20out%20the%20latest%20@prisma%20release%20v3.7.0%20%F0%9F%9A%80%0D%0A%0D%0Ahttps://github.com/prisma/prisma/releases/tag/3.7.0) about the release.** 🌟 ## Major improvements ### Referential actions support for MongoDB In `3.7.0`, we've added MongoDB support for `onDelete` and `onUpdate` to specify how you want to handle changes to relationships. MongoDB does not support referential actions out of the box, but we can emulate this feature inside the Prisma Query Engine. Given the following schema: ```diff model User { id String @id @default(dbgenerated()) @map("_id") @db.ObjectId posts Post[] name String } model Post { id String @id @default(dbgenerated()) @map("_id") @db.ObjectId + author User @relation(fields: [userId], references: [id], onDelete: Cascade) - author User @relation(fields: [userId], references: [id]) title String userId String @db.ObjectId } ``` By specifying `onDelete: Cascade`, Prisma will also delete posts whenever the author of the posts is deleted. There's a lot more to referential actions than cascading deletes. Head over to [our documentation](https://www.prisma.io/docs/concepts/components/prisma-schema/relations/referential-actions) to learn more. Prisma exposes features and workflows that database vendors don't offer. ### Prevent referential cycles on MongoDB As part of getting `onDelete` and `onUpdate` ready for MongoDB, we’ve tightened up our validation rules to prevent a potential stack overflow if you create a loop with referential actions. This change may cause some existing schemas using the `mongodb` preview feature to become invalid, where your schema now errors out with the following message: ```bash Error parsing attribute "@relation": Reference causes a cycle. ``` If you run into this, you can learn how to resolve it with [this documentation](https://www.prisma.io/docs/concepts/components/prisma-schema/relations/referential-actions/special-rules-for-referential-actions). If you’re still stuck, feel free to open [a discussion](https://github.com/prisma/prisma/discussions/new) and we’ll lend a hand! ### Deprecating undocumented usage of `type` in Prisma Schema With Prisma `3.7.0` release, the [Prisma VS Code extension](https://marketplace.visualstudio.com/items?itemName=Prisma.prisma) (and other IDEs using our [language server implementation](https://www.npmjs.com/package/@prisma/language-server)) will start to show a warning when detecting unsupported usage of the `type` keyword. An example of that is string aliasing: ```prisma type MyId = String @id @default(dbgenerated(new_uuid())) model A { id MyId } ``` We plan to remove that functionality entirely with the next major release of Prisma. If you happen to depend on similar functionality for type aliasing, please leave a comment on the [issue](https://github.com/prisma/prisma/issues/9939). ### Prisma Studio - Due to how Prisma Studio executes Prisma Client queries, it was possible to execute arbitrary code on Studio’s local server. This has since been patched. - Issues with viewing and updating models with `BigInt` fields are also resolved. ## Fixes and improvements ### Prisma Client - [Run (most) tests on all operating system](https://github.com/prisma/prisma/issues/7725) - [EPERM: operation not permitted, unlink '...node_modules\prisma\query_engine-windows.dll.node'](https://github.com/prisma/prisma/issues/9184) - [Overflowing stack on cyclic actions](https://github.com/prisma/prisma/issues/9931) - [Implement a cockroachdb datamodel connector (Validations, for Prisma Client API adaptations)](https://github.com/prisma/prisma/issues/10514) - ["No X found" error thrown from a findUnique query does not show a stack trace](https://github.com/prisma/prisma/issues/10641) ### Prisma Migrate - [SQL Server: `prisma generate` fails with error "memory allocation of [86GB] failed"](https://github.com/prisma/prisma/issues/10621) ### Language tools (e.g. VS Code) - [Auto completion work for "Expanded Index Capabilities"](https://github.com/prisma/language-tools/issues/926) - [Make auto completion preview feature flag aware](https://github.com/prisma/language-tools/issues/962) - [The package-lock.json file was created with an old version of npm](https://github.com/prisma/language-tools/issues/969) - [prisma-fmt panic on schema with `@@fulltext(fields:[])` or `@@fulltext([])` or `@@index([])` or `@@unique([])`.](https://github.com/prisma/language-tools/issues/995) ## Credits Huge thanks to @otan, @benkroeger, @YassinEldeeb, @chenkie for helping! ## 📺 Join us for another "What's new in Prisma" livestream Learn about the latest release and other news from the Prisma community by joining us for another ["What's new in Prisma Holiday Special"](https://youtu.be/ohS25OtGdsc) livestream. The stream takes place [on YouTube](https://youtu.be/ohS25OtGdsc) on **Tuesday, December 21** at **5 pm Berlin | 8 am San Francisco**.